Whether you’re already a database professional or would like to become one, you’ve probably thought about getting certified in SQL Server. Do you need to be certified? What certifications are available and which should you take first? How should you prepare for the exams? Kendra Little is a Microsoft Certified Master in SQL Server. She’ll explain what certifications are available, what the advantages are of becoming certified, and give practical tips for making the most of your exams.
Want to see the links from the video? Scroll on down– the links are at the bottom of the post.
SQL Server Certifications: Helpful Links
Certification Exams for Microsoft SQL Server 2008
| MCTS | MCITP | MCM | MCA | |
| Database Administrator | Exam 70-432 | Exam 70-450 | Exam 88-970 then Exam 88-971 |
MCA Board Exam |
| Database Developer | Exam 70-433 | Exam 70-451 | ||
| Business Intelligence Developer | Exam 70-448 | Exam 70-452 | N/A | N/A |
Studying for SQL Server Certifications
- Check out the SSAS Maestro Program
- Sample Community Exam Prep Guide by John Samson
- Books for SQL Server DBAS by Brent Ozar
- SQL MCM Study Group
Tools to Build Your Own SQL Server Lab
- Microsoft DreamSpark program for students and educators
- Windows Server 2008 R2 Trial
- How to extend the Windows Server 2008 Evaluation Period
- SQL Server 2008 R2 Developer Edition
Low Cost (or Free!) Virtualization Products
- VirtualBox (free): https://www.virtualbox.org/
- Parallels (Mac): http://www.parallels.com/
- VMware Fusion (Mac): http://www.vmware.com/products/fusion/overview.html
Using Amazon’s EC2 as Your SQL Server Lab
- Lynn Langit gives a five minute video on how to use SQL Server for testing and learning in EC2
Peter Maloof February 6, 2012 | 2:09 pm
Kendra:
Thanks for the presentation; some comments are here.
You mentioned that SQL Server 2012 RC0 can be downloaded – do you know if it’s a 180-day eval? I haven’t seen any limitations on the download page.
Kendra Little February 6, 2012 | 4:04 pm
Hi Peter,
Thanks for your comments! Yes, the pre-release CTP and Release Candidate are each good for 180 days after install. It’s commonly referred to as a “Time Bomb” event.
-Kendra
Peter Maloof February 6, 2012 | 5:41 pm
OK, thanks.
Pingback: Microsoft Certifications and MVP's - What are they? | James Serra's Blog
Andy Paul February 7, 2012 | 4:19 pm
Ace post Kendra!
I’ve been working with SQL Server for about 4 years now (not exclusively mind). I got started by administering a CRM + Dialler that sits on a SQL Server database, and I’ve tried to get as much of it into my job ever since. I taught myself and passed the MCTS for SQL 2005 a few years back, but in that time SQL 2008 became the latest and greatest. So I started studying for the SQL 2008 MCTS, but with SQL 2012 on the horizon I’ve decided to park the Certifications for now.
This turned out to be the best thing ever, because I’ve started reading more and more blogs to satisfy the craving for learning new SQL stuff! I’m free from the constraints of the syllabus, and I can go into more depth if something really interests me without worrying that I should be learning only what I’m going to be tested on (eg the Stairway to SQL Server Indexes was brilliant!)
I’ve found that blogs are a totally different way of learning. They tell you the practical truth about a new feature (i.e. can you realistically use it now or does Microsoft need to work on it a bit more before you should use it in a production environment).
I think that doing the MCTS gave me a broad understanding of the main technologies within SQL Server, and I probably wouldn’t be as enthusiastic about (or be able to understand) some of the bloggy goodness that can be found on the internet. So I totally recommend Certifications, but only in addition to all the other learning tools available. Just need to get the illusive DBA job now!
Thanks again for the post – keep up the good work!
Kendra Little February 7, 2012 | 4:24 pm
Thanks for your feedback– that’s really great to hear. And I agree about the Stairway Series of articles on SQL Server Central: there’s so much great content in those!
If you’re interested and excited about the technology, and you’re actively learning on your own, a database administrator job can’t be far away if that’s your goal. It’s always hard to get into an industry, but on the other hand it’s really hard for folks to find a good DBA these days as well.
Pingback: Certification Time !! | 23dba
Dukagjin Maloku March 23, 2012 | 2:51 am
As always, valuable things!
Pingback: Find Primary Key or Foreign Key Constraints on a Column in All Tables « Did It Save
Nikhil Bhakre September 17, 2012 | 7:11 am
Hi kendra,
Iam working as a System Administrator with Atos India Pvt Limited. Its been three years that iam working on current versions SQL Server.
Just a minute back i went through your video on Server Certification… and i would like to thank and appreciate you for providing all the vital and practical aspects for the certification. its great to know about the pros and cons from a Master!!!
As good as SQL 2012, my zeal for databases and SQL server related learning is ALWAYS ON!!!
iam preapring for the 70-432 certification in which i think most of the topics are in my bag… however i will for sure consider your vital advice.
Iam a beginner and i look upto you as my mentor and guide.
I hope to hear back from you… thanks once again
Have a great day ahead.
Regards
Nikhil
Amit.M September 18, 2012 | 12:26 am
Hi Kendra,
I am a Software Tester & i want to clear SQL certification, but i have only basic knowledge of Sql Server 2008(don’t know the programing part like SP’s, Triggers etc). so can you please suggest should i attempt for SQL server certification ?
Many Thanks,
Amit
Kendra Little September 18, 2012 | 10:01 am
Hi Amit,
Each test has a very detailed list of the skills measured. Click on the links for the test in the post and then read the ‘skills measured’ tab on the Microsoft site– that will give you a very concrete sense of what you need to study for each exam.
Ashvini October 26, 2012 | 1:23 pm
Hi Kendra,
I have read about 70-432 exam from john’s site.
I have “MCTS EXAM 70-433 self paced Training Kit”.
Can refer this kit to prepare for my 70-432 exam.
please reply.
Many thanks,
Ashvini
Kendra Little October 26, 2012 | 6:12 pm
Since these exams are on different topics, I don’t think that would be very effective.
Take a look at what the exams cover on the Microsoft site and you’ll see the differences:
http://www.microsoft.com/learning/en/us/exam.aspx?id=70-433
http://www.microsoft.com/learning/en/us/exam.aspx?id=70-432
There’s a “skills measured” tab for each exam which shows you that they really do look at different things.
Ashvini October 26, 2012 | 8:14 pm
Hello Kendra,
I have search about topics on respective sites.
You are right, it won’t be very effective.
Skill requirements of both the exam are different.
70-433 is for database development and 70-432 is about implementation and maintenance.
Thank you very much for guidance,
Ashvini.
Demis November 17, 2012 | 5:27 am
Hi Kendra,
Thank you for your short, precise and easily understandable presentation.
I am planning to take certifications on Microsoft SQL server. What is your advice to start my certifications, from SQL server 2008 or SQL server 2012? Are SQL 2012 certifications the same as SQL 2008? I mean like MCTS, MCITP, MCM, MAM…
Kendra Little November 18, 2012 | 10:54 pm
Hi Demis,
There are some changes for SQL Server 2012 certifications. I did a webcast answering your very question– check it out here: http://www.brentozar.com/archive/2012/04/sql-server-certification-changes-video/
[Edit: fixed link-- got the wrong one at first!]
Julius December 19, 2012 | 1:32 pm
Hi I am MCITP Certified. I have my mcp, net infrastructure, and active directory, I am currently working on a helpdesk. I think i would like to go sql. I kinda want to peak in first and see if its interesting and exaclty whats its about. Any suggestions.
Kendra Little December 20, 2012 | 2:10 pm
Sure– my suggestion would be to play around with the product. This video and the links have some info to get you kick started on setting up your own lab.
Jesse James January 13, 2013 | 3:30 pm
Thank you for this! This was exactly what I needed
ammu May 11, 2013 | 9:38 am
Hi,
I hav cleared mssql 2005 certification on 2009.now i hav completed my graduation .so my next growth for sql would be which part?plz give some idea
Kendra Little May 11, 2013 | 9:49 am
First step is to evaluate what your career goals are! Decide where you want to go and start mapping out a plan to get there.