none
Newbie - SQL server 2008 70-432 RRS feed

  • Question

  • It has been brought to my attention by my superiors that they need a DBA and will provide the training, books, etc.

    I have a rudimentary knowledge of databases based on a few Access classes over the years.  What do I need as a precursor to read or study for this cert?  I've done system admin stuff over the years, so managing a server or network (cisco) is nothing new to me.  Does having a background like this make it easy enough to just jump right into this certification track?

    I would like to give the DBA thing an honest shot, but I want to make sure I'm going about it the correct way initially.


    There is always a way...
    Tuesday, February 15, 2011 6:33 PM

Answers

  • Following the advice I've already given I believe is a good starting point even if you are an absolute beginner.

    You can also post a question on one of the many SQL Server Forums available. There is one particularly for beginners; - http://social.msdn.microsoft.com/Forums/en-US/CertGeneral/thread/a4e06e8e-af95-4d30-a13d-3c641aada536 . I and many others check this forum regularly to see if there are any questions we can answer.

    You may find installing SQL Server then downloading and installing Adventure Works for the first time will cost you a significant amount of effort, but persist, don't be afraid to ask questions and you will be fine.

    The main difficulty with the Cert books I find is not the difficulty of the content, but the difficultly in committing say one hour per day to go through this book from beginning to end (if only most SQL Server professionals did this!)

    Maybe you could find a part time evening course in a technical college on relational database design, even better if they use SQL Server as their training tool.

    Have a browse at the following book, I've not purchased it myself but it does have the right table of contents and good reviews; - http://www.amazon.com/Inside-Relational-Databases-Mark-Whitehorn/dp/1852334010/ref=pd_sim_b_5

    When you discover something in the Cert book that needs further clarification to save trees you might consider the following web site; - http://oreilly.com/

     


    If you have found any of my posts helpful then please vote them as helpful. Kieran Patrick Wood MCTS BI, PGD SoftDev (Open), MBCS http://uk.linkedin.com/in/kieranpatrickwood
    • Marked as answer by SeanPerkins Thursday, February 17, 2011 3:59 PM
    Thursday, February 17, 2011 12:57 PM

