Training Course: Microsoft SQL Server 2000 for Experienced Database Professionals (2723, MOC 2723)

Training Course Summary:

Course Overview

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 This is not an advanced or a how-to course.

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.

What You Will Learn

At the end of this course, participants will be able to:

Understand SQL Server programming environment and storage subsystem architecture.
Understand the key components of SQL Server architecture and storage subsystem architecture.
Administer and manage SQL Server in a multiple server environment.
The processes of developing a data recovery plan and securing SQL Server.
Secure a SQL Server.
Learn the tools and methods to monitor system and server activity and to manage locks.
The items that may affect performance in SQL Server.
Accessing homogenous and heterogeneous data sources.
The processes and tools for moving data into and out of SQL Server and for analysing using Analysis Services.



Pre-requisites




Database administrators who are experienced in Oracle, DB2 or Sybase.
These database administrators have a technical depth of understanding of the database management systems 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.
To be successful in this class, students should have experience in administration and implementation of departmental or enterprise relational database management systems.



Follow-up Courses

MOC2092: Populating a Data Warehouse with Microsoft SQL Server 2000 Data Transformation Services
MOC2074: Designing and Implementing OLAP Solutions with Microsoft SQL Server 2000
MOC2591: Implementing Replication Using Microsoft SQL Server 2000
Course Content

SQL Server Product Overview


Key components of SQL Server architecture
The structure of databases in SQL Server, related definitions, and terminology.
Describe the architecture of SQL Server and its programming environment in terms of its major components and tools.

SQL Server Components

Key components of SQL Server relational database management system architecture and their use in configuring and optimising SQL Server.
The structure of databases in SQL Server, related definitions, and terminology.
Key components of SQL Server RDBMS architecture.
SQL Server components.
Relational engine architecture.
Tools and methods that are used to maintain efficient queries.
Query execution plans and how SQL Server can optimise them.
Memory architecture and management.
SQL Server threads and process management.
The process, tools and techniques for connecting clients to SQL Server.

SQL Server Storage Subsystems

Storage structures of SQL Server, index architecture and indexing strategies and how they are unique in SQL Server, how to manage indexes, how to work with SQL Server statistics.
Key components of SQL Server storage subsystem architecture.
SQL Server storage and index architecture.
Management of indexes.
Approaches to working with statistics.

SQL Server Administration

Administer and manage Microsoft® SQL Server™ in a multiple server environment.
Using scripting, SQL Server Enterprise Manager, and maintenance plans.
How to use SQL Server Agent and jobs to automate administrative tasks.
Typical