Microsoft - SQL Server 2005

Course : Maintaining a Microsoft SQL Server 2005 Database (2780)

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.

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.

At course completion

After completing this course, students will be able to:

- Install and configure SQL Server 2005
- Manage database files
- Backup and restore databases
- Manage security
- Monitor SQL Server
- Transfer data into and out of SQL Server
- Automate administrative tasks
- Replicate data between SQL Server instances
- Maintain high availability

Prerequisites

Before attending this course, students must have a basic knowledge of the Microsoft Windows operating system, Transact-SQL and some experience with database design.

Course outline

Module 1: Installing and Configuring SQL Server 2005
Module 2: Managing Databases and Files
Module 3: Disaster Recovery
Module 4: Managing Security
Module 5: Monitoring SQL Server
Module 6: Transferring Data
Module 7: Automating Administrative Tasks
Module 8: Implementing Replication
Module 9: Maintaining High Availability

Both courses, software, documentation and exams are given in french or english.