2781: Designing Microsoft SQL Server 2005 Server-Side Solutions (3 days)

2782: Designing Microsoft SQL Server 2005 Databases (2 days)

70–441: PRO: Designing Database Solutions by Using Microsoft SQL Server 2005 Open License 6.0

2781: Designing Microsoft SQL Server 2005 Server-Side Solutions (3 days)

2783: Designing the Data Tier for Microsoft SQL Server 2005 (1 day)

2784: Tuning and Optimizing Queries Using Microsoft SQL Server 2005 (3 days)

70–442: PRO: Designing and Optimizing Data Access by Using Microsoft SQL Server 2005

• Prerequisite
  MCTS: SQL Server 2005 Credential

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 instead of the two required exams. MCDBAs must still obtain the MCTS: SQL Server 2005 certification as a prerequisite. The following table provides a complete list of exams and related training resources. For exam dates and specific areas of focus, see individual Exam Preparation Guides as the exams become available.

2786: Designing a Microsoft SQL Server 2005 Infrastructure (2 days)

2787: Designing Security for Microsoft SQL Server 2005 (2 days)

2788: Designing High Availability Database Solutions Using Microsoft SQL Server 2005 (3 days)

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

2787: Designing Security for Microsoft SQL Server 2005 (2 days)

2789: Administering and Automating Microsoft SQL Server 2005 Databases and Services 2005 (1 day)

2790: Troubleshooting and Optimizing Database Servers Using Microsoft SQL Server 2005 (2 days))

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

2786: Designing a Microsoft SQL Server 2005 Infrastructure (2 days)

2787: Designing Security for Microsoft SQL Server 2005 (2 days)

2788: Designing High Availability Database Solutions Using Microsoft SQL Server 2005 (3 days)

2789: Administering and Automating Microsoft SQL Server 2005 Databases and Services 2005 (1 day)

2790: Troubleshooting and Optimizing Database Servers Using Microsoft SQL Server 2005 (2 days))

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

• Prerequisite
  MCTS: SQL Server 2005 Business Intelligence

MCITP: Business Intelligence Developer candidates must first complete the requirements for the MCTS: SQL Server 2005 Business Intelligence certification (one exam). After achieving this Technology Specialist certification, candidates earn their MCITP: Business Intelligence Developer by passing one required exam. The following table provides a complete list of exams and related training resources. For exam dates and specific areas of focus, see individual Exam Preparation Guides as the exams become available.

2794: Designing a Business Intelligence Solution Architecture for the Enterprise Using Microsoft SQL Server 2005 (2 days)

2795: Designing an ETL Solution Architecture using Microsoft SQL Server 2005 Integration Services (2 days)

2796: Designing a Multi Dimensional Solution Architecture Using Microsoft SQL Server 2005 Analysis Services (3 days)

2797: Designing a Reporting Solution Architecture using Microsoft SQL Server 2005 Reporting Services (2 days)

70-446: PRO: Designing a Business Intelligence Solution by Using Microsoft SQL Server 2005