Microsoft Database Certifications details

 

How to Earn Your MCTS: SQL Server 2005

MCTS candidates must pass one exam focusing on the implementation and maintenance of SQL Server 2005.

Required Exams for MCTS: SQL Server 2005 (One Exam Required)

Courses

Exam 70?431: TS: Microsoft SQL Server 2005 - Implementation and Maintenance

2778: Writing Queries Using Microsoft SQL Server 2005 Transact-SQL (available as a Microsoft e-learning series in mid 2006)

2779: Implementing a Microsoft SQL Server 2005 Database (available as three-day classroom training in early 2006)

2780: Maintaining a Microsoft SQL Server 2005 Database (available as three-day classroom training in early 2006)

2936?2944: Free* Microsoft E-Learning Series for Database Administrators, Database Developers, and Business Intelligence Developers

How to Earn Your MCITP: Database Developer

MCITP candidates must first complete the requirements for the MCTS: SQL Server 2005 credential (one exam). After earning this credential, candidates earn their MCITP: Database Developer by passing two required exams.

Required Exams for MCITP: Database Developer (Two Exams Required)

Courses

Exam 70?441: PRO: Designing Database Solutions by Using Microsoft SQL Server 2005 (available early 2006)

2781: Designing Microsoft SQL Server 2005 Server-Side Solutions (available as three-day classroom training in early 2006)

2782: Designing Microsoft SQL Server 2005 Databases (available as two-day classroom training in early 2006)

Exam 70?442: PRO: Designing and Optimizing Data Access by Using Microsoft SQL Server 2005 (available early 2006)

2783: Designing the Data Tier for Microsoft SQL Server 2005 (available as one-day classroom training in early 2006)

2784: Tuning and Optimizing Queries Using Microsoft SQL Server 2005 (available as three-day classroom training in mid-2006)

How to Earn Your MCITP: Database Administrator

MCITP candidates must first complete the requirements for the MCTS: SQL Server 2005 certification (one exam). After earning this certification, candidates earn their MCITP: Database Administrator by passing two required exams.

If you are a Microsoft Certified Database Administrator (MCDBA), you may upgrade to the MCITP: Database Administrator certification by taking one upgrade exam in the place of the two required exams. MCDBAs must still obtain the MCTS: SQL Server 2005 certification as a prerequisite.

Required Exams for MCITP: Database Administrator (Two Exams Required)

Courses

Exam 70?443: PRO: Designing a Database Server Infrastructure by Using Microsoft SQL Server 2005

2786: Designing a Microsoft SQL Server 2005 Infrastructure (available as two-day classroom training and a Microsoft e-learning series in early 2006)

2787: Designing Security for Microsoft SQL Server 2005 (available as two-day classroom training and a Microsoft e-learning series in early 2006)

2788: Designing High Availability Database Solutions Using Microsoft SQL Server 2005 (available as three-day classroom training and a Microsoft e-learning series in early 2006)

Exam 70?444: PRO: Optimizing and Maintaining a Database Administration Solution by Using Microsoft SQL Server 2005

2787: Designing Security for Microsoft SQL Server 2005 (available as two-day classroom training and a Microsoft e-learning series in early 2006)

2789: Administering and Automating Microsoft SQL Server 2005 Databases and Services 2005 (available as one-day classroom training and a Microsoft e-learning series in early 2006)

2790: Troubleshooting and Optimizing Database Servers Using Microsoft SQL Server 2005 (available as two-day classroom training and a Microsoft e-learning series in mid-2006)

 

Upgrade Exam for an MCDBA (One Exam Required)

Courses

Exam 70?447: UPGRADE: MCDBA Skills to MCITP Database Administrator by Using Microsoft SQL Server 2005

2786: Designing a Microsoft SQL Server 2005 Infrastructure (available as two-day classroom training and a Microsoft e-learning series in early 2006)

2787: Designing Security for Microsoft SQL Server 2005 (available as two-day classroom training and a Microsoft e-learning series in early 2006)

2788: Designing High Availability Database Solutions Using Microsoft SQL Server 2005 (available as three-day classroom training and a Microsoft e-learning series in early 2006)

2789: Administering and Automating Microsoft SQL Server 2005 Databases and Services 2005 (available as one-day classroom training and a Microsoft e-learning series in early 2006)

2790: Troubleshooting and Optimizing Database Servers Using Microsoft SQL Server 2005 (available as two-day classroom training and a Microsoft e-learning series in mid-2006)