COURSE NAME: 2780-Maintaining a MS SQL Server 2005 Database (4050)

Course length: 5 days

Overview:

This five-day instructor-led course provides students with the knowledge and skills 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.

Prerequesite Courses:

• No Prerequisites listed for this course

Performance-based Objectives:

After completing this course, students will be able to:

• Install and configure SQL Server 2005
• Manage database files
• Manage security
• Perform administrative tasks
• Back up databases
• Restore databases
• Monitor SQL Server
• Troubleshoot SQL Server
• Transfer data
• Maintain high availability

Course content:

Module 1: 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.

Module 2: Managing Databases and Files - This module explains how to manage databases and files.

Module 3: Disaster Recovery - This module explains how to plan and implement a backup and restore strategy.

Module 4: Managing Security - This module explains how to manage principals, securables, and permissions, and how to implement cryptography in a SQL Server database.

Module 5: Monitoring SQL Server - This module explains how to monitor SQL Server performance and activity.

Module 6: Transferring Data - This module explains how to transfer and transform data.

Module 7: Automating Administrative Tasks - This module explains how to use the SQL Server Agent to automate administrative tasks.

Module 8: Implementing Replication - This module explains the purpose of replication, introduces the concepts underpinning replication, and describes how to implement replication in several common scenarios.

Module 9: Maintaining High Availability - This module explains how to implement high availability technologies with SQL Server 2005.