MOC 6231 Maintaining a Microsoft SQL Server 2008 Database

    

Summary:
This course provides students with the knowledge and skills to maintain a Microsoft SQL Server 2008 database. The course focuses on teaching individuals how to use SQL Server 2008 product features and tools related to maintaining a database.

Duration:
5 Days/Lecture & Lab

Audience:
This course is intended for IT Professionals who administer and maintain SQL Server databases.

Topics:

• Installing and Configuring SQL Server
• Managing Databases and Files
• Disaster Recovery
• Managing Security
• Transferring Data
• Automating Administrative Tasks
• Implementing Replication
• Maintaining High Availability
• Monitoring SQL Server
• Troubleshooting and Performance Tuning

Prerequisites:
Before attending this course, students must have:-Basic knowledge of the Microsoft Windows operating system and its core functionality.-Working knowledge of Transact-SQL.-Working knowledge of relational databases.-Some experience with database design.

Last Update: July 29, 2010