Duration: 35 hours
Description: This instructor-led course provides
students with the knowledge and skills 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
who want to become skilled on SQL Server 2005 product features and technologies
for maintaining a database.
Objective: Students learn to perform these tasks: Install and configure SQL Server 2005. Manage database files. Backup and restore databases. Manage security. Monitor SQL Server. Transfer data into and out of SQL Server. Automate administrative tasks. Replicate data between SQL Server instances. Maintain high availability.
Course Content:
Installing and Configuring SQL Server 2005
Managing Databases and Files
Disaster Recovery
Managing Security
Monitoring SQL Server
Transferring Data
Automating Administrative Tasks
Implementing Replication
Maintaining High Availability