Microsoft Database Related Certifications

I often get questions from my students at University College about how Microsoft Certifications work. In the SQL Server 2000 timeframe, Microsoft had the Microsoft Certified Database Administrator (MCDBA) certification, which was pretty involved and pretty generic. Now they have a new set of certifications, starting with Microsoft Certified Technology Specialist (MCTS), then progressing to different flavors of Microsoft Certified IT Professional (MCITP) as detailed below. These let you specialize in a more focused area.

Personally, I am a believer in getting Microsoft Certified. Studying for and passing the tests shows initiative, and you will learn a few things about areas of the product that you did not know as you go through the process. Having relevant certifications on your resume can help you get interviews, and can serve as a form of passive self-defense during technical interviews as well.

On the other hand, having a certification is not a replacement for real-world experience. Many developers have the attitude "Either you can code or you can’t, and a certification does not prove anything." Consequently, Microsoft’s developer oriented certifications have never been that popular among developers.


The New Generation of Microsoft Certifications

Microsoft Next Generation of Certifications: Frequently Asked Questions

Microsoft Certifications for IT Professionals


MCITP Database Developer

  1. SQL Server MCTS (70-431)
  2. 70-441 (Designing DB Solution)
  3. 70-442 (Designing and Optimizing Data Access

MCITP Database Administrator

  1. 70-431 (MCTS)
  2. 70-443 Designing a DB Server Infrastructure
  3. 70-444 Optimizing and Maintaining a Database Administration Solution

Or If you are upgrading from MCDBA

  1. 70-431(MCTS )
  2. 70-447 ( Database Administration by Using Microsoft SQL Server 2005 )


MCITP: Business Intelligence Developer

  1. MCTS: SQL Server 2005 (70-431) +
  2. 70-445: PRO: Designing Business Intelligence Solutions by Using Microsoft SQL Server 2005 Analysis Services +
  3. 70-446: PRO: Designing a Business Intelligence Infrastructure by Using Microsoft SQL Server 2005


Technorati Tags: ,

This entry was posted in Microsoft. Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s