Melville Thomson's Blog

Data, SQL and Windows Technologies


Microsoft SQL Server 2005 Certifications

  • Comments 1
  • Likes

Richard has asked me about resources for certification on Microsoft SQL Server2005.  The first place I normally start is on the Microsoft MCP site  this gives you resources about all the certifications.  Why you should get certification and links to what certification is available.
For resources for MCDBA  this link has information for current MCDBA’s also links for other database professionals transferring skills to Microsoft SQL Server.
The Certifications have been renamed look at this FAQ   for information, they are:

  • Technology Specialist (MCTS)
  • IT Professional and Professional Developer (MCITP and MCPD)
  • Architect (MCA)

MCITP Database 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.

So from that all need to complete the exam
70-431  TS: Microsoft SQL Server 2005 - Implementation and Maintenance.

Then the two individual exams:
Exam 70–443 PRO: Designing a Database Server Infrastructure by Using Microsoft SQL Server 2005
Exam 70–444 PRO: Optimizing and Maintaining a Database Administration Solution by Using Microsoft SQL Server 2005

IF you are already certified MCDBA
Then you require 70-431 and the upgrade exam
Exam 70–447 UPGRADE: MCDBA Skills to MCITP Database Administrator by Using Microsoft SQL Server 2005

Currently I am looking at the Microsoft press book MCTS Self-Paced Training Kit (Exam 70-431): Microsoft SQL Server 2005—Implementation and Maintenance (available mid-2006)I have found it easy to read and very useful.  There are a host of resources to acquiring the relevant skills Classroom training, E-Learning and Microsoft Press books.  I would also advise using the product and looking at the documentation with the product BOL.






Your comment has been posted.   Close
Thank you, your comment requires moderation so it may take a while to appear.   Close
Leave a Comment