Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

I work for a small software company and once I'm certified in implementing and maintaining MSSQL, I have the opportunity to move over to implementation from support.

My question is what do you suggest as good resources, practice tests etc to prepare. I currently have limited knowledge in SQL, I'm able to write basic query's, backup and restore databases etc. I am currently working my way through the free modules in Microsoft's E-learning center and I have also the MCTS Self Paced Training Kit for Exam 70-432. Does any one have any direct experience taking the cert, if so what all did you use for study materials and practice exams?

Once I feel I'm ready the company is going to pay fro my certification, I just want to make sure I pass it the first time. I want to be well prepared and know my stuff not just what is contained in the exam.

Thanks for the assistance and information.

share|improve this question
add comment

3 Answers

See here: in particular take note of the second-chance offers.

share|improve this answer
add comment

The exams are designed to show that you have real world experience with the product, not basic knowledge. How long have you been working with the product for?

That said, I worked on at book for the 70-432. The ISBN is 1597494208 and you can find it on Amazon. http://www.amazon.com/Real-MCTS-Server-2008-70-432/dp/1597494208/ref=ntt_at_ep_dpt_3

share|improve this answer
1  
I used the MS Press book which had quite a few mistakes and required extra reading to cover some areas. Also end of chapter questions where out of sync with the chapter content. Haven't used the book that mrdenny worked on but it's got to better than the MS one. –  Ally Reilly Nov 24 '10 at 14:01
    
I do hate hearing that about the MS Press books (or really any book). The MS Press books are supposed to match the exam information pretty well. I guess they fubar'd that one up. I know that some of the MS Press books which I've read in the past were quite good. –  mrdenny Nov 29 '10 at 20:44
    
I used MS Press books for learning Windows 2000 systems and the books were great for learning, although I never took any tests. That's not to say they haven't gone downhill since then. –  James May 18 '11 at 2:27
add comment

Measure Up are pretty good for practice exams and you get a free study crib sheet. I printed this out and covered the other sides with my own notes too. Was pretty useful for the more focused cramming in the lead up the exam (and just before).

http://www.measureup.com/

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.