MCITP Self-Paced Training Kit (Exam 70-442): Designing and Optimizing Data Access by Using Microsoft® SQL Server™ 2005: Designing and Optimizing Data Access by Using Microsoft SQL Server 2005 (Microsoft Press Training Kit) (英語) ペーパーバック – 2007/4/28
Kindle 端末は必要ありません。無料 Kindle アプリのいずれかをダウンロードすると、スマートフォン、タブレットPCで Kindle 本をお読みいただけます。
EXAM PREP GUIDE
Ace your preparation for the skills measured by MCITP Exam 70-442—and on the job. Work at your own pace through a series of lessons and reviews that fully cover each exam objective. Then, reinforce what you’ve learned by applying your knowledge to real-world case scenarios and practice exercises. This official Microsoft study guide is designed to help you make the most of your study time.
Maximize your performance on the exam by learning to:
- Create data access solutions, connections, and models
- Write database queries, specialized queries, and XQuery expressions
- Programmatically administer a SQL Server service
- Design code that validates user data and handles errors
- Choose appropriate transaction isolation levels and optimize locking
- Tune query and application performance
Assess your skills with practice tests on CD. You can work through hundreds of questions using multiple testing modes to meet your specific learning needs. You get detailed explanations for right and wrong answers—including a customized learning path that describes how and where to focus your studies.
A Note Regarding the CD or DVD
The print version of this book ships with a CD or DVD. For those customers purchasing one of the digital formats in which this book is available, we are pleased to offer the CD/DVD content as a free download via O'Reilly Media's Digital Distribution services. To download this content, please visit O'Reilly's web site, search for the title of this book to find its catalog page, and click on the link below the cover image (Examples, Companion Content, or Practice Files). Note that while we provide as much of the media content as we are able via free download, we are sometimes limited by licensing restrictions. Please direct any questions or concerns to firstname.lastname@example.org.
Sara Morgan, MCSD, MCDBA, specializes in Web-based applications and the author of Building Intelligent .NET Applications: Agents, Data Mining, Rule-Based Systems, and Speech Processing.
Tobias Thernstrom has 13+ years' experience with SQL Server, serves as program manager on the SQL Engine Platform Team at Microsoft, and helped develop several Microsoft certifications for SQL Server.
There are numerous code snippets showing exactly what should be done in WCF to implement a specific feature. These were very helpful in defining and developing mid-level expertise in WCF.
This book gives the programmer yet another view from inside Microsoft on how they see WCF. The WCF communication process is complex and mastery is going to take a number of viewpoints to be able to use it successfully in practice.
Every serious WCF programmer should read this book to get Microsoft's inside viewpoint.
One caveat however, There are no complete examples in the book. The companion CD contains many complete examples, several book chapters in pdf files, and a series of test examples.
Therefore, you will have to go to the CD to find out where to place the details covered in the book. I believe that a book should tell you where to place the details examined in the text inside the program files to give everything taught a proper context as it is being introduced. So, I took off one star.
The material itself is well-presented, though some of the forward references make it hard to tie certain aspects together (e.g. message header security with attributes). However, 2 passes through the book should be sufficient to prepare any reader for the test. This was the only study material used (in conjunction with the provided test exams) and I passed the test the first time though.
The test exams are worth a bit of note, as they are not terribly connected to the book material. More than a few of the questions will touch on topics that are not in the book. Moreover, the exam answers will reference chapters in the book that are either different or do not exist. There seems to be a good bit of disconnect between the exam manufacturer and the authors. However, the book itself contains relatively few errors that will cause any problems.
The reason these errors do not affect my rating of the book is that in researching and learning about these other topics, I feel I got a more well-rounded WCF education and that it better-prepared me for the test. Some of these tangents, like the WebServiceHost, COM+, and some other attributes, proved very useful. The additional information made clearer the links between WCF and various other technologies.
Overall, I highly recommend this book. This should be the only resource needed to pass the exam, and it is quite well-written.
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.
Then comes the exam questions. You think you've studied the book and understood it reasonably well and then you get a question which just looks like nothing you've read so you make a guess, get it wrong and the 'explanation' points you to a chapter in the book as a reference. Go to that chapter and there's nothing that covers that question at all!
I don't get how the official study kit could not even prepare you for the practice exam!! I'm now off to read MSDN as it seems a much more comprehensive source for WCF.
I would change my star rating, but Amazon won't let me. This book just left me frustrated.