Microsoft Course 2789 - Administering and Automating Microsoft SQL Server 2005 Databases and Servers — A 1-Day Course

contact usEnquire about this course

This course has now been retired. Please see the Microsoft SQL 2005 section for a list of current courses.

Course Synopsis

This one-day instructor-led M2789 course provides students with the knowledge and skills to administer and automate Microsoft SQL Server 2005 databases and servers. This course focuses on the need to maintain administration and automation information.

Course Objectives

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

Intended Audience

This course is intended for current professional database administrators who have three or more years of on-the-job experience administering SQL Server database solutions in an enterprise environment.

Course Prerequisites

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


This course has been retired and is no longer available.

Outline Course Contents

Managing and Automating Databases and Servers

This module provides you with the guidelines and considerations for planning automated systems for databases and servers. This module also provides you with the knowledge required to maintain a run book.

Managing SQL Server Supporting Services

This module introduces the concept of SQL Server Integration Services (SSIS) packages and provides the guidelines to deploy and manage SSIS packages. This module also provides the guidelines and considerations for maintaining replication and reporting services.