2733 Updating Your Database Administration Skills To Microsoft SQL Server 2005

Lesson 1: Overview of SQL Server 2005 Architecture

• Overview of SQL Server 2005

• System Enhancements for Administrators

Lesson 2: Installing SQL Server 2005

• Preparing to Install SQL Server 2005

• Performing a SQL Server 2005 Installation

• Maintaining a SQL Server 2005 Installation

Lesson 3: SQL Server 2005 Administrative Tools

• Using SQL Server Management Studio

• Using SQL Server Computer Manager

• Using the sqlcmd Utility

• Using the SQL Management Objects

Lesson 4: Monitoring SQL Server 2005

• Using SQL Profiler

• Using DDL Triggers

• Using Event Notifications

• Using Metadata Views

Lesson 5: Maintaining Databases and Indexes

• Managing Indexes

• Using the Database Tuning Advisor

Lesson 6: Securing SQL Server 2005

• SQL Server 2005 Security Overview

• Managing SQL Server 2005 Security

• Managing Permissions

• Managing Certificates

Lesson 7: Disaster Recovery

• Disaster Recovery in SQL Server 2005

• Using Database Snapshots

• Backup and Restore Operations

Lesson 8: Data Availability in SQL Server 2005

• Introduction to Data Availability

• Introduction to Database Mirroring

• Configuring Database Mirroring

Lesson 9: SQL Server 2005 Replication

• Overview of Replication Enhancements

• New Types of Replication

• Configuring Replication