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.
MCITP Database Developer
- SQL Server MCTS (70-431)
- 70-441 (Designing DB Solution)
- 70-442 (Designing and Optimizing Data Access
MCITP Database Administrator
- 70-431 (MCTS)
- 70-443 Designing a DB Server Infrastructure
- 70-444 Optimizing and Maintaining a Database Administration Solution
Or If you are upgrading from MCDBA
- 70-431(MCTS )
- 70-447 ( Database Administration by Using Microsoft SQL Server 2005 )
MCITP: Business Intelligence Developer
- MCTS: SQL Server 2005 (70-431) +
- 70-445: PRO: Designing Business Intelligence Solutions by Using Microsoft SQL Server 2005 Analysis Services +
- 70-446: PRO: Designing a Business Intelligence Infrastructure by Using Microsoft SQL Server 2005