| | |  | Manager's Guides to Computing | Home » » » MCTS Self-Paced Training Kit (Exam 70-561): Microsoft® .NET Framework 3.5 ADO.NET Application Development (Self-Paced Training Kits) | | | | | | | Description: | | EXAM PREP GUIDE Ace your preparation for the skills measured by MCTS Exam 70-561and on the job. Work at your own pace through a series of lessons and reviews that fully cover each exam objective. Then, reinforce and apply what you’ve learned through 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: - Connect to data sources; query and retrieve data
- Manage data integrity and transactions
- Use LINQ to query data across types, including XML
- Work with DataSets and in-memory stores
- Synchronize dataincluding smart-caching strategies
- Generate an EDM using the Entity Framework
- Use ADO.NET Data Services for Internet applications
PRACTICE TESTS Assess your skills with the 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 answersincluding a customized learning path that describes how and where to focus your studies. Your kit includes: - 15% exam discount from Microsoft. Offer expires 12/31/13. Details inside.
- Official self-paced study guide.
- Practice tests with multiple, customizable testing options and a learning plan based on your results.
- 240+ practice and review questions.
- Code samples in Microsoft Visual Basic® and Visual C#® on CD.
- 90-day trial of Microsoft Visual Studio® 2008 Professional Edition.
- Fully searchable eBook of this guide.
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 booktech@oreilly.com.
| | | Product Details: | | | Author:
| Shawn Wildermuth | | Hardcover:
| 512 pages | | Publisher:
| Microsoft Press | | Publication Date:
| March 25, 2009 | | Language:
| English | | ISBN:
| 0735625638 | | Product Length:
| 9.1 inches | | Product Width:
| 7.4 inches | | Product Height:
| 1.6 inches | | Product Weight:
| 2.65 pounds | | Package Length:
| 8.7 inches | | Package Width:
| 7.4 inches | | Package Height:
| 2.0 inches | | Package Weight:
| 2.6 pounds | | Average Customer Rating:
|  based on 13 reviews |
| | | | Customer Reviews: | |
Average Customer Review:
 ( 13 customer reviews )
Write an online review and share your thoughts with other customers.
Most Helpful Customer Reviews
27 of 27 found the following review helpful:
 Satisfactory for 60% of exam topics, poor for 40%Apr 01, 2009
By Mark Price
My copy arrived from Amazon this morning (1st April 2009). I took and passed the ADO.NET 3.5 (beta) exam a year ago, but I am looking for book(s) to recommend to others who want to get certified.
This book provides satisfactory information about ADO.NET 2.0 data APIs such as DbConnections, DbDataAdapters, DataSets, and so on. According to Microsoft's official exam preparation guide, these topics are 60% of the exam. (You need 70% to pass.)
But I have major issues with the rest of the content...
1) LINQ to XML isn't in the exam, yet there is a 10 page lesson on it. (I'm not too bothered about this, because it's nice to have extra content, but why not flag it as "bonus" material not required for the exam?)
2) Entity Framework (EF) is 11% of the exam, but the EF chapter is only 28 of 500 pages (and those 28 pages include a lab exercise and review questions; the actual lesson content is only 19 pages!).
3) The lesson content for "Synchronization Services for ADO.NET" (Sync) is 10 pages. Combined with caching and notification (see comment 4 below) Sync is 15% of the exam. In my opinion this is the most egregious example of weak content. There should be *at least* 100 pages of content on Sync because it can get very complicated when setting up the classes to do bi-directional sync and handling conflicts.
4) There is a good section on SqlCacheDependency, but nothing on SqlDependency or SqlNotificationRequest. The authors could at least have said "SqlDependency works with SQL Server 2005 and later. It has a AddCommandDependency method to tell it what data you're interested in being notified about. Hook up to the OnChange event to receive those notifications."
5) LINQ (and especially LINQ to SQL) are a minor percentage of exam questions (~5%), yet 100+ pages are spent on them. To be clear, I'm not saying I want less LINQ content. I just think there should also be 100+ pages each on EF and Sync.
6) ADO.NET Data Services is not in the exam, but it has a 40 page chapter. Is it because one of the author's was contracturally obligated to provide n pages of content, knew a bit about this topic, and threw it in, even though it is not relevant to the audience for this book? (Like with LINQ to XML, I would not be as bothered by this *if* the authors had put more effort into topics actually on the exam.)
I have written books and training courses myself, so I know how difficult it can be, and therefore have *some* sympathy for the authors. OTOH, if you don't want to do the work, don't agree to write a book! (Or in this case, since there are three authors, a third of a book. I wonder which author(s) were responsible for the EF and Sync content...)
[...]
To learn EF, I bought all the books that cover it, and in my opinion the best is Julia Lerman's Programming Entity Framework. To learn Sync, I just read the MSDN documentation.
Sadly, spending an hour on Microsoft's free MSDN site will provide better information on the new data APIs in ADO.NET 3.5 than buying this book.
If MS Press needs good reviewers before publishing future books on .NET topics, please get in touch via MSN: markjprice
4 of 4 found the following review helpful:
 Sufficient for the examMay 14, 2009
