SQL 2005

This learning plan will help you train to become a Database Administrator for Microsoft SQL Server 2005, and earn the Microsoft Certified Database Administrator 2005 certification.

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

Estimated Time to Complete This Learning Plan: 20 days

Recommended Learning Resources:

Step 1

Course 2780B: Maintaining a Microsoft SQL Server 2005 Database

This five-day instructor-led course provides the knowledge and skills to maintain a SQL Server 2005 database. The course focuses on how to use SQL Server 2005 product features and tools to maintain a database.

Step 2

Course 2779B: Implementing a Microsoft SQL Server2005 Database

This five-day instructor-led course teaches students how to:

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

Step 3

Preparation Guide for Exam 70-431

Review this preparation guide to ensure that you are familiar with the topics covered in the exam.

Step 4

Register and schedule for your exam

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

Step 5

Course 2786B: Designing a Microsoft SQL Server 2005 Infrastructure

This two-day instructor-led course provides database administrators working in enterprise environments with the knowledge and skills to design a Microsoft SQL Server 2005 database infrastructure.

Step 6

Course 2787A: Designing Security for Microsoft SQL Server 2005

This two-day instructor-led course enables database administrators who work with enterprise environments to design security for database systems using Microsoft SQL Server 2005.

Step 7

Course 2788A: Designing High Availability Database Solutions Using Microsoft SQL Server 2005

This three-day instructor-led course provides students with the knowledge and skills to design high availability database solutions using Microsoft SQL Server 2005. The course focuses on teaching experienced database administrators working in enterprise environments to design database solutions that meet the availability needs of their organization. It emphasizes that students should think broadly about high availability, which includes thinking about the database itself and about their entire environment, including business needs; regulatory requirements; and network, systems, and database considerations during design. Students will also learn how to document and test the high availability database solution.

Step 8

Preparation Guide for Exam 70-443

Review this preparation guide to ensure that you are familiar with the topics covered in the exam.

Step 9

Register and schedule for your exam

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

Step 10

Course 2789B: Administering and Automating Microsoft SQL Server 2005 Databases and Servers

This one-day instructor-led course provides students with the knowledge and skills to administer and automate Microsoft SQL Server 2005 databases and servers.

Step 11

Course 2790A: Troubleshooting and Optimizing Database Servers Using Microsoft SQL Server 2005

The purpose of this two-day workshop is to teach database administrators working in enterprise environments how to determine and troubleshoot performance issues using Microsoft SQL Server 2005.

Step 12

Register and schedule for your exam

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