Maintaining a Microsoft SQL Server 2005 database (MOC 2780)

Special note

Elements of this syllabus are subject to change

Course overview

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

Prerequisites

• Basic knowledge of the Microsoft Windows operating system and its core functionality
  
• Working knowledge of Transact-SQL
  
• Working knowledge of relational databases
  
• Some experience with database design

Audience

• This course is intended for IT Professionals wanting to become skilled on SQL Server 2005 product features and technologies for maintaining a database

Next steps

• No Microsoft Certified Professional exams are associated with this course currently
  

Benefits to you

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

Course outline

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: Managing Security

• This module explains how to manage principals, securables, and permissions, and how to implement cryptography in a SQL Server database

Module 4: Disaster Recovery

• This module explains how to plan and implement a backup and restore strategy

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: Maintaining High Availability

• This module explains how to implement high availability technologies with SQL Server 2005

Module 9: Introduction to Replication

• This module explains considerations for implementing replication