Introduction
This course provides students with knowledge and skills needed to implement and maintain a Microsoft SQL Server 2005 database. The course focuses on teaching individuals how to use SQL Server 2005 features and tools related to maintaining a database.

|
 |
|
 |
Course
Objectives
After completing this course, students will be able to:
Install and configure SQL Server 2005
Manage database files
Manage security
Perform administrative tasks
Back up databases
Restore databases
Monitor SQL Server
Troubleshoot SQL Server
Transfer data
Maintain high availability

|
 |
|
 |
Microsoft Certified Technology Specialist Exams
This course will help the student prepare for the following Microsoft Certified Technology Specialist exam:
- Exam 70-431: TS: Microsoft SQL Server 2005 - Implementation and Maintenance

|
 |
|
 |
Prerequisites
Before attending this course, students must have:
- Experience using a Microsoft Windows® operating system
- Working knowledge of Transact-SQL and relational database
- Experience in implementing a Microsoft SQL Server 2005 Database

|
 |
|
 |
Course Outline
Installing and Configuring SQL Server 2005
- Preparing to install SQL Server
- Installing SQL Server
- 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
- Recovering Data from Database Snapshots
- System Database and Disaster Recovery
Managing Security
- Overview of SQL Server Security
- Securing the Server Scope
- Securing 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
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
Maintaining High Availability
- Introduction to High Availability
- Implementing Server Clustering
- Implementing Database Mirroring
- Implementing Log Shipping
Introduction to Replication
- Overview of Replication
- Replication Scenarios
|
|