Course Information

Course CodeMS2780 (MOC2780) (M2780)
Fee£1245 (Exclusive of VAT)
SaveMCTS CertSaver
DurationFive Days
Delivery FormatInstructor-Led
Scheduled Dates:
Aug 10 Sept 10 Oct 10 Nov 10 Dec 10 Jan 11 Feb 11 Mar 11 Apr 11 May 11
- - - 15 - - 28 - - TBA

Introduction

This five-day instructor-led course provides students with product knowledge and skills needed to maintain a Microsoft SQL ServerT 2005 database. The course focuses on teaching individuals how to use SQL Server 2005 product features and tools related to maintaining a database.

Audience

This course is intended for IT Professionals wanting to become skilled on SQL Server 2005 product features and technologies for maintaining a database.

Completion

Prerequisites

In addition, it is recommended, but not required, that students have completed:

Examinations

Materials

The student kit includes a comprehensive workbook and other necessary materials for this class.

Course Outline

Module 1: Installing and Configuring SQL Server 2005

This module explains how to plan for and install SQL Server 2005, how to manage a SQL Server 2005 installation, and how to use the SQL Server 2005 administrative tools.

Lessons

Lab 1: Installing SQL Server 2005

After completing this module, students will be able to:

Module 2: Managing Databases and Files

This module explains how to manage databases and files.

Lessons

Lab 2: Creating and Managing Databases

After completing this module, students will be able to:

Module 3: Disaster Recovery

This module explains how to plan and implement a backup and restore strategy.

Lessons

Lab 4: Implementing a Disaster Recovery Strategy

After completing this module, students will be able to:

Module 4: Managing Security

This module explains how to manage principals, securables, and permissions, and how to implement cryptography in a SQL Server database.

Lessons

Lab 3: Securing SQL Server

After completing this module, students will be able to:

Module 5: Monitoring SQL Server

This module explains how to monitor SQL Server performance and activity.

Lessons

Lab 5: Monitoring SQL Server

After completing this module, students will be able to:

Module 6: Transferring Data

This module explains how to transfer and transform data.

Lessons

Lab 6: Transferring Data with SQL Server Integration Services (SSIS)

After completing this module, students will be able to:

Module 7: Automating Administrative Tasks

This module explains how to use the SQL Server Agent to automate administrative tasks.

Lessons

Lab 7: Automating Database Administration

After completing this module, students will be able to:

Module 8: Maintaining High Availability

This module explains how to implement high availability technologies with SQL Server 2005.

Lessons

Lab 8: Configuring Database Mirroring

After completing this module, students will be able to:

Module 9: Introduction to Replication

This module explains considerations for implementing replication.

Lessons

Lab 9: Implementing Replication

After completing this module, students will be able to: