Installing and Configuring SQL Server 2005
o Preparing to Install SQL Server
o Installing SQL Server 2005
o Managing a SQL Server 2005 Installation
Managing Databases and Files
o Planning Databases
o Creating Databases
o Managing Databases
Disaster Recovery
o Planning a Backup Strategy
o Backing Up User Databases
o Restoring User Databases
o Performing Online Restore Operations
o Recovering Data from Database Snapshots
o System Database and Disaster Recovery
Managing Security
o Overview of SQL Server Security
o Protecting the Server Scope
o Protecting the Database Scope
o Managing Keys and Certificates in SQL Server
Monitoring SQL Server
o Viewing Current Activity
o Using System Monitor
o Using SQL Server Profiler
o Using DDL Triggers
o Using Event Notifications
Transferring Data
o Overview of Data Transfer
o Introduction to SQL Server Integration Services
o Using SQL Server Integration Services
o Features of SQL Server Integration Services
Automating Administrative Tasks
o Automating Administrative Tasks in SQL Server 2005
o Configuring the SQL Server Agent
o Creating Jobs and Operators
o Creating Alerts
o Managing Multiple Servers
o Managing SQL Server Agent Security
Implementing Replication
o Overview of Replication
o Implementing Replication
o Configuring Replication in Some Common Scenarios
Maintaining High Availability
o Introduction to High Availability
o Implementing Server Clustering
o Implementing Database Mirroring
o Implementing Log Shipping
o Implementing Peer-to-Peer Replication
