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