• MCDBA (Microsoft Certified Database Administrator) certification or equivalent knowledge.
• Development experience with Microsoft SQL Server 2000 or Microsoft SQL Server 7.0.
• Knowledge of SQL Server 2000 / 7.0
  • Installation and configuration.
  • Database recovery
  • Database and server monitoring
  • Database and server architecture
  • SQL Server technologies used for database availability such as log shipping and clustering
  • Database security
  • Job automation
  • Troubleshooting
  • Replication
    
• In addition, it is recommended, but not required, that students have completed Course 2072, Administering a Microsoft SQL Server 2000 Database

• Describe the architecture of SQL Server 2005.
• Install SQL Server 2005.
• Use SQL Server 2005 administrative tools and utilities.
• Maintain SQL Server 2005 servers and databases.
• Secure a SQL Server 2005 server and database.
• Monitor SQL Server 2005.
• Implement a Backup and Restore solution for SQL Server 2005.
• Implement a data availability solution with database mirroring or clustering.
• Use enhanced SQL Server 2005 replication features

Module 1: SQL Server 2005 Architecture Overview
• Overview of SQL Server 2005
• System Enhancements for Administrators

Module 2: : Installing SQL Server 2005
• Preparing to Install SQL Server 2005
• Performing a SQL Server 2005 Installation
• Maintaining a SQL Server 2005 Installation

Module 3: SQL Server 2005 Administrative Tools
• Using SQL Server Workbench
• Using SQL Server Computer Manager
• Using the sqlcmd Utility
• Using the SQL Management Objects

Module 4: Monitoring SQL Server 2005
• Using SQL Profiler
• Using DDL Triggers
• Using Event Notifications
• Using the System Virtual Tables
Module 5: Maintaining Databases and Indexes
• Using the Database Maintenance Plan Wizard
• Managing Indexes
• Using the Database Tuning Advisor

Module 6: Securing SQL Server 2005
• SQL Server 2005 Security Overview
• Managing SQL Server 2005 Security
• SQL Agent Security

Module 7: Disaster Recovery
•  Disaster Recovery in SQL Server 2005
•  Using Database Snapshots
•  Backup and Restore Operations

Module 8: Data Availability
• Introduction to Data Availability
• Introduction to Database Mirroring
• Configuring Database Mirroring

Module 9: Replication
• Overview of Replication Enhancements
• New Types of Replication
• Configuring Replication