Overview
This five-day instructor-led course provides students with the knowledge and skills to maintain a Microsoft SQL Server 2008 R2 database. The course focuses on teaching individuals how to use SQL Server 2008 R2 product features and tools related to maintaining a database.

Duration
5 days

Target Audience
The primary audience for this course is individuals who administer and maintain SQL Server databases. This course can also be helpful for individuals who develop applications that deliver content from SQL Server databases.

Topics

Introduction to SQL Server 2008 R2 and its Toolset

Preparing Systems for SQL Server 2008 R2

Installing and Configuring SQL Server 2008 R2

Working with Databases

Understanding SQL Server 2008 R2 Recovery Models

Backup of SQL Server 2008 R2 Databases

Restoring SQL Server 2008 R2 Databases

Importing and Exporting Data

Authenticating and Authorizing Users

Assigning Server and Database Roles

Authorizing Users to Access Resources

Auditing SQL Server Environments

Automating SQL Server 2008 R2 Management

Configuring Security for SQL Server Agent

Monitoring SQL Server 2008 R2 with Alerts and Notifications

Performing Ongoing Database Maintenance

Tracing Access to SQL Server 2008 R2

Monitoring SQL Server 2008 R2

Managing Multiple Servers

Troubleshooting Common SQL Server 2008 R2 Administrative Issues

A more comprehensive course outline is available in the Course Download section, to the right of this page.

MTC serves the whole of the North East region, including, Sunderland, Newcastle, Durham Teesside, Tyne and Wear, Cumbria, Northumberland, Darlington, North Yorkshire, Carlisle, Hartlepool. In addition MTC supports many clients nationally within the UK.