By: Tibor Nagy | Updated: 2011-11-21 | Comments (4) | Related: More > Professional Development Certifications
Problem
There are three Microsoft certifications available for SQL Server 2008. In this tip we look at available resources for each of the different certifications: Database Administrator, Database Developer and Business Intelligence Developer.
Solution
There are three tracks for Microsoft SQL Server 2008 certifications. As a result you should take different exams to become a certified Microsoft SQL Server DBA, Developer or BI expert. Additionally there are specific exams which allow you to upgrade your certifications from SQL Server 2005 to SQL Server 2008.
Below is an outline of resources for each track.
SQL Server 2008 - MCITP: Database Administrator
Certification Requirements
Certification Exams
- Upgrade from SQL Server 2005
- Exam 70-453: UPGRADE: Transition Your MCITP SQL Server 2005 DBA to MCITP SQL Server 2008
- Microsoft Technology Specialist
- Exam 70-432: TS: Microsoft SQL Server 2008, Implementation and Maintenance
- MCITP DBA
- Exam 70-450: PRO: Designing, Optimizing and Maintaining a Database Administrative Solution Using Microsoft SQL Server 2008
Training Classes
- Microsoft Technology Specialist
- MCITP
- 50400A: Designing, Optimizing, and Maintaining a Database Administrative Solution for Microsoft SQL Server 2008 (5 days)
Certification Books
- MCTS Self-Paced Training Kit (Exam 70-432): Microsoft SQL Server 2008 - Implementation and Maintenance
- SQL Server 2008 Administration: Real-World Skills for MCITP Certification and Beyond (Exams 70-432 and 70-450)
- The Real MCTS SQL Server 2008 Exam 70-432 Prep Kit: Database Implementation and Maintenance
- Measure Up Practice Tests - TS
- Measure Up Practice Tests - ITP
- Measure Up Practice Tests - Upgrade
Testing Centers
Additional Resources
- 6369AE: Implementing and Maintaining Microsoft SQL Server 2008 (16 Hours)
SQL Server 2008 - MCITP: Database Developer
Certification Requirements
Certification Exams
- Upgrade from SQL Server 2005
- Exam 70-454: UPGRADE: Transition Your MCITP SQL Server 2005 DBD to MCITP SQL Server 2008 DBD
- Microsoft Technology Specialist
- Exam 70-433: TS: Microsoft SQL Server 2008, Database Development
- MCITP Developer
- Exam 70-451: PRO: Designing Database Solutions and Data Access Using Microsoft SQL Server 2008
Training Classes
- Microsoft Technology Specialist
- MCITP
- 50401A: Designing and Optimizing Database Solutions with Microsoft SQL Server 2008 (5 days)
Certification Books
- MCTS Self-Paced Training Kit (Exam 70-433): Microsoft SQL Server 2008 - Database Development
- The Real MCTS SQL Server 2008 Exam 70-433 Prep Kit: Database Design
- Measure Up Practice Tests - TS
Testing Centers
Additional Resources
- 6370AE: Microsoft SQL Server 2008 R2 Database Development (20 Hours)
- 10344AE: MCTS (Exam 70-433): TS: Microsoft SQL Server 2008, Database Development (18 Hours)
SQL Server 2008 - MCITP: Business Intelligence Developer
Certification Requirements
- MCTS: SQL Server 2008, Business Intelligence Development and Maintenance
- MCITP: Business Intelligence Developer 2008
Certification Exams
- Upgrade from SQL Server 2005
- Exam 70-455: Upgrade: Transition Your MCITP SQL Server 2005 Business Intelligence Developer to MCITP SQL Server 2008 Business Intelligence Developer
- Microsoft Technology Specialist
- Exam 70-448: TS: Microsoft SQL Server 2008, Business Intelligence Development and Maintenance
- MCITP BI Developer
- Exam 70-452: PRO: Designing a Business Intelligence Infrastructure Using Microsoft SQL Server 2008
Training Classes
- Microsoft Technology Specialist
- MCITP
- 50399A: Designing a Business Intelligence Solution by Using Microsoft SQL Server 2008 (5 days)
Certification Books
- MCTS Self-Paced Training Kit (Exam 70-448): Microsoft SQL Server 2008 - Business Intelligence Development and Maintenance
- Measure Up Practice Tests - TS
Testing Centers
Additional Resources
- 6233AE: Implementing and Maintaining Business Intelligence in Microsoft SQL Server 2008: Integration Services, Reporting Services and Analysis Services (24 Hours)
Please note that the SQL Server 2005 exams have been retired on June 30, 2011.
Next Steps
- Setup your certification goals.
- Setup target dates for preparation.
- Get your employer to pay your exams and your training if needed.
- Check out some practice test to become familiar with the test format.
- Read these related tips:
About the author
Tibor Nagy is a SQL Server professional in the financial industry with experience in SQL 2000-2012, DB2 and MySQL.This author pledges the content of this article is based on professional experience and not AI generated.
View all my tips
Article Last Updated: 2011-11-21
