2789 Administering and Automating Microsoft SQL Server 2005 Databases and Servers On-Site Training

This on-site training class is also available as Public Schedule Seminar.

This course provides students with the knowledge and skills to administer and automate Microsoft® SQL ServerT 2005 databases and servers

Course Description/Agenda

This course provides students with the knowledge and skills to administer and automate Microsoft® SQL ServerT 2005 databases and servers. Elements of this syllabus are subject to change. Who Should Attend: 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.
Prerequisite(s) or equivalent knowledge:
2780 Maintaining a Microsoft SQL Server 2005 Database 2779 Implementing a Microsoft SQL Server 2005 Database 2778 Writing Queries Using Microsoft SQL Server 2008 Transact-SQL

Outline:
Lesson 1: Managing and Automating Databases and Servers
Planning an Automated System for Database Maintenance Planning an Automated System Server Maintenance Documenting Administration and Automation Information
Lesson 2: Managing SQL Server Supporting Services
Managing SSIS Packages Managing Replication Managing Reporting Services