• MCDBA certification or equivalent knowledge.
• Administration experience with Microsoft SQL Server 2000 or Microsoft SQL Server 7.0.
• Knowledge of SQL Server 2000/7.0:

·         Database and server architecture.

·         Installation and configuration.

·         Database security.

·         Database recovery (backup and restore).

·         SQL Server technologies used for database availability such as log shipping and clustering.

·         Job automation.

·         Database and server monitoring.

·         Troubleshooting.

·         Replication.

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

• Course 2072, Administering a Microsoft SQL Server 2000 Database
• Directory Infrastructure.

Microsoft Certified Professional Exams

No Microsoft Certified Professional exams are associated with this course currently 

Course Outline

·         Overview of SQL Server 2005 Architecture

·         Installing SQL Server 2005

·         SQL Server 2005 Administrative Tools

·         Monitoring SQL Server 2005

·         Maintaining Databases and Indexes

·         Securing SQL Server 2005

·         Disaster Recover

·         Data Availability in SQL Server 2005

·         SQL Server 2005 Replication