MCITP Self-Paced Training Kit (Exam 70-442): Designing and...

Features

• Cover Type: Paperback with 544 pages
• Published by: Microsoft Press April 25, 2007
• Written in: English
• ISBN 10 Number: 073562383X
• ISBN 13 Number: 978-0735623835
• Book Dimensions: 8.8 x 7.2 x 1.5 inches
• Weighs: 2.4 pounds

Reader Reviews
Having studied similar material by both Sybex and MS Press for other Microsoft's SQL 2005 exams, I found this particular book a good preparation guide for the 70-442 exam. As you would expect, it covers the appropriate material and presents its material in an easy to follow and relevant manner. Having just sat the 070-442 exam today, I can strongly advise that just reading this book alone is not enough preparation. Having a thorough understanding of the different locking mechanisms, Multiple Active Result Sets (MARS) and transaction isolation levels, as well as using the supplementary material frequently quoted in this book (website articles, practice lessons and the companion CD included) are an essential must for anyone planning to sit the 070-442 exam. The companion CD included contains practice questions, a PDF version of the book (great for searching), as well as excerpts from the other four MS Press Inside/Programming SQL books. Having prepared by also studying other SQL material (namely the Inside-SQL series), I kept forgetting this was the official Microsoft exam guide - the style and format is less like a classroom/lab and more like an informative text with hands on examples. As a negative, the end of section review question are very light on, and the one scenario question at the end of each chapter is also extremely brief and not at all indicative of the exam. But that's precisely why you need the companion CD to fill the void. Another negative - there were some exam questions on topics that never received a mention in this study guide: "Begin Transaction WITH MARK", and using "savepoints" as examples. That alone prevents me from awarding 5 stars. Overall, this is an excellent resource, but supplemental study on the sections that emphasize "This is on the exam" is definitely required, as well as the areas mentioned above. Comment | | (Report this)