Description:
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.

Target Audience:
This course is intended for IT Professionals who want to become skilled on SQL Server 2005 product features and technologies for maintaining a database.

Duration:
5 days

Pre-Requisites:

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

Objectives:

• Installing and Configuring SQL Server 2005
  • Preparing to Install SQL Server
  • Installing SQL Server 2005
  • Managing a SQL Server 2005 Installation
• Managing Databases and Files
  • Planning Databases
  • Creating Databases
  • Managing Databases
• Disaster Recovery
  • 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
• Managing Security
  • Overview of SQL Server Security
  • Protecting the Server Scope
  • Protecting the Database Scope
  • Managing Keys and Certificates in SQL Server
• Monitoring SQL Server
  • Viewing Current Activity
  • Using System Monitor
  • Using SQL Server Profiler
  • Using DDL Triggers
  • Using Event Notifications
• Transferring Data
  • Overview of Data Transfer
  • Introduction to SQL Server Integration Services
  • Using SQL Server Integration Services
  • Features of SQL Server Integration Services
• Automating 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
• Implementing Replication
  • Overview of Replication
  • Implementing Replication
  • Configuring Replication in Some Common Scenarios
• Maintaining High Availability
  • Introduction to High Availability
  • Implementing Server Clustering
  • Implementing Database Mirroring
  • Implementing Log Shipping
  • Implementing Peer-to-Peer Replication

Exams:

This course will help the student prepare for the following exam:

Exam 70–431: TS: Microsoft SQL Server 2005 - Implementation and Maintenance