Course: MS2780 Maintaining a Microsoft SQL Server 2005 Database

This five-day instructor-led course provides students with the knowledge and skills 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.

This course is intended for IT Professionals who want to become skilled on SQL Server 2005 product features and technologies for maintaining a database.

Before attending this course, students must have:

Basic knowledge of the Microsoft Windows operating system and its core functionality.
Working knowledge of Transact-SQL.
Working knowledge of relational databases.
Some experience with database design

In addition, it is recommended, but not required, that students have completed:

MS2778: Writing Queries Using Microsoft SQL Server 2005 Transact-SQL.
MS2779: Implementing a Microsoft SQL Server 2005 Database.

Delegates will learn how to:

Install and configure SQL Server 2005.
Manage database files.
Backup and restore databases.
Manage security.
Monitor SQL Server.
Transfer data into and out of SQL Server.
Automate administrative tasks.
Replicate data between SQL Server instances.
Maintain high availability.

Module 1: Installing and Configuring SQL Server 2005

Module 2: Managing Databases and Files

Module 3: Disaster Recovery

Module 4: Managing Security

Module 5: Monitoring SQL Server

Module 6: Transferring Data

Module 7: Automating Administrative Tasks

Module 8: Implementing Replication

Module 9: Maintaining High Availability