MS2733 Updating Your Database Administration Skills to Microsoft SQL Server 2005

Experienced database administrators and database developers who are responsible for the supporting, configuring, and maintaining enterprise SQL Server 2005 databases and servers.

Delegates will learn how to:
- Describe the architecture of SQL Server 2005
- Install SQL Server 2005
- Maintain SQL Server 2005 servers and databases
- Secure a SQL Server 2005 server and database
- Monitor SQL Server 2005
- Implement a data availability solution with database mirroring or clustering
- Use enhanced SQL Server 2005 replication features
- Implement a Backup and Restore solution for SQL Server 2005
- Use SQL Server 2005 administrative tools and utilities

Before attending this course, students must have:

- 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 MS2072, Administering a Microsoft SQL Server 2000 Database.

Module 1: Overview of SQL Server 2005 Architecture

Module 2: Installing SQL Server 2005

Module 3: SQL Server 2005 Administrative Tools

Module 4: Monitoring SQL Server 2005

Module 5: Maintaining Databases and Indexes

Module 6: Securing SQL Server 2005

Module 7: Disaster Recovery

Module 8: Data Availability in SQL Server 2005

Module 9: SQL Server 2005 Replication