|
 Course
Outline
Module 1: Installing and Configuring SQL Server 2005
- Preparing to install SQL Server
- Installing SQL Server
- Managing a SQL Server 2005 Installation
Module 2: Managing Databases and Files
- Planning databases
- Creating databases
- Managing databases
Module 3: Disaster Recovery
- Planning a Backup Strategy
- Backing Up User Databases
- Restoring User Databases
- Recovering Data from Database Snapshots
- System Database and Disaster Recovery
Module 4: Managing Security
- Overview of SQL Server Security
- Securing the Server Scope
- Securing the Database Scope
- Managing Keys and Certificates in SQL Server
Module 5: Monitoring SQL Server
- Viewing Current Activity
- Using System Monitor
- Implementing Triggers
- Using DDL Triggers
- Using Event Notifications
Module 6: Transferring Data
- Overview of Data Transfer
- Introduction to SQL Server Integration Services
- Using SQL Server Integration
Module 7: Automating Administrative Tasks
- Automating Administrative Tasks in SQL Server 2005
- Configuring the SQL Server Agent
- Creating Jobs and Operators
- Creating Alerts
- Managing Multiple Servers
- Managing SQL Server Agent Security
Module 8: Maintaining High Availability
- Introduction to High Availability
- Implementing Server Clustering
- Implementing Database Mirroring
- Implementing Log Shipping
Module 9: Introduction to Replication
- Overview of Replication
- Replication Scenarios
Back to Course Description
Onsite Training Class Schedule
|
