Target Audience: This course will teach database professionals who are already proficient in the implementation and maintenance of enterprise databases about the core architecture of Microsoft SQL Server 2000 and how it works. It is for database administrators who are experienced and proficient with enterprise database products such as Oracle, DB2, or Sybase and current database administrators who are experienced with Microsoft SQL Server 6.5 and earlier.

Pre-requisites: Before attending this course, students must have the following prerequisites:

• Database administrators who are experienced in Oracle, DB2, or Sybase. These database administrators have a technical depth of understanding of the database management systems (DBMS) that they currently administer, implement, and manage, and want to apply their database skills to SQL Server 2000.
• Database administrators who are experienced in Microsoft SQL Server 4.2x, 6.0, or 6.5. (Secondary): These database administrators have a technical depth of understanding of the database systems that they currently administer, implement, and manage, and want to apply their current skills to SQL Server 2000.
• To be successful in this class, students should have experience in administration and implementation of departmental or enterprise relational database management systems (RDBMS).

Purpose: After completing this course, students will be able to describe the architecture of SQL Server and its programming environment; describe the key components of SQL Server architecture; describe the key components of SQL Server storage subsystem architecture; describe the typical job tasks to administer and manage SQL Server in a multiple server environment; describe the process of developing a data recovery plan; describe the process of controlling data access and securing SQL Server; describe the tools and methods to monitor system and server activity; describe the tools and methods use to manage locks; describe the items that may affect performance in SQL Server; describe how to access homogenous and heterogeneous data sources; describe the processes and tools for moving data into and out of SQL Server; describe the processes and tools for analyzing data in SQL Server, using Analysis Services.