Microsoft SQL Server 2000 for Experienced Database Professionals Training Class

Microsoft SQL Server 2000 for Experienced Database Professionals Training Seminar

Overview:
This course provides students with the knowledge and skills to plan, deploy, administer, manage, and troubleshoot complex replication designs over a variety of communication topologies.

Who Should Attend:
The primary audience for this course is database administrators who are experienced and proficient with enterprise database products such as Oracle, DB2, or Sybase. It will also help current database administrators who are experienced with Microsoft SQL Server 6.5 and earlier. This course is not for individuals who are experienced only in desktop database management systems such as Microsoft Access or individuals who are experienced in SQL Server 7.0.

At Course Completion:
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.