Vous voulez voir cette page en français ? Cliquez ici.


or
Sign in to turn on 1-Click ordering.
More Buying Choices
Have one to sell? Sell yours here
MCTS Self-Paced Training Kit (Exam 70-561): Microsoft .NET Framework 3.5-ADO.NET Application Development: Microsoft .Net Framework 3.5--ADO.NET Application Development
 
 

MCTS Self-Paced Training Kit (Exam 70-561): Microsoft .NET Framework 3.5-ADO.NET Application Development: Microsoft .Net Framework 3.5--ADO.NET Application Development [Hardcover]

Shawn Wildermuth , Mark Blomsma , Jim Wightman
5.0 out of 5 stars  See all reviews (1 customer review)
List Price: CDN$ 87.99
Price: CDN$ 55.43 & this item ships for FREE with Super Saver Shipping. Details
You Save: CDN$ 32.56 (37%)
o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o
Usually ships within 1 to 3 weeks.
Ships from and sold by Amazon.ca. Gift-wrap available.

Frequently Bought Together

Customers buy this book with MCTS Self-Paced Training Kit (Exam 70-503): Microsoft .NET Framework 3.5-Windows Communication Foundation: Microsoft .Net Framework 3.5 Windows Communication Foundation CDN$ 46.08

MCTS Self-Paced Training Kit (Exam 70-561): Microsoft .NET Framework 3.5-ADO.NET Application Development: Microsoft .Net Framework 3.5--ADO.NET Application Development + MCTS Self-Paced Training Kit (Exam 70-503): Microsoft .NET Framework 3.5-Windows Communication Foundation: Microsoft .Net Framework 3.5 Windows Communication Foundation
Price For Both: CDN$ 101.51

One of these items ships sooner than the other. Show details



Product Details


Product Description

Book Description

EXAM PREP GUIDE Ace your preparation for the skills measured by MCTS Exam 70-561—and 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 data—including 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 answers—including 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.

About the Author

I am a Microsoft C# MVP and the founder of Wildermuth Consulting Services, LLC, a company that is dedicated to delivering software and training solutions in the Atlanta, Georgia area. I am also a speaker on the INEA Speaker's Bureau and have appeared at several national conferences to speak on a variety of subjects. I am the author of the book "Pragmatic ADO.NET", the upcoming "Prescriptive Data Architectures", both for Addison-Wesley as well as co-author of several certification books for Microsoft Press. I have been writing articles for a number of years for a variety of magazines and websites, including MSDN, MSDN Online, DevSource, The ServerSide .NET, ONDotNet.com and Intel's Rich Client Series. I have enjoyed building data-driven software for more than twenty years.

Mark Blomsma, Microsoft MVP for C#, specializes in .NET technologies, enterprise application development and integration, and software renovation

Jim Wightman is a programmer, architect, and consultant with 27+ years of software development experience. He currently focuses on Windows® Azure, Windows 7, and applying Microsoft technologies to environmental issues.


Inside This Book (Learn More)
Browse Sample Pages
Front Cover | Copyright | Table of Contents | Excerpt | Index
Search inside this book:

Tags Customers Associate with This Product

 (What's this?)
Click on a tag to find related items, discussions, and people.
 

Your tags: Add your first tag
 


 

Customer Reviews

1 Review
5 star:
 (1)
4 star:    (0)
3 star:    (0)
2 star:    (0)
1 star:    (0)
 
 
 
 
 
Average Customer Review
5.0 out of 5 stars (1 customer review)
 
 
 
 
Share your thoughts with other customers:
Most helpful customer reviews

1 of 2 people found the following review helpful
5.0 out of 5 stars Very Good, Jun 8 2010
By 
Burlington Dude (Burlington, Ontario) - See all my reviews
This review is from: MCTS Self-Paced Training Kit (Exam 70-561): Microsoft .NET Framework 3.5-ADO.NET Application Development: Microsoft .Net Framework 3.5--ADO.NET Application Development (Hardcover)
Another successful exam in my MCPD exam series. I gave 4 stars for a similar book, because the test questions are a lot harder on the real exam than on the companion CD, but after I realized that it is no longer an issue. I spent exactly 3 days reading the book and preparing for the exam and I passed it. I did not receive a single question that was not covered in this book.
Help other customers find the most helpful reviews 
Was this review helpful to you? Yes No

Share your thoughts with other customers: Create your own review
Most Helpful Customer Reviews on Amazon.com (beta)
Amazon.com: 2.5 out of 5 stars (13 customer reviews)

27 of 27 people found the following review helpful
2.0 out of 5 stars Satisfactory for 60% of exam topics, poor for 40%, April 1 2009
By Mark Price - Published on Amazon.com
This review is from: MCTS Self-Paced Training Kit (Exam 70-561): Microsoft .NET Framework 3.5-ADO.NET Application Development: Microsoft .Net Framework 3.5--ADO.NET Application Development (Hardcover)
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 people found the following review helpful
3.0 out of 5 stars Sufficient for the exam, May 14 2009
By Michael J. Mcmahon Jr. - Published on Amazon.com
Amazon Verified Purchase(What's this?)
This review is from: MCTS Self-Paced Training Kit (Exam 70-561): Microsoft .NET Framework 3.5-ADO.NET Application Development: Microsoft .Net Framework 3.5--ADO.NET Application Development (Hardcover)
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 people found the following review helpful
3.0 out of 5 stars Typos abound..., April 15 2009
By PH Bible Student - Published on Amazon.com
Amazon Verified Purchase(What's this?)
This review is from: MCTS Self-Paced Training Kit (Exam 70-561): Microsoft .NET Framework 3.5-ADO.NET Application Development: Microsoft .Net Framework 3.5--ADO.NET Application Development (Hardcover)
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.
 Go to Amazon.com to see all 13 reviews  2.5 out of 5 stars 
 
 
Only search this product's reviews



Listmania!

Create a Listmania! list

Look for similar items by category


Look for similar items by subject


Feedback


Amazon.ca Privacy Statement Amazon.ca Shipping Information Amazon.ca Returns & Exchanges