Course Information

Course CodeMS2072 (MOC2072) (M2072)
Fee£1295 (Exclusive of VAT)
Offer Price*£995 Saving £300! Offer Ends 7th December 2007
DurationFive Days
Delivery FormatInstructor-led

Introduction

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.

Audience

The audience for this course will include systems administrators and others requiring the in-depth knowlege and skills to manage and admistrate SQL Server 2000.

Completion

Prerequisites

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.

Examinations

Materials

The student kit includes a comprehensive workbook and other necessary materials for this class. The following software is provided in the student kit:

The following software is provided for use in the classroom:

Course Outline

Module 1: SQL Server OverviewThe 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 ServerThe 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 FilesThe 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 SecurityThe 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 TasksThe 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 DatabasesThe 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 DatabasesThe 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 PerformanceThe 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 DataThe 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 AvailabilityThe 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 ReplicationThe 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: