Course Information

Course CodeMS2072 (MOC2072) (M2072)
Fee£1295 (Exclusive of VAT)
DurationFive Days
Delivery FormatInstructor-led
Scheduled Dates:Please Contact Us for Information

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 administrate SQL Server 2000.

Completion

Prerequisites

Experience using the Microsoft Windows 2000 operating system to:

For students who do not meet these prerequisites, the following courses provide students with the necessary knowledge and skills:

An understanding of basic relational database concepts, including:

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 Overview

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

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: