M6231 Maintaining a Microsoft SQL Server 2008 Database

Dates Scheduled: 11/1/2010, 2/28/2011

Length: 5 Days / Time: 9:00A - 5:00P

Cost: $2,095.00

Course Description: This five-day instructor-led 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.

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

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.

Performanced-Based Objectives:

After completing this course, students will be able to:

• Install and configure SQL Server 2008.
• Manage database files.
• Backup and restore databases.
• Manage security.
• Transfer data into and out of SQL Server.
• Automate administrative tasks.
• Replicate data between SQL Server instances.
• Maintain high availability.
• Monitor SQL Server.

Course Content: Full Course Outline
Module 1: Installing and Configuring SQL Server
Module 2: Managing Databases and Files
Module 3: Disaster Recovery
Module 4: Managing Security
Module 5: Transferring Data
Module 6: Automating Administrative Tasks
Module 7: Implementing Replication
Module 8: Maintaining High Availability
Module 9: Monitoring SQL Server
Module 10: Troubleshooting and Performance Tuning