This three-day instructor-led course provides students with product knowledge and skills needed to implement 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.

Duration: 3 Days

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

Before attending this course, students must have:
Basic knowledge of the Microsoft Windows operating system & 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:
Course 2778: Writing Queries Using Microsoft SQL Server Transact-SQL
MS-2779: Implementing a Microsoft SQL Server 2005 Database