Printed 2017/08/24 05:08AM

Degree Seeker Week at SQL University, Lesson 2

By Robert Davis, 2010/07/08

Degree Seeker Week at SQL University, Lesson 2

Welcome once again eager learners to Lesson 2 of Degree Seeker Week at SQL University. I’m your guest professor for this course. I'm a little late getting to class today as I spent a large part of today fighting failing hard drives and allergies, but let's get class started. Today's lesson will investigate the Specialist and Professional series of certifications for SQL Server. We'll delve into the various tests required for each certification track and what resources are available for preparing for the exams.

There are three certification tracks that I am going to talk about today. The tracks are as follows:

  • Database Administrator
  • Database Developer
  • Business Intelligence Developer

Hopefully you have read Lesson 1. If not, I recommend doing so now.

SQL Server Certification Tracks

In the following section, I'm going to show you some details about what information is available for specific tracks on the Microsoft Learning Site. I'm not going to go into the details for all tracks. The key point I want you to take away from this is that the Microsoft Learning Site is a wealth of information and a great place to start preparing for a certification exam. It will give you a breakdown on what topics may be covered by the exam and points you to preparatory resources to help you get ready. I will go over the facts from this site for the Database Administrator track. From that point, I think you will be able to navigate your way through the resource pages for any certification exam.

Another take-away from this discussion will be the point that the Microsoft Learning Site isn't going to cover everything. You'll see that as the level of certification gets higher, the preparatory resources available gets fewer. Once you feel that you are this level of certification, you will need to branch out and start creating your own training exercises to prepare.

Database Administrator Track

The Database Administrator track is segmented into two categories. The Specialist series is geared towards professionals who perform basic administrative tasks such as installing, configuring, and maintaining SQL Server, The Professional series is targeted to individuals who design, implement, optimize, and maintain SQL Server infrastructures.

The MCTS is the certification available for the Specialist series. For this particular track, the actual certification is MCTS: Implementation and Maintenance. This certification is attained by successfully completing test # 70-432. This test is intended for professionals with 1 to 3 years experience working in an administrative capacity with SQL Server.

Here are some quick facts about this test from the Microsoft Learning Site:

The certification tests are designed to measure your level of knowledge and experience. It is advisable for even seasoned professionals to do a certain amount of studying. One popular way to prepare for the certification tests are to start off with a practice test to measure your current abilities and identify the areas you need to concentrate on for training. A number of resources are available via the Microsoft Learning Site:

The MCITP certification is the next step in the Database Administrator track. in order to attain this certification, you must achieve the MCTS certification as well. Now there is no hard rule that you must first do the MCTS exam, but you won't get the MCITP certification until both exams have been passed. the exam for this certification is test # 70-450. Here are some quick facts about this exam from the Microsoft Learning Site.

Database Developer and BI Developer Tracks

Like the Database Administrator track, the developer tracks are each segmented into two parts, an exam for the MCTS certification and an exam for the MCITP certification. Below is some basic information for each of these exams:

Database Developer Track

MCTS: Database Development
70-433: Microsoft SQL Server 2008, Database Development
MCITP Database Developer
70-451: Designing Database Solutions and Data Access Using Microsoft SQL Server 2008

BI Developer Track

MCTS: Business Intelligence Development and Maintenance
70-448: Business Intelligence Development and Maintenance
MCITP: BI Developer
70-452: Designing a Business Intelligence Infrastructure Using Microsoft SQL Server 2008

Best Practices for Preparing for Certification Exams

  1. Get experience: First and foremost certifications are a measurement of your knowledge and experience. Before you take an exam, get some experience in the field even if you have to create it yourself in a lab.
  2. Take a self-test: A self-test will help you gauge where you are at and what areas of knowledge you need to develop.
  3. Study: Take classes, read books, or do whatever works best for you when you learn.
  4. Practice: Don't just read about writing code or configuring and installing SQL Server. Do it!! Go through the steps several times until you are comfortable doing it.


When you first look at getting certified, it may appear to be a daunting task.With experience and a good amount of preparation under your belt, it can be a relatively stress free activity. I remember well the stress and worry I felt the first time I took a certification test (for SQL Server 2000). I studied for weeks; I practiced the self-tests until I could get the answer right 100% of the time, and I practiced installing and configuring SQL Server over and over again. When I actually took the test, I discovered that I knew the material inside and out. It turned out that I really had nothing to worry about, because I had prepared so diligently. Fast forward to my MCITP certifications for SQL Server 2008, and I was so confident, that I walked in without any preparation and aced both tests to upgrade my SQL Server 2005 MCITP certifications to SQL Server 2008.

The morale of that story is that with proper preparation, you don't need to worry about the exams. If you are ready, you will not have a problem with the exams. To those of you going after your MCTS or MCITP certification, best wishes to you!!

Copyright © 2002-2017 Redgate. All Rights Reserved. Privacy Policy. Terms of Use. Report Abuse.