By Michael J. Mcmahon Jr.
This book is sufficient for passing the exam. This was the only resource I used (aside from MSDN), and I passed the exam. However, I must say that this book will only be sufficient if you have experience with some ADO.NET functionality already - preferably database connections and structuring principles. If you are completely new to ADO.NET and database use in general, this will only provide a good starting point and more reading will be required to fully understand the topics well enough for the exam.
Compared to other Microsoft training kits, this one was disappointing for many reasons (hence the lower review than I've given other books). Firstly, the grammatical errors are plentiful. They are present not only in the text but in the example code as well. For example, more than one LINQ query suddenly has a reference to a new variable that should not be there. Look through the examples carefully and do not accept them if they don't make sense. Similar errors exist in the lesson review questions.
The content itself is left at a high level, for the most part. While some areas like connection strings are described with a great deal of verbiage, most areas that need it such as LINQ and Entity Framework are left quite short. For example, useful topics related to those two sections include lambda expressions and better descriptions of WHERE clause syntax - none of which is present. The coverage is broad, yet shallow. While I understand that DataSet use is a deep topic, additional examples and use cases would be helpful for the exam.
The practice tests were typical for the MCTS training kits. The questions helped to illuminate the areas missed by the book, though there are still some errors - e.g. questions that are marked as incorrect when the explanation states it should be correct. The book itself acts more as a supplement to the training exam.
In all, the book was useful as a preparation guide, but only barely. It was far more helpful to me to have a solid understanding of databases and relational structures than it would have been to have only used the book. With some extra content on EF, LINQ, and DataSets, this book could be much better and a more well-rounded preparation guide. As it stands, though, it is merely mediocre - however, mediocre enough to help me pass the exam... If the quality of the material dropped below this level, the value of the study guide would be insufficient to merit using it as preparation for the exam.
4 of 4 found the following review helpful:
Typos abound...Apr 15, 2009
By PH Bible Student
If you're the type who is easily frustrated, this book will drive you up a wall. I've only read the first 103 pgs, but already I've found the following errors (not counting trivial spelling errors):
1) p. 19, there is a mixup between RsaProtectedConfigurationProvider, which is specified, and DataProtectionConfigurationProvider, which is actually used. Note that this error occurs in the VB code, but not in the C# code.
2) pp. 43-44, we are told we will see a demonstration of a transaction where a column is updated in one table, and a row is inserted into another table; instead, the VB code shows two SELECT statements (the C# code is correct, however).
3) p. 51, quiz question #1, option A is said to be correct, and option B is said to be incorrect, even though the only apparent difference is that option A uses a user id and password, whereas option B uses SSPI. The answer key says that in option B there is no space between the words "Initial" and "Catalog," but there is no way for the reader to know this since the line is split after the word "Initial" (this split occurs in options A and B alike).
4) p. 103, quiz question #2, option A is said to be correct, and option C is said to be incorrect because there is no such thing as a "LEFT INNER JOIN". Of course, option A uses the same LEFT INNER JOIN that is employed in option C.
I'm going to keep working with this Training Kit because there really isn't any alternative. Still, these kinds of typos are inexcusable.
UPDATE: typos seem to be limited primarily to the sections written by James Wightman; sections by Mark Blomsma ad Shawn Wildermuth (pp. 133ff) seem mostly OK. The practice exams on the CD use an italicized font, and this makes some of the words almost unreadable on my 22-inch, 1680x1050 LCD monitor.
3 of 3 found the following review helpful:
It's only 2/3 of a book.Apr 26, 2009
By Xangis
This book needs to be about 200 pages longer to properly cover all of the topics on the exam.
For the most part I agree with Mark Price's review, which is pretty much spot-on. This book is sorely lacking when it comes to Entity Framework, Sync, SQL dependencies and notifications. However, the LINQ to XML lesson was useful (a question on it did turn up on my exam).
Even though the topic coverage in the book is pretty sparse, the practice tests are pretty helpful and cover a range of topics closer to the exam. I passed the 70-561 on the first try, but only because the practice tests were a wake-up call that told me I needed to find another source of information to study the EF, SQL dependencies, and Sync.
3 of 3 found the following review helpful:
Lacks Sufficient Material for MCTS ExamApr 22, 2009
By T. Cummings
In preparation for the MCTS: 70-561 exam, I have read this book cover to cover (twice). As stated by others, while it does cover the basics, such as connection, command, readers, adapters, quite well, it simply glosses over other areas that are a large percentage of the exam. For example, the material on sync services and entity framework is nearly non-existent (however these topics cover nearly 25% of the exam). I was really hoping that this book would deliver, considering other texts in the MCTS series are excellent study guides, but unfortunately, I cannot recommend this book.
See all 13 customer reviews on Amazon.com
| | |
|
