Overview

This five-day instructor-led Microsoft SQL Server 2008 Database Boot Camp includes lessons from course 6232 - Implementing a Microsoft SQL Server 2008 Database.

The course provides students with the knowledge and skills to maintain SQL Server 2008 product features and tools related to maintaining and implementing a database.

Audience

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 MS Windows operating system and its core functionality.

¨ Working knowledge of Transact-SQL.

¨ Working knowledge of relational databases.

¨ Some experience with database design.

Course Outline

Module 1: Installing and Configuring SQL Server

Module 2: Implementing and Managing Databases and Files

Module 3: Creating Data Types and Tables

Module 4: Implementing Views

Module 5: Implementing Stored Procedures

Module 6: Implementing Functions

Module 7: Managing Transactions and Locks

Module 8: Disaster Recovery

Module 9: Managing Security

Module 10: Automating Administrative Tasks

Module 11: Implementing Replication

Module 12: Maintaining High Availability

Module 13: Monitoring SQL Server

Module 14: Troubleshooting and Performance Tuning

Module 15: What's New in SQL Server 2008 R2 Editions?