|
This three-day instructor-led course provides students with product knowledge and skills needed to maintain a Microsoft SQL Server 2005 database. The course focuses on teaching individuals how to use SQL Server 2005 product features and tools related to maintaining a database.
This course is intended for IT Professionals wanting to become skilled on SQL Server 2005 product features and technologies for maintaining a database.
OUTLINE
Module 1: Installing and Configuring SQL Server 2005
This module explains how to plan for and install SQL Server 2005, how to manage a SQL Server 2005 installation, and how to use the SQL Server 2005 administrative tools.
- Preparing to install SQL Server.
- Installing SQL Server.
- Managing a SQL Server 2005 Installation.
Module 2: Managing Databases and Files
This module explains how to manage databases and files.
- Planning databases.
- Creating databases.
- Managing databases.
Module 3: Disaster Recovery
This module explains how to plan and implement a backup and restore strategy.
- 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
This module explains how to manage principals, securables, and permissions, and how to implement cryptography in a SQL Server database.
- 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
This module explains how to monitor SQL Server performance and activity.
- Viewing Current Activity.
- Using System Monitor.
- Using SQL Server Profiler.
- Using DDL Triggers.
- Using Event Notifications.
Module 6: Transferring Data
This module explains how to transfer and transform data.
- Overview of Data Transfer.
- Introduction to SQL Server Integration Services.
- Using SQL Server Integration Services.
Module 7: Automating Administrative Tasks
This module explains how to use the SQL Server Agent to automate 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
This module explains how to implement high availability technologies with SQL Server 2005.
- Introduction to High Availability.
- Implementing Server Clustering.
- Implementing Database Mirroring.
- Implementing Log Shipping.
Module 9: Introduction to Replication
This module explains considerations for implementing replication.
- Overview of Replication.
- Replication Scenarios.
|
