MS SQL Server 2005 Course Content

Understanding and Implementing Security

Security Overview
Authentication
Authorization
Permissions
Data Encryption
Security Epilog

Analyzing and Tuning Performance

Evaluating Performance
Monitoring with SQL Server Profiler
Tuning Queries
Indexes and Partitions
Using the Database Engine Tuning Advisor
Understanding SQL Server Performance Problems

Automating Administrative Tasks

SQL Server Agent
Maintenance Plans
SQL Management Objects (SMO)

Programming Replication

Overview of SQL Server Replication
Replication Programming Interfaces
Configuring Replication
Synchronizing Data

Disaster Recovery

Planning a Backup Strategy
Backing Up Databases
Scheduling Your Backups
Verifying Backup Media
Restoring Databases
Using Database Snapshots

Failover Clustering

High Availability Overview
SQL Server 2005 Failover Cluster
Preparing a Server Cluster
Creating a New Cluster
Installing SQL Server 2005 Failover
Adding Additional SQL Server Nodes

Database Mirroring

Understanding Mirroring
Setting Up Database Mirroring
Monitoring Database Mirroring

Log Shipping

Overview
Configuring Log Shipping
Monitoring Log Shipping Jobs
Using Transact-SQL

Peer-to-Peer Replication

Overview
Configuring the Distributor
Creating the Publisher
Configuring Peer-to-Peer Subscribers
Configuring Peer-to-Peer Topology

Monitoring & Troubleshooting

Diagnosing and Resolving Database Server Errors
Set Up Alerts Using SQL Server Agent
Monitoring SQL Server Agent Job History
Gathering Performance Data and Optimization using DMV

Implementing Service Brokers

Understanding Service Brokers
Designing Service Broker Applications
Programming Service Broker Applications