2780: Maintaining a Microsoft SQL Server 2005 Database

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

Doelgroep

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

Voorkennis

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 MS2778, Writing Queries Using Microsoft SQL Server Transact-SQL.
• Course MS2779, Implementing a Microsoft SQL Server Database.

Inhoud

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.

Lessons

• Preparing to Install SQL Server
• Installing SQL Server 2005
• Managing a SQL Server 2005 Installation
Module 2: Managing Databases and Files This module explains how to manage databases and files.

Lessons

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

Lessons

• 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
Module 4: Managing Security This module explains how to manage principals, securables, and permissions, and how to implement cryptography in a SQL Server database.

Lessons

• Overview of SQL Server Security
• Protecting the Server Scope
• Protecting the Database Scope
• Managing Keys and Certificates in SQL Server
Module 5: Monitoring SQL Server This module explains how to monitor SQL Server performance and activity.

Lessons

• Viewing Current Activity
• Using System Monitor
• Using SQL Server Profiler
• Using DDL Triggers
• Using Event Notifications
Module 6: Transferring Data This module explains how to transfer and transform data.

Lessons

• Overview of Data Transfer
• Introduction to SQL Server Integration Services
• Using SQL Server Integration Services
• Features of SQL Server Integration Services
Module 7: Automating Administrative Tasks This module explains how to use the SQL Server Agent to automate administrative tasks.

Lessons

• 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
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.

Lessons

• Overview of Replication
• Implementing Replication
• Configuring Replication in Some Common Scenarios
Module 9: Maintaining High Availability
This module explains how to implement high availability technologies with SQL Server 2005.

Lessons

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