Course Ref: 42126

Course: MS2780 Maintaining a Microsoft SQL Server 2005 Database

Course Summary

This three-day instructor-led course provides students with product knowledge and skills needed to maintain a Microsoft SQL Server 2005 database.

The course focuses on teaching individuals how to use SQL Server 2005 product features and tools related to maintaining a database.

Course Outline

The course consists of 9 Modules:

Installing and Configuring SQL Server 2005
Managing Databases and Files
Managing Security
Disaster Recovery
Monitoring SQL Server
Transferring Data
Automating Administrative Tasks
Maintaining High Availability
Introduction to Replication

By the end of the course, delegates will be able to:

  •      Install and configure SQL Server 2005
  •      Manage database files.
  •      Manage security.
  •      Perform administrative tasks.
  •      Backup databases.
  •      Restore databases.
  •      Monitor SQL Server.
  •      Troubleshoot SQL Server.
  •      Transfer data.
  •      Maintain high availability.

Where & When

LocationLondon - East End
Start Date3 Nov 08
Price (ex. VAT)£995.00
Venue Info London - Old Broad Street
ResidentialNo
AvailabilityFull
Duration5 days
Delivered AsVenue and on-site
Pre-course Reading
No precourse reading is specified.
Exam IncludedNo
Course Ref42126