SQL Server Administration Update to 2005

AUDIENCE: This course is for databse administrators responsible for the migration and support of SQL Server from versions 7.0 or 2000 to the new 2005 release.
PREREQUISITES: Delegates should be experienced SQL Server administrators. Attending our SQLServer 2000 Administration class or equivalent knowledge is essential.
DURATION: 3 days. Hands on.
OBJECTIVES: This course will upgrade the delegates'' skills to SQL Server 2005 so that they can support, configure, and maintain enterprise SQL Server 2005 databases and servers. On completion of the course delegates will be able to:
· Install SQL Server 2005.
· Use the new administration tools and utilities.
· Maintain the database.
· Complete backup and restore functions.
· Implement data availability solution with mirroring and clustering.

COURSE CONTENT:
SQL Server 2005 Overview and Installation
New administration tools and utilities
Installing SQL Server 2005

Administration Tools
SQL Server Management Studio
SQL Server Computer Manager
Using sqlcmd
SQL Server management objects

Database Monitoring
SQL Profiler
DDL Triggers
Event Notification
Metadata views

Database Maintenance and Indexes
Managing indexes
The Database Tuning Advisor

Database Security
Overview
Managing Security
Permissions
Certificates

Backup and Recovery
Backup and Restore Operations
Snapshots
High Availability
Introduction to data availability
Mirroring

Replication
New features in SQL Server 2005
New types of Replication
Configuring Replication