Microsoft Course 2780 - Maintaining a Microsoft SQL Server 2005 Database — A 5-Day Course

contact usEnquire about this course

Course Synopsis

Please note that this course has been retired and is no longer available. Please see the Microsoft SQL Server 2005 page for courses currently available in this subject area.

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

Course Objectives

On completion of this M2780 training course, delegates should be able to:

Intended Audience

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

Course Prerequisites

Before attending this course, students should have the following prerequisites:

Schedule

This course has been retired and is no longer available.


Outline Course Contents

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.

Managing Databases and Files

This module explains how to manage databases and files.

Disaster Recovery

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

Managing Security

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

Monitoring SQL Server

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

Transferring Data

This module explains how to transfer and transform data.

Automating Administrative Tasks

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

Implementing Replication

This module explains the purpose of replication, introduces the concepts underpinning replication, and describes how to implement replication in several common scenarios.

Maintaining High Availability

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