solving sql server problems for millions of dbas and developers since 2006



SQL Server DBA Tips SQL Server Developer Tips SQL Server Business Intelligence Tips SQL Server Career Tips SQL Server Tip Categories SQL Server Tutorials SQL Server Webcasts SQL Server Whitepapers SQL Server Tools SQL Server Questions and Answers MSSQLTips Authors About MSSQLTips SQL Server User Groups MSSLQTips Giveaways MSSQLTips Advertising Options

MSSQLTips Facebook Page MSSQLTips LinkedIn Page MSSQLTips RSS Feed MSSQLTips Twitter Page MSSQLTips Google+ Page








SQL Server 2000 and 2005 Certification Resources

By: | Read Comments (2) | Print

Jeremy is the CTO @ Edgewood Solutions, co-founder of MSSQLTips.com and SQL Server MVP since 2009.



Related Tips: More

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!

 



Related Tips: More | Become a paid author


Last Update: 6/6/2006

Share: Share 






Comments and Feedback:

Friday, May 08, 2009 - 12:00:12 AM - kmkrishna1 Read The Tip

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

 

 


Tuesday, June 28, 2011 - 8:02:01 AM - Vera VB Read The Tip

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



Post a Comment or Question

Keep it clean and stay on the subject or we may delete your comment.
Your email address is not published. Required fields are marked with an asterisk (*)

*Name   *Email   Notify for updates
Comments
*Enter Code refresh code


 
Sponsor Information
Try the free performance monitoring tool from Idera!

It takes just 5 minutes to connect your SQL Databases to source control. Got 5 minutes? Get started now.

What grade do you think your SQL Servers get? Find out with Edgewood's SQL Server Health Check starting at $995.

Free Trial: Get Proactive Insight with Spotlight® for SQL Server Enterprise.

Join the over million SQL Server Professionals who get their issues resolved daily.

Valuable SQL Server web casts on Performance Tuning, Development, Administration, SSIS and more...


Copyright (c) 2006-2012 Edgewood Solutions, LLC All rights reserved
privacy | disclaimer | copyright | advertise | about
authors | contribute | feedback | giveaways | user groups
Some names and products listed are the registered trademarks of their respective owners.


Edgewood Solutions LLC | MSSharePointTips.com | MSSQLTips.com