MSSQL Server DBA 2008 (Weekend batch starts 21st Jan 2012)

SQL Server 2008: Database Administration
Module 1: Installing and Configuring SQL Server
Preparing to Install SQL Server
Installing SQL Server
Configuring a SQL Server Installation
Module 2: Managing Databases and Files
Planning Databases
Creating Databases
Using Policy-Based Management
Module 3: Disaster Recovery
Planning a Backup Strategy
Backing Up User Databases
Restoring User Databases
Performing Online Restore Operations
Recovering Data from Database Snapshots
System Databases and Disaster Recovery
Module 4: Managing Security
Overview of SQL Server Security
Protecting the Server Scope
Protecting the Database Scope
Protecting the Server Scope
Auditing Security
Module 5: Transferring Data
Overview of Data Transfer
Introduction to SQL Server Integration Services
Module 6: Automating Administrative Tasks
Automating Administrative Tasks in SQL Server
Using SQL Server Agent
Creating Maintenance Plans
Implementing Alerts
Managing Multiple Servers
Managing SQL Server Agent security
Module 7: Implementing Replication
Overview of Replication
Managing Publications and Subscriptions
Configuring Replication in Some Common Scenarios
Module 8: Maintaining High Availability
Introduction to High Availability
Implementing Log Shipping
Implementing Database Mirroring
Implementing Server Clustering
Using Distributed High Availability Solutions
Module 9: Monitoring SQL Server
Viewing Current Activity
Using SQL Server Profiler
Monitoring with DDL Triggers
Using Event Notifications
Module 10: Troubleshooting and Performance Tuning
Troubleshooting SQL Server
Performance Tuning in SQL Server
Using Resource Governor
Using Data Collector