Technical Training - Managing a Microsoft SQL Server 2005 Database

Course No: M2780 Course Lengh: 5 Days

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

Pre-Requisites: 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 Transact-SQL.
Course 2779, Implementing a Microsoft SQL Server Database.

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.

Managing Databases and Files
This module explains how to manage databases and files.

Managing Security
This module explains how to manage principals, securables, and permissions, and how to implement cryptography in a SQL Server database.

Disaster Recovery
This module explains how to plan and implement a backup and restore strategy.

Monitoring SQL Server
This module explains how to monitor SQL Server performance and activity.

Transferring Data
This module explains how to transfer and transform data.

Automating Administrative Tasks
This module explains how to use the SQL Server Agent to automate administrative tasks.

Maintaining High Availability
This module explains how to implement high availability technologies with SQL Server 2005.

Introduction to Replication
This module explains considerations for implementing replication.

Site by Notcon