Overview This learning product will enable database administrators experienced in SQL Server 2000/7.0 and Analysis Services to upgrade their skills to SQL Server 2005 so that they can support, configure, and maintain enterprise SQL Server 2005 databases and servers
Objectives
Audience
Prerequisites 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.