SQL 2008

This learning plan will help you train to become a Database Administrator for Microsoft SQL Server 2008, and earn the Microsoft Certified IT Professional (MCITP): Database Administrator 2008 certification.

After completing this learning plan, you will be able to demonstrate your specialized technical expertise, world skills, and mastery of SQL Server 2008 by earning a Microsoft Certified Technology Specialist credential and a Microsoft Certified IT Professional (MCITP) credential.

The Database Administrator 2008 credential validates your expertise and ability to design, implement, and maintain SQL Server 2008 database solutions.

Estimated Time to Complete This Learning Plan: 13 days

Recommended Learning Resources:

Step 1

Course 6231A: Maintaining a Microsoft SQL Server 2008 Database

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. 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.

Step 2

Course 6232A: Implementing a Microsoft SQL Server 2008 Database

This five-day instructor-led course provides students with the knowledge and skills to implement a Microsoft SQL Server 2008 database. The course focuses on teaching individuals how to use SQL Server 2008 product features and tools related to implementing a database. After completing this course, students will be able to:

Create databases and database files.
Create data types and tables.
Use XML-related features in Microsoft SQL Server 2008.
Plan, create, and optimize indexes.
Implement data integrity in Microsoft SQL Server 2008 databases by using constraints and triggers.
Implement views.
Implement stored procedures.
Implement functions.
Implement managed code in the database.
Manage transactions and locks.
Use Service Broker to build a messaging-based solution.

Step 3

Course 2778A: Writing Queries Using Microsoft SQL Server 2008 Transact-SQL

This three-day instructor led course provides students with the technical skills required to write basic Transact-SQL queries for Microsoft SQL Server 2008.

Step 4

Preparation Guide for Exam 70-432: TS: Microsoft SQL Server 2008, Installation and Maintenance

When you pass Exam 70-432, you complete the requirements for the following certification(s):

MCTS: SQL Server 2008, Implementation and Maintenance

Step 5

Register and schedule for your exam

Register now for a 15% off voucher for exam 70-432, the first exam required for the Database Administrator credential.

Step 6

Preparation Guide for Exam 70-450: PRO: Designing, Optimizing and Maintaining a Database Server
Infrastructure using Microsoft SQL Server 2008

When you pass Exam 70-450, you complete the requirements for the following certification(s):

Microsoft Certified IT Professional (MCITP): Database Administrator 2008

Step 7

Register and schedule for your exam

Register now for a 25% off voucher for exam 70-450, the final exam required for the Database Administrator credential.