Get SQL Certified: What you need to know about the SQL Server 2008 Developer (70-433) Exam

Posted on August 4th, 2009 by Gosia Grabowska

SQL Server Certification

In my last post about SQL Server Certification we talked about the SQL Server 2008 Administrator (70-432) Exam. 

I also told you that there are 3 different types of SQL certifications:

  • Implementation and Maintenance
  • Database Development
  • Business Intelligence Development and Maintenance

Since exam 70-432 focuses on Implementation and Maintenance and we already covered it, now it’s time to talk about the second type of SQL certification: Database Development. 

You can obtain the MCTS: SQL Server 2008, Database Development certification by passing a single exam: 70-433 Microsoft SQL Server 2008, Database Development.

70-433 Exam Details

As we all know, Microsoft doesn’t like to share the details of their exams with anyone. They change their exams periodically to throw people off and keep them on their toes. I was able to get some info about the 70-433 exam but keep in mind that this information might change by the time you read this.

I don’t think it’s going to be completely different, but some things like the total number of questions, or the depth of coverage for specific topics might be different. So just keep that in mind when you are preparing for this exam, ok?

I think the best news is — you do not need any prerequisites to take this exam. This is an entry level exam for a database developer.  You will receive your MCTS status after passing this single exam.

The Microsoft Learning site states that anyone who wants to take this exam should be an IT professional who “works in jobs in which database development is their main area of responsibility, or they work in environments in which databases are central to their primary job roles. These job roles include the following:

  • IT generalists who work in environments in which SQL Server 2008 is part of an overall solution
  • IT professionals who manage systems that run SQL Server 2008
  • Developers who build applications that use SQL Server 2008
  • IT professionals who work with third-party applications that are built on SQL Server 2008″

Does that mean you can’t take this exam if you are just entering the field.  Nope — nobody is going to ask you where you work of what your title is if you go to take the exam, so don’t worry. If you have the desire to get the SQL Server Developer cert then go for it!

I heard that there are about 60 questions for this exam with 3 hours to complete it.  This might not be 100% accurate however, as the person who took this exam doesn’t remember exactly.  (Sorry guys, I guess we need more certified SQL developers out there so I can bother them with my questions. If you do find exact numbers please share them in the comments with everyone.)

The passing score is the usual 700.  I say, “usual” because most of Microsoft exams have a passing score of 700 — so that’s easy to remember. From what I heard, this exam isn’t too difficult; you should be able to pass it after adequately preparing for it.

70-433 Exam Topics

The following topics are covered in this particular exam:

  • Implementing Tables and Views (14 percent)
  • Implementing Programming Objects (16 percent)
  • Working with Query Fundamentals (21 percent)
  • Applying Additional Query Techniques (15 percent)
  • Working with Additional SQL Server Components (11 percent)
  • Working with XML Data (12 percent)
  • Gathering Performance Information (11 percent)

There is also a detailed version of this list at Microsoft Learning. It has a list of subtopics and other detailed information for this exam.

Where to Start?

Like with any other exam preparation I would start by getting some type of training material: a book, a training video or singing up for an instructor lead class.  You will get a better understanding of SQL databases with some previous database experience.  What you need is basic knowledge of what a database is and how it functions. 

If you are a complete n00b to SQL and are interested in learning the basics before studying for the developer exam, check out our free SQL 101 training videos — they are really good (I reviewed them all so you can trust me).

How About Experience?

Well, sure experience is great.  But how are you supposed to get hands-on experience with SQL when you are trying to get into the field? 

Easy — you get your own server, install a free trial version of SQL Server 2008 and practice, practice, and then practice some more. 

Follow examples from the book or video that you’re learning from and do them on your server. Make sure to break something and then try to fix it. Don’t just reinstall SQL, put your troubleshooting skills to the test and see if you can fix ‘em.  That will be extremely helpful in your position as a SQL Developer since there is no way you can just re-install the database everyone is working on.

Do I Need This Certification?

Certification is not everything; in my opinion, you need the knowledge more than your certification. The cert will however be beneficial if you’re trying to get a job as a SQL Server developer. So since you are going after the knowledge then why not get the proof that you know your stuff.

Does Train Signal have SQL Database Developer Training?

At the moment, we are very close to having the complete SQL Server Developer training available. 

I am currently working with Mel Haynes, our SQL Server Instructor on all the final videos that are going to be included in this course. We are very close — cross your fingers so that we can have it released in early September!

Related Posts:

Tags: , , , , ,

Leave A Comment: