M2780: Managing a Microsoft SQL Server 2005 Database

5 Day Course
Hands On
Official Microsoft Curriculum
Code M2780

Book Now - 1 Delivery Method Available:

Scheduled Online Onsite


This five-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.

Training Partners

We work with the following best of breed training partners using our bulk buying power to bring you a wider range of dates, locations and prices.


Hide all

Installing and Configuring SQL Server 2005 (4 topics)

  • Preparing to install SQL Server
  • Installing SQL Server
  • Managing a SQL Server 2005 Installation

Managing Databases and Files (4 topics)

  • Planning databases
  • Creating databases
  • Managing databases

Managing Security (4 topics)

  • Overview of SQL Server Security
  • Securing the Server Scope
  • Securing the Database Scope
  • Implementing Cryptography in SQL Server

Disaster Recovery (5 topics)

  • Planning a Backup Strategy
  • Backing Up User Databases
  • Restoring User Databases
  • Recovering Data from Database Snapshots
  • System Database and Disaster Recovery

Monitoring SQL Server (5 topics)

  • Viewing Current Activity
  • Using System Monitor
  • Using SQL Server Profiler
  • Using DDL Triggers
  • Using Event Notifications

Transferring Data (3 topics)

  • Overview of Data Transfer
  • Introduction to SQL Server Integration Services (SSIS)
  • Using SQL Server Integration Services

Automating Administrative Tasks (6 topics)

  • Automating Administrative Tasks in SQL Server 2005
  • Configuring the SQL Server Agent
  • Creating Jobs and Operators
  • Create Alerts
  • Managing Multiple Servers
  • Managing SQL Server Agent Security

Maintaining High Availability (4 topics)

  • Introduction to High Availability
  • Implementing Server Clustering
  • Implementing Database Mirroring
  • Implementing Log Shipping

Introduction to Replication (2 topics)

  • Overview of Replication

Implementing Replication (2 topics)

  • Creating a Publication
  • Creating A Subscription


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 2779, Implementing a Microsoft SQL Server Database. This course is intended for IT Professionals wanting to become skilled on SQL Server 2005 product features and technologies for maintaining a database.

Additional Learning

The courses below may help you meet the knowledge level required to take this course. If you are unsure please ask a training advisor .

Relevant Certifications

or call:408-759-5074

Course PDF


Share this Course


Recommend this Course