Learn more about SQL Server tools

mssqltips logo
 

Tutorials          DBA          Dev          BI          Career          Categories          Webcasts          Whitepapers          Today's Tip          Join

Tutorials      DBA      Dev      BI      Categories      Webcasts

DBA    Dev    BI    Categories

 

SQL Server 2008 Certification Resources


By:   |   Read Comments (4)   |   Related Tips: More > Professional Development Certifications

Next Free Webcast - The more things change… DBAs versus Sysadmins in cloud availability


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
    • 6231A: Maintaining a Microsoft SQL Server 2008 Database (5 days)
    • 6232B: Implementing a Microsoft SQL Server 2008 Database (5 days)
  • MCITP
    • 50400A: Designing, Optimizing, and Maintaining a Database Administrative Solution for Microsoft SQL Server 2008 (5 days)

Certification Books

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
    • 6231A: Maintaining a Microsoft SQL Server 2008 Database (5 days)
    • 6232B: Implementing a Microsoft SQL Server 2008 Database (5 days)
  • 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

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
    • 6234A: Implementing and Maintaining Microsoft SQL Server 2008 Analysis Services (3 days)
    • 6235A: Implementing and Maintaining Microsoft SQL Server 2008 Integration Services (3 days)
    • 6236A: Implementing and Maintaining Microsoft SQL Server 2008 Reporting Services (3 days)
  • 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


Last Update:


next webcast button


next tip button



About the author
MSSQLTips author Tibor Nagy Tibor Nagy is a SQL Server professional in the financial industry with experience in SQL 2000-2012, DB2 and MySQL.

View all my tips
Related Resources





Post a comment or let the author know this tip helped.

All comments are reviewed, so stay on subject or we may delete your comment. Note: your email address is not published. Required fields are marked with an asterisk (*).

*Name    *Email    Notify for updates 


Send me SQL tips:

    



Wednesday, July 23, 2014 - 8:00:06 PM - Doug Back To Top

Found a site (http://www.iheadgo.com) that offers tons of practice exams for multiple subjects. They offer practice exams for almost anything possible. Check it out.

Checking out this site and looks interesting...a lot of different Exams TI.

http://www.iheadgo.com


Friday, February 10, 2012 - 11:40:30 AM - Oded Dror Back To Top

Tibor,

There is no books for 70-452 why? and next month SQL Server 2012 is coming anyway

Thanks,

Oded Dror


Monday, November 21, 2011 - 2:33:11 PM - Tibor Back To Top

Hello,

There is already a tip about the advantages and disadvantages of getting certified so I included only a link at the bottom.: The Value of the MCDBA and MCITP DBA Certification

Regards,

Tibor


Monday, November 21, 2011 - 9:55:44 AM - JR Back To Top

Good outline...Is it really worth the time to get certified?  You don't really mention anything about that.

JR


Learn more about SQL Server tools