Learn more about SQL Server tools

mssqltips logo
 

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

Tutorials      DBA      Dev      BI      Categories      Webcasts

DBA    Dev    BI    Categories

 

SQL Server 2000 and 2005 Certification Resources


By:   |   Last Updated: 2006-06-06   |   Comments (2)   |   Related Tips: More > Professional Development Certifications

Problem
Answering the question 'Why should I get certified?' yields many different answers. This is certainly the case for current versus aspiring DBA's.  Some responses are personal and career driven while others are related to the excitement of learning new technologies.

No matter how you slice it the drivers and inherent benefits are there, although perception of value of the certification differs from person to person as well.  For example, one perception with the SQL Server 2005 track is that the tests are a better representation of reality than previous certifications.  Another important factor to take into consideration is the time and financial investment because this too can be costly.  So, weigh your options and see if your employer can help you achieve this goal or see if this is something you can chip away at slowly, but surely. 

Solution
In order to get a firm understanding of the current SQL Server certifications, below is a table comparing the two certifications with the available educational options.  This information should serve as the foundation for researching and preparing for the tests.

SQL Server 2000 - MCDBA SQL Server 2005 - MCITP: Database Administrator

Certification Requirements

Certification Exams
Upgrade from MCDBA
  • Exam 70-447: UPGRADE: MCDBA Skills to MCITP Database Administrator by Using Microsoft SQL Server 2005

Microsoft Technology Specialist

  • Exam 70-431: TS: Microsoft SQL Server 2005 - Implementation and Maintenance

MCITP DBA

  • 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

Training Classes

Upgrade from MCDBA
  • 2786: Designing a Microsoft SQL Server 2005 Infrastructure (two days)
  • 2787: Designing Security for Microsoft SQL Server 2005 (two days)
  • 2788: Designing High Availability Database Solutions Using Microsoft SQL Server 2005 (three days)
  • 2789: Administering and Automating Microsoft SQL Server 2005 Databases and Services 2005 (one day)
  • 2790: Troubleshooting and Optimizing Database Servers Using Microsoft SQL Server 2005 (two days)

Microsoft Technology Specialist

  • 2779: Implementing a Microsoft SQL Server 2005 Database (available as three-day classroom training in early 2006)
  • 2780: Maintaining a Microsoft SQL Server 2005 Database (available as three-day classroom training in early 2006)

MCITP DBA

  • 2786: Designing a Microsoft SQL Server 2005 Infrastructure (two days)
  • 2787: Designing Security for Microsoft SQL Server 2005 (two days)
  • 2788: Designing High Availability Database Solutions Using Microsoft SQL Server 2005 (three days)
  • 2787: Designing Security for Microsoft SQL Server 2005 (two days)
  • 2789: Administering and Automating Microsoft SQL Server 2005 Databases and Services 2005 (one day)
  • 2790: Troubleshooting and Optimizing Database Servers Using Microsoft SQL Server 2005 (two days)
Certification Books
  • MCTS Self-Paced Training Kit (Exam 70-431): Implementing and Maintaining Microsoft SQL Server 2005
  • MCITP Self-Paced Training Kit (Exam 70-443): Designing a Microsoft SQL Server 2005 Database Server Infrastructure
  • MCITP Self-Paced Training Kit (Exam 70-444): Optimizing and Maintaining a Database Administration Solution Using Microsoft SQL Server 2005
  • MCITP Self-Paced Training Kit (Exam 70-444): Optimizing and Maintaining a Database Administration Solution Using Microsoft SQL Server 2005
  • MCITP Self-Paced Training Kit (Exam 70-443): Designing a Microsoft SQL Server 2005 Database Server Infrastructure
Practice Tests
Testing Centers
Additional Resources

  

Next steps

  • Answer the why should I get certified question for yourself. 
  • If you have a compelling reason, setup your certification goals.
  • Setup target dates to prepare and pass each exam.
  • Setup time on a daily or weekly basis to read and study for the tests.
  • Talk to your employer to see if they will pay for the tests or training or give you time on a weekly basis to study.
  • Take a practice test or two so you are prepared for the real thing.
  • Make the tests a slam dunk!

 



Last Updated: 2006-06-06


get scripts

next tip button



About the author
MSSQLTips author Jeremy Kadlec Since 2002, Jeremy Kadlec has delivered value to the global SQL Server community as an MSSQLTips.com co-founder and Edgewood Solutions SQL Server Consultant.

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    Email me updates 


Signup for our newsletter
 I agree by submitting my data to receive communications, account updates and/or special offers about SQL Server from MSSQLTips and/or its Sponsors. I have read the privacy statement and understand I may unsubscribe at any time.



    



Tuesday, June 28, 2011 - 8:02:01 AM - Vera VB Back To Top

The exams for mcitp for Microsoft SQL Server 2005 retire end of june 2011.


Friday, May 08, 2009 - 12:00:12 AM - kmkrishna1 Back To Top

MCITP certifications for Microsoft SQL Server 2008

Three MCITP certification paths build on Microsoft Certified Technology Specialist (MCTS) prerequisites and align with job roles that are relevant in the marketplace.

MCITP: Database Administrator 2008: design, deploy, optimize, and maintain SQL Server 2008

MCITP: Database Developer 2008: design, create, deploy, and maintain database solutions by using SQL Server 2008

MCITP: Business Intelligence Developer 2008: design, create, deploy, and maintain business intelligence solutions by using SQL Server 2008

 For more info

http://www.microsoft.com/learning/mcp/sql/2008/default.mspx

http://www.microsoft.com/learning/mcp/mcitp/sql/2008/default.mspx

http://download.microsoft.com/download/6/3/7/6370c653-e270-4e23-9685-15043f63dcce/SQLServer2008_CertPath_Complete.pdf

 

 

Regards,

Murali Krishnan.K

 

 


Learn more about SQL Server tools