Corporate HomeCorporate ProfileWorldwide OfficesSolutions At WorkEmployment  
LRS Education Services
LEARN  >  Find a Class  >  Class Summary

MS2780 - Maintaining a Microsoft SQL Server 2005 Database

If you have any questions about registering for this class, please call (877) 832-0688 Ext. 1493 or email us at
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.
Click here for a printer-friendly version of this page.
This course has not been scheduled yet. Please contact us by clicking the link below to learn about availability.
Contact us for additional availability.


  • Before attending this course, students must have: • 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. In addition, it is recommended, but not required, that students have completed: • Course 2778: Writing Queries Using Microsoft SQL Server 2005 Transact-SQL. • Course 2779: Implementing a Microsoft SQL Server 2005 Database.
    Detailed Class Syllabus

    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.

  • Preparing to Install SQL Server

  • Installing SQL Server 2005

  • Managing a SQL Server 2005 Installation

  • Lab 1: Installing and Configuring SQL Server 2005

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

  • Planning Databases

  • Creating Databases

  • Managing Databases

  • Lab 2: Managing Databases and Files

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

  • Planning a Backup Strategy

  • Backing Up User Databases

  • Restoring User Databases

  • Performing Online Restore Operations

  • Recovering Data from Database Snapshots

  • System Database and Disaster Recovery

  • Lab 3: Disaster Recovery

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

  • Overview of SQL Server Security

  • Protecting the Server Scope

  • Protecting the Database Scope

  • Managing Keys and Certificates in SQL Server

  • Lab 4: Managing Security

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

  • Viewing Current Activity

  • Using System Monitor

  • Using SQL Server Profiler

  • Using DDL Triggers

  • Using Event Notifications

  • Lab 5: Monitoring SQL Server

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

  • Overview of Data Transfer

  • Introduction to SQL Server Integration Services

  • Features of SQL Server Integration Services

  • Lab 6: Transferring Data

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

  • Automating Administrative Tasks in SQL Server 2005

  • Configuring the SQL Server Agent

  • Creating Jobs and Operators

  • Creating Alerts

  • Managing Multiple Servers

  • Managing SQL Server Agent Security

  • Lab 7: Automating 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.

  • Overview of Replication

  • Implementing Replication

  • Configuring Replication in Some Common Scenarios

  • Lab 8: Implementing Replication

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

  • Introduction to High Availability

  • Implementing Server Clustering

  • Implementing Database Mirroring

  • Implementing Log Shipping

  • Implementing Peer-to-Peer Replication

  • Lab 9:
    Microsoft Partner Gold LearningPearson VUE Authorized Test CenterEC-Council