MCITP Self-Paced Training Kit (Exam 70-442): Designing and Optimizing Data Access by Using Microsoft SQL Server(TM) 2005 (Self-Paced Training Kits)
MCITP Self-Paced Training Kit (Exam 70-442): Designing and Optimizing Data Access by Using Microsoft SQL Server(TM) 2005 (Self-Paced Training Kits)
This product is currently out of stock. Please check back.
Product Details:
Author:
Sara Morgan
Paperback:
544 pages
Publisher:
Microsoft Press
Publication Date:
April 25, 2007
Language:
English
ISBN:
073562383X
Package Length:
8.8 inches
Package Width:
7.2 inches
Package Height:
1.5 inches
Package Weight:
2.45 pounds
Average Customer Rating:
based on 4 reviews
Description:
Announcing an all-new Self-Paced Training Kit designed to help maximize your performance on 70-442, one of the required exams for the Microsoft Certified IT Professional (MCITP) Database Developer certification. This 2-in-1 kit includes the official Microsoft study guide, plus practice tests on CD to help you assess your skills. It comes packed with the tools and features exam candidates want most--including in-depth, self-paced training based on final exam content; rigorous, objective-by-objective review; exam tips from expert, exam-certified authors; and customizable testing options. It also provides real-world scenarios, case study examples, and troubleshooting labs for skills and expertise that you can apply to the job.
Work at your own pace through the lessons and lab exercises. Focusing on designing and implementing database solutions in a professional job role, this official study guide covers topics such as designing data access technologies, writing and modifying queries, validating input data and handling errors, developing a transaction strategy, and optimizing performance.
Then assess yourself using 200+ practice questions on the CD, featuring multiple, customizable testing options designed to meet your specific needs. Choose timed or untimed testing mode, generate random tests, or focus on discrete objectives or chapters. You get detailed explanations for right and wrong answers--including pointers back to the book for further study. You also get an evaluation version of Microsoft SQL Server 2005 software and an exam discount voucher--making this kit an exceptional value and a great career investment.
Customer Reviews:
Average Customer Review:
Write an online review and share your thoughts with other customers.
GoodOct 09, 2008 This book helped me prep for the 70-442 exam. I managed to pass it the first time, it dose not mean its sufficient, we need to read more books and search for other materials because no book available in market which covers everything, this book covers most of the part. I recommend Transcender Practice exams with this book.
0 of 2 found the following review helpful:
Covers all.Oct 22, 2007 This is a good book that covers all you need to know for this exam.
3 of 3 found the following review helpful:
Highly recommended exam preparation resourceOct 09, 2007 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.
7 of 9 found the following review helpful:
Much More Than a Practice for the Test BookMay 29, 2007 This book is the training manual for taking Microsofts 70-442 certification examination on SQL Server 2005. And like other training manuals, it gives an excellent introduction to the exam and provides the information that you'll need to pass the test. It includes sample tests, a time limited version of SQL Server 2005 to help with the examples, all the usual things.
This book, however, goes beyond the normal cram for an exam book in that it provides descriptions and explanations that go well beyond what will be asked on the test. This provides a basic understanding of SQL Server that goes well beyond what will be asked on the test.
For instance Appendix B runs for 70 pages and covers the internal architecture of the SQL Server product with special notes as to its operation on the new multi core CPUs, the use of CLR programming techniques (part of the .NET environment) and a lot more.
This is a book aimed at the expert. The SQL code examples are way above the trivial level. You may find that you'll need another book on SQL programming for the 2005 product to help explain what this book is covering fairly briefly.
based on 4 reviews
