CERTIFICATIONS

PROGRAMS

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 getsmart@LRS.com

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.

Prerequisites

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: