SQL Server 2000 and 2005 Certification Resources

By:   |   Comments (2)   |   Related: 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!


sql server categories

sql server webinars

subscribe to mssqltips

sql server tutorials

sql server white papers

next tip



About the author
MSSQLTips author Jeremy Kadlec Jeremy Kadlec is a Co-Founder, Editor and Author at MSSQLTips.com with more than 300 contributions. He is also the CTO @ Edgewood Solutions and a six-time SQL Server MVP. Jeremy brings 20+ years of SQL Server DBA and Developer experience to the community after earning a bachelor's degree from SSU and master's from UMBC.

This author pledges the content of this article is based on professional experience and not AI generated.

View all my tips



Comments For This Article




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

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


Friday, May 8, 2009 - 12:00:12 AM - kmkrishna1 Back To Top (3340)

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

 

 















get free sql tips
agree to terms