Administering and Automating Microsoft® SQL Server™ 2005 Databases and Servers

These two courses are comprised of a rich multimedia experience coupled with comprehensive technical labs.

These courses provide you with the knowledge and skills to administer and automate Microsoft® SQL Server™ 2005 databases and servers.

These courses emphasize that you should think about the whole environment, including business needs; and network, systems, and database considerations during design.

These courses are 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.

After completing these courses, you will be able to:
Manage and automate databases and servers.
Manage supporting services.
To get the most out of these courses, you should:
Understand how replication works and how replication is implemented.
Have working knowledge of source control software.
Have working knowledge of networking.
Have basic working knowledge of security infrastructures.
Have some experience with database design.
Have basic monitoring and troubleshooting skills.
 
Course 3466: Managing and Automating Microsoft® SQL Server™ 2005 Databases and Servers

Description:
In this course you will plan automated systems for databases and servers. You will also gain the knowledge required to maintain a run book.
This course will also help prepare you for certification exams 70-443 and 70-444.

Objectives:
At the end of the course, students will be able to:
Plan an Automated System for Database Maintenance
Plan an Automated System for Server Maintenance
Document Administration and Automation Information in a Run Book
 
Course 3467: Managing Microsoft® SQL Server™ 2005 Supporting Services

Description:
In this course you will deploy and manage SSIS packages. This course also provides the guidelines and considerations for maintaining replication and reporting services.
This course will also help prepare you for certification exams 70-443 and 70-444.

Objectives:
At the end of the course, students will be able to:
Manage SSIS Packages
Manage Replication
Manage Reporting Services