Getting certified: MCITP DBA

Since forever I’ve been excited about taking a Microsoft’s certification: the different types of certification you can get within Microsoft technologies, the deep knowledge and experience, and the recognition value were some of the things that always made me feel like good reasons to get certified.

But I never thought that my first achievement regarding to this was going to be a SQL Server certification: Microsoft Certified IT Professional Database Administrator (SQL Server 2005).

70-444 just passed. Alberto Ortega (left), me and Pablo Cababie (right)

I never was an expert on SQL, but it sure sound like a great challenge to take when we started discussing this with my team-mates. So, we started a few weeks ago with some practicing and learning practically from scratch in many aspects.  

70-431 SQL Server 2005: Implementation and Maintenance

This is in deed the exam where you should start your SQL certification. Not only you get to know about installing SQL Server, you also get to know the differences between the different versions, and several basis about SQL management.

This exam has 35 questions and 12 simulations. The simulations are mainly oriented about using backup features.

Certifying this exam you will get also the Microsoft Certified Technical Specialist (since it was my first exam I also got the Microsoft Certified Professional, MCP,  with this).

More info here.

70-443 Designing a Database Server Infrastructure by Using Microsoft SQL Server 2005

This exam was a little bit strange comparing to the other ones. For start, you’ll see that the exam is based on case studies: A wide description of a fake company where you can find the current platform that is using, business goals, objectives and much more.

You’ll find that the design (meaning your answers) on each case study will be different, because of the differences on the scenario described.

6 case studies with 6 to 11 questions on each one. Important note about it: Once you complete a case study and  if you did not review any of these questions, you won’t get the chance to review them if you pass on to a different case

No simulations on this one. More info here.

70-444 Optimizing and Maintaining a Database Administration Solution by Using Microsoft SQL Server 2005

This is a more depth version of the first exam, 70-431. You can find several concepts where you can improve your database infrastructure  as well you get to know some concepts in a more advanced level.

52 questions with no simulations. More info here.

70-444 completed! Yeeeiiiii! Score: 1000 )

What about SQL Server 2008?

If you are already a MCITP DBA on SQL Server 2005, you can take 70-453 exam (Transition your MCITP Database Administrator Skills to MCITP Database Administrator 2008) and upgrade it to SQL Server 2008.

And the good news, if you don’t have any certification, you can directly access MCITP DBA SQL Server 2008 by taking one exam:  70-450 Designing, Optimizing and Maintaining a Database Server Infrastructure using Microsoft SQL Server 2008.

Here you can find a poster about SQL Server 2008 certifications.

And MCDBA to MCITP? 70-431 and the upgrade exam 70-447.

Hope you could find this information useful.

Cheers!

Categories: Certifications

Tagged as: , ,

10 Comments »

  1. Hi,
    I am from Nepal and I am starting my MCITP DBA on sql server 2005.
    You have posted a very simple and useful blog here. Hope to get lots of information from you along the way.

  2. Hi,
    I am called Arif and I’m a certified MCDBA on MS-SQL Server 2000 since 2002. I have upgraded my SQL skills to SQL Server 2005 but I am wondering whether I should go for SQL 2005 or SQL 2008 Certifications. Kindly suggest?

    • Hello Arif,
      If you have already the certifications upgraded to SQL 2005, then you only need the SQL 2008. And if you ask me, I can would suggest that you keep all the certifications possibles for all the SQL versions. If you have only SQL 2005 certification, you are going to miss some of the features of 2008.
      Cheers!
      Augusto

  3. Hi

    My name is Shanker Karra, cleared MCDBA in 2006 on SQL Server 2000, with
    1) 70-228 – Installing and Configuring on SQL Server 2000
    2) 70-229 – Designing and Implementing db on SQL Server 2000
    3) 70-290 – Managing & Maintaining 2003 Server
    4) 70-293 – Panning and Manaing 2003 Network Infrastructure

    Q: What are the Papers, I need to write to upgrade to latest SQL Server 2008.

    Thanks
    Shanker Karra

  4. Hello, my name is Javier, I’m from Venezuela, recently got MCTS SQL Server 2005 and I have planned to present to MCITP exams and then submit the upgrade to 2008 is this a good idea?

    Thanks …

    Greetings

    • Hello Javier,
      Yes, of course is a good idea. You only need to take one exam and you’ll get to be certified in SQL 2008, which as you may already know has some new and important features.
      For certifications, more the merrier :)
      Éxitos!
      Augusto

  5. And the good news, if you don’t have any certification, you can directly access MCITP DBA SQL Server 2008 by taking one exam: 70-450 Designing, Optimizing and Maintaining a Database Server Infrastructure using Microsoft SQL Server 2008.

    Not true. You must pass 70-432 and 70-450 to become an MCITP. It even says this in the poster you reference.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s