• Pingback: My Guide to Passing MCTS Exam 70-432 - John Sansom - SQL Server DBA in the UK - SQLServerCentral.com()

  • http://SqlAndMe.com Vishal Gajjar

    Folks who are planning to take this exam should checkout this TechNet webcast


  • Pingback: My Guide to Passing MCTS Exam 70-432 | World news stories()

  • Tahir Gul

    Hi John,

    Thank you very much. your response will help me a lot.

    I am really grateful.


  • http://dirkhondong.wordpress.com Dirk Hondong

    Well done Sir, great post.

    This encourages me finally to give it a try on the exam.


  • http://twitter.com/#!/anishkumarck CK

    Hi John,

    As a dotnet programmer and a database lover, I really want to take the Microsoft certification in SQL as well as .NET.But I think I am very junior for that :( . Anyway I am really looking into the MCTS_70-433 training kit and hope one day I will make it.

    Thanks for your article.As usual I enjoyed it. You really are a sql rockstar :)


  • Bill


    I want to try for this certification but am reluctant to start because I have little knowledge/experience in SQL Server 2008 as I am just a software Tester trying to get into DBA. I have been using SQL Server every day for close to a year now but I feel like I will be lost if I got the training material and just dove in. Should I wait until I have more experience or should I just get the training stuff and jump into studying?


  • Brian Przygocki

    Hi John,

    Good, free SQL Server video training can be hard to find.
    Here are 2 resources:

    SQL Server 2008 for Oracle DBA
    These 15 modules, level 300 course provides students with the knowledge and skills to capitalize on their skills and experience as an Oracle DBA to manage a Microsoft SQL Server 2008 system. This workshop provides a quick start for the Oracle DBA to map, compare, and contrast the realm of Oracle database management to SQL Server database management.


    SQL Server 2005 Express for Beginners
    This video series is designed specifically for SQL Server beginners-individuals who are interested in learning the basics of how to create, manage, and connect to SQL Server Express databases.


  • Lewis Johnson

    John this is a great article. I’ve been on the fence for a while about starting my certification track and this will help me put things into perspective.


  • Pingback: Your Road to Becoming a DBA: Acquiring Experience is Key()

  • Pingback: SQL Server Certifications: What to Take and How to Prepare | Brent Ozar PLF()

  • Pingback: What I Will Do For You in 2012()

  • Sunandvijay

    Thanks a lot my dear friend……

    • http://www.johnsansom.com John Sansom

      You’re welcome, glad you enjoyed it!

  • Jorge Perez

    Hi John, thanks for the article, this helped me a lot on what can I focus on to get this certification.
    Cheers from Mexico.

    • http://www.johnsansom.com John Sansom

      Thanks Jorge and best of luck with your certification! I’d love to hear about it when you you pass.

  • Ashvini

    Hello John,

    I have “MCTS EXAM 70-433 self paced Training Kit”.
    Can i refer this kit to prepare for my 70-432 exam.
    please reply.

    Many thanks,

    • http://www.johnsansom.com John Sansom

      Hi Ashvini,

      I suggest you read and study the material in the book you have already purchased, then cross reference this with the syllabus on the Microsoft website for the exam you are interested in. Naturally the book is intended for the exam number of the same however you “might” be able to identify some crossover in subject matter.

      Best of luck with your exams.

    • Ram

      hi Ashvini can u please sent study material watever u have related to certification to me, i would be grateful….thanks..

  • Ashvini

    The book title is “MCTS Self-Paced Training Kit (Exam 70-433): Microsoft SQL Server 2008 Database Development”.

  • Cedell

    Is this cert still relevant? I am trying to get clear information from the MS website but it seems to be pointing me to the MCSA track. http://www.microsoft.com/learning/en/us/certification/mcsa.aspx

    This set of certs covers Win7, Win8, SQL Server, Win Server and others. Am I missing something? This will be my first cert and I want to get off to a good start.

    • http://www.johnsansom.com John Sansom

      Hi Cedell,

      This exam (70-432) is for SQL Server 2008 and is still achievable until July 2013 (see here). The link you are referencing is for the SQL Server 2012 certifications, the first being the MCSA.

  • Pingback: Your Top 10 Posts of the Year()

  • Ravi

    Hi John,

    Great article, this is very much useful for me in preparing my MCSA certification. I heard that there is a change in exam pattern or questionnaire type for MCSA. Is that true?


    • http://www.johnsansom.com John Sansom

      Ravi, unfortunately I am unable to disclose the details of exam formats due to Microsoft’s NDA. You can find out more about what exam formats you might encounter on the Microsoft Learning site here.

      Thanks for your comments!

  • Pingback: How To Win Career Gold()

  • Mauricio

    which is the minimum score to pass the exam?

    • http://www.johnsansom.com John Sansom

      Mauricio, good question! I’m not absolutely certain however I seem to recall it being 70%

  • Paulius

    I’m a new guy here, and try to find info as much as I can, but… Maybe you know, does it make any difference between 70-432 and 73-432, as from July 31 Microsoft doesn’t provide 70-432 exams. But I can accept 73-432 as title shows that it’s the same exam.
    For me it’s vital, because there are a lot of free material to learn for 2008 server, as for 2012 a lot material is paid.
    Thank you.

    • http://www.johnsansom.com John Sansom

      Paulius – Looking at the Microsoft Learning website Exam 70-432 looks to be still available.

  • Mo Allen

    I just paid to take the exam 70-432 in January, but now I am thinking of changing it to 73-432 (I assumed 73-432 is base on sql server 2012). What do you thing? I am mostly a sql server developer with good DBA knowlege and I don’t have any MCTS certification.

    • http://www.johnsansom.com John Sansom

      Mo – I’m not sure that there is an exam 73-742. You can find a full list of the currently available SQL Server Certifications/Exams on Microsoft Learning.

  • Pingback: The Year in Numbers 2013 • John Sansom()

  • Pingback: Yes! You Can be a DBA Too • John Sansom()

  • Dave Ali

    practice practice and practice then you will pass it, thanks

  • Jeeten

    Hi John
    I want to gain a Microsoft SQL Server qualification, but having
    been out of work since 2009 due to illness I wanted to know which qualification
    would be more beneficial, MCSA SQL Server 2008, MCSA SQL Server 2012 or
    I am hoping to start looking for work again by the end 2014.
    At my previous role I was working with SQL server 2005.
    Your opinion and feedback would be much appreciated.

    • http://www.johnsansom.com/ John Sansom

      Jeeten, I would recommend that you follow the MCSA: SQL Server 2012 track.

      This is the most recent recent MCSA track currently available. By studying towards it you will bring your skills up to date, as well as also acquire the knowledge needed from prior product versions (SQL 2008) etc.

      • Jeeten

        Thank you. Working towards the 2012 qualification starts today

  • Pingback: Studying for Exam 70-461 (MCSA: SQL Server 2012) | Volker Bachmann bloggt über SQL Server()