New Horizons Computer Learning Center
410-597-9722

2789: Administering and Automating Microsoft SQL Server 2005 Databases and Servers

Course Length: 1 Day

Overview:
This one-day instructor-led 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.

Prerequisites:
Writing Queries Using Microsoft SQL Server 2005 Transact-SQL
Course 2779: Implementing a Microsoft SQL Server 2005 Database
Course 2780: Maintaining a Microsoft SQL Server 2005 Database

Course Objectives:
Upon successful completion of this course, students will be able to:

• Manage and automate databases and servers
• Manage supporting services

Course Content

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
• Lab 1: Managing and Automating Databases and Servers
• Creating Maintenance Plans
• Creating Database Change Control Procedures
• Configuring And Using the SQL H2 Tool

Lesson 2: Managing SQL Server Supporting Services

• Managing SSIS Packages
• Managing Replication
• Managing Reporting Services
• Lab 2: Managing SQL Server Supporting Services
• Moving Packages Between Database Servers
• Initializing a Transactional Subscription From a Backup
• Configuring Reporting Services

6940 Tudsbury Road, Baltimore, MD 21244
P: 410-597-9722
www.nhbaltimore.com