All replies

  • Hi,

    I recommend; - MCTS Self-Paced Training Kit (Exam 70-432): Microsoft SQL Server 2008 - Implementation and Maintenance: Microsoft SQL Server 2008--Implementation and Maintenance (PRO-Certification)

    If you havn't got access to the developer's edition then purchase this so you have your own practice environment; -

    http://www.amazon.com/Developer-Edtn-2008-32-bit-English/dp/B003KWQBQ2/ref=sr_1_1?ie=UTF8&s=software&qid=1297832324&sr=1-1

    Download the Adventure Works samples which are referred to in the above course material; - http://msftdbprodsamples.codeplex.com/releases/view/59211

    I also found www.learndevnow.com very helpful.

    I hope this helps,

    Kind Regards,

    Kieran.


    If you have found any of my posts helpful then please vote them as helpful. Kieran Patrick Wood MCTS BI, PGD SoftDev (Open), MBCS http://uk.linkedin.com/in/kieranpatrickwood
    Wednesday, February 16, 2011 5:02 AM
  • Thanks for the info Kieran.  Do you think that'll be enough for someone that doesn't know much or anything about databases.  I'm pretty much starting from ground zero, so I want to make sure I have some fundamentals before I start cert studying.  I've had my eye on this book and just haven't bought it yet.
    There is always a way...
    Thursday, February 17, 2011 3:11 AM
  • Following the advice I've already given I believe is a good starting point even if you are an absolute beginner.

    You can also post a question on one of the many SQL Server Forums available. There is one particularly for beginners; - http://social.msdn.microsoft.com/Forums/en-US/CertGeneral/thread/a4e06e8e-af95-4d30-a13d-3c641aada536 . I and many others check this forum regularly to see if there are any questions we can answer.

    You may find installing SQL Server then downloading and installing Adventure Works for the first time will cost you a significant amount of effort, but persist, don't be afraid to ask questions and you will be fine.

    The main difficulty with the Cert books I find is not the difficulty of the content, but the difficultly in committing say one hour per day to go through this book from beginning to end (if only most SQL Server professionals did this!)

    Maybe you could find a part time evening course in a technical college on relational database design, even better if they use SQL Server as their training tool.

    Have a browse at the following book, I've not purchased it myself but it does have the right table of contents and good reviews; - http://www.amazon.com/Inside-Relational-Databases-Mark-Whitehorn/dp/1852334010/ref=pd_sim_b_5

    When you discover something in the Cert book that needs further clarification to save trees you might consider the following web site; - http://oreilly.com/

     


    If you have found any of my posts helpful then please vote them as helpful. Kieran Patrick Wood MCTS BI, PGD SoftDev (Open), MBCS http://uk.linkedin.com/in/kieranpatrickwood
    • Marked as answer by SeanPerkins Thursday, February 17, 2011 3:59 PM
    Thursday, February 17, 2011 12:57 PM
  • Kieran,

           thank you greatly for your input and assistance....I'll be sure to follow your recommendations accordingly.  take care.


    There is always a way...
    Thursday, February 17, 2011 3:59 PM
  • Thank you for your positive feedback. It's a great motivator.
    If you have found any of my posts helpful then please vote them as helpful. Kieran Patrick Wood MCTS BI, PGD SoftDev (Open), MBCS http://uk.linkedin.com/in/kieranpatrickwood
    Thursday, February 17, 2011 4:07 PM
  • I can get 50% off this course through new horizons if you want. the cost is $1,250 for a 5 day instructor led course
    Derek Gulizia
    Monday, February 21, 2011 4:24 PM
  • Derek,

          Where would this class be held?  I'm in Alaska so I'm sure I'd have to fly there, but I can always ask my company to look into buying this for me.  1250 is an aweomse deal for 5 day course, most are like 1k a day.


    There is always a way...
    Monday, February 21, 2011 5:54 PM
  • it would be online live training. its instructor led distance learning. the only thing is its eastern time. So you would have to get up a bit early. shoot me an email dg@unitedtraining.com
    Derek Gulizia
    Monday, February 21, 2011 6:22 PM
  • How long does this offer stand?  and can you provide more details?  I'll need a good sales pitch to give to my boss, so if you could provide a link or more detail, that'd be awesome.  I'll send you an email from my corporate account.

     

    Sean P.


    There is always a way...
    Monday, February 21, 2011 6:32 PM
  • did you already send it. if it gets kicked back send it to derekg@unitedtraining.com
    Derek Gulizia
    Monday, February 21, 2011 6:59 PM
  • Does anybody know of good books for the next test in line the 70-450?  I can't seem to find anything on this test specifically like I do on the 70-432.  I did find one book but it was an instructor lead type training and not a good book for the actually exam (based on book reviews).
    There is always a way...
    Tuesday, March 15, 2011 3:34 PM
  • Hi,

    I've just found the following book; - http://www.amazon.co.uk/SQL-Server-2008-Administration-Certification/dp/0470554207/ref=sr_1_1?ie=UTF8&s=books&qid=1279208680&sr=8-1

    I've not read it myself but it does have some good reviews.

    Kind Regards,

    Kieran.


    If you have found any of my posts helpful then please vote them as helpful. Kieran Patrick Wood MCTS BI, PGD SoftDev (Open), MBCS, MCC http://uk.linkedin.com/in/kieranpatrickwood
    Tuesday, March 15, 2011 3:42 PM
  • Thanks for the link Kieran, I'll check into this.
    There is always a way...
    Tuesday, March 15, 2011 5:46 PM
  • Does anybody know what the exam requirements are for the 70-432.  I can't seem to find anything on Microsoft's website as far as passing score, score range, how many questions, time limit, etc.
    There is always a way...
    Wednesday, March 23, 2011 9:45 PM
  • Please find the following link; - http://www.microsoft.com/learning/en/us/exam.aspx?id=70-432#tab2

    I understand the format all the MCTS Database orientated exams are generally very similar; -

    Minimum pass score between 70 - 80%, aprox 45 questions to answer (with a multi-choice focus), aprox 3 hours to sit the exam.

    I generally find the best way to prepare for the exam is to sit it. It costs around £80 / $100 USD to sit an exam via prometric.com.

    As suggested earlier I recommend purchasing; - MCTS Self-Paced Training Kit (Exam 70-432): Microsoft SQL Server 2008 - Implementation and Maintenance: Microsoft SQL Server 2008--Implementation and Maintenance (PRO-Certification)

    This kit also contains an application which provides you with a mock exam of 45 questions out of a random sample of around 200 questions. This kit costs around $50USD. Have you purchased this kit yet?

    I hope this helps.

    Kind Regards,

    Kieran.

     


    If you have found any of my posts helpful then please vote them as helpful. Kieran Patrick Wood MCTS BI, PGD SoftDev (Open), MBCS, MCC http://uk.linkedin.com/in/kieranpatrickwood
    Saturday, March 26, 2011 6:31 PM
  • Thanks for the follow up Kieran, I have purchased this book....just have to read it now.
    There is always a way...
    Saturday, March 26, 2011 11:38 PM