MSSQL Server DBA (Weekend batch starting 29th September 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