Some of you may be wondering if you should get the SQL Server 2008 certifications or wait for new SQL Server 2008 R2 certifications. There’s no point in waiting, because there will not be any new exams for R2. See the blog below for the reasons why. If you want to get a SQL Server certification, go ahead and prepare for the SQL Server 2008 exams.
Why the SQL Server 2008 Certifications Don’t Cover R2 http://blogs.msdn.com/gerryo/archive/2010/05/03/why-the-sql-server-2008-certifications-don-t-cover-r2.aspx
SQL Server Certification
Levels/types of certification, each having a prerequisite of the one before it.
· MCTS = Pass one test in a given technology area http://www.microsoft.com/learning/en/us/certification/cert-sql-server.aspx#tab2
· MCITP = Pass one or more tests that relate to a skill area within a product. For SQL Server the three MCITP options are Administrator, Developer, or BI. http://www.microsoft.com/learning/en/us/certification/cert-sql-server.aspx#tab3
· MCM/Master = Pass 3 tests and a lab exercise as part of 3 weeks of rigorous training http://www.microsoft.com/learning/en/us/certification/cert-sql-server.aspx#tab5
For a nice visual representation, see http://download.microsoft.com/download/6/3/7/6370c653-e270-4e23-9685-15043f63dcce/SQLServer2008_CertPath_Complete.pdf
Click through on any exam listed in the above links for details on what to study for each exam. Start on the “Microsoft Certified Technology Specialist” tab as those exams are prerequisites for MCITP.
For example, you may wish to take the Database Development exam for SQL 2008 (70-433). http://www.microsoft.com/learning/en/us/exam.aspx?ID=70-433&locale=en-us. Click on Skills Measured for areas to practice/study. Click on Preparation Materials for potential classes, books, practice tests, and more. SQL BOL and blogs are also good prep tools. Let me know which areas you want to learn more about and I can either explain them directly and/or offer links to good study material.