Administering a Microsoft SQL Server 2000 Database
Unfiled
This course provides students with the knowledge and skills required to install configure administer and troubleshoot the client-server database management system of Microsoft SQL Server™ 2000. Course 2072 is a revision of Course 832 System Administration for Microsoft SQL Server 7.0. The course content is being revised to reflect changes in the product.
|
|
Program Outline
Module 1: SQL Server Overview
Take a closer look: Download Sample Module 1 (Portable Document Format 990 KB).
The following topics are covered in this module:
The following lab is covered in this module:
At the end of this module you will be able to:
Module 2: Planning to Install SQL Server
The following topics are covered in this module:
The following lab is covered in this module:
At the end of this module you will be able to:
Module 3: Managing Database Files
The following topics are covered in this module:
The following lab is covered in this module:
At the end of this module you will be able to:
Module 4: Managing Security
Take a closer look: Download Sample Module 4 (Portable Document Format 1.08 MB).
The following topics are covered in this module:
The following labs are covered in this module:
At the end of this module you will be able to:
Module 5: Performing Administrative Tasks
The following topics are covered in this module:
The following labs are covered in this module:
At the end of this module you will be able to:
Module 6: Backing Up Databases
The following topics are covered in this module:
The following lab is covered in this module:
At the end of this module you will be able to:
Module 7: Restoring Databases
The following topics are covered in this module:
The following lab is covered in this module:
At the end of this module you will be able to:
Module 8: Monitoring SQL Server for Performance
The following topics are covered in this module:
The following lab is covered in this module:
At the end of this module you will be able to:
Module 9: Transferring Data
The following topics are covered in this module:
The following lab is covered in this module:
At the end of this module you will be able to:
Module 10: Maintaining High Availability
The following topics are covered in this module:
The following lab is covered in this module:
At the end of this module you will be able to:
Module 11: Introducing Replication
The following topics are covered in this module:
The following lab is covered in this module:
At the end of this module you will be able to:
Related Exams
Student Pre-Requisites
Before attending this course students must have:
For students who do not meet these prerequisites the following courses provide students with the necessary knowledge and skills:
For students who do not meet these prerequisites the following course provides students with the necessary knowledge and skills:
For students who do not meet these prerequisites the following course provides students with the necessary knowledge and skills:
The course materials lectures and lab exercises are in English. To benefit fully from the instruction students need an understanding of the English language and completion of the prerequisites.
Student Materials
The course materials are yours to keep. The student kit includes a comprehensive workbook and other necessary materials for this class.
The following software is provided for use in the classroom:
Program Goals
At the end of the course students will be able to:
