This Microsoft Exam 70-516 MCTS: Accessing Data with Microsoft .NET Framework 4 course is designed to build the student's knowledge and skills on accessing data sources using ADO.NET and the .NET Framework.
12 Months Unlimited 24x7 Online Access
24x7 online access to the course materials - anytime, anywhere, and on any device. Just log-in online and learn the skills you need - all at your own pace.
With all courses arranged via multiple on-demand sections, comprehensive navigation & controls allow you to fast forward, skip, rewind, restart, and effectively control your learning pace. This makes it easy to stop at any time, and then quickly get back to where you left off.
Expert Instructor-Led Multimedia Training
Get trained with full multimedia materials by the finest expert instructors in IT today. This creates a truly personal learning experience, and simulates all the benefits of classroom based learning - all from the comfort of your own home/office.
Multi-Tiered Exam Preparation
Objective Testing : Utilising questions that follow a specific module, focusing on specific key skills within that area of knowledge.
Full Practice Exams : Broad-base exams that cover multiple modules, or the entire syllabus.
Certification Practice : Learn where your strong & weak points exist. Simulators give you the chance to practice an actual certification exam. These simulators adhere to the same format as the actual exam provided by a testing centre.
The flexibility of these exam simulators & practice-tests allows you to monitor what you've learned, giving you the confidence required to pass your exams at the first attempt.
Candidates for this exam use Microsoft Visual Studio 2010 and ADO.NET 4 to develop the data access layer of an application. Candidates should have a minimum of two to three years of experience developing application components that interact with a variety of data sources. In addition, candidates should have a thorough understanding of relational database concepts and should have a minimum of one to two years of experience using a relational database management system.
Candidates should also have a good grasp of the following:
ADO.NET 4 coding techniques and framework components
ADO.NET Data Services LINQ
LINQ to SQL
Entity Framework technologies
Structured Query Language (SQL)
Database Structures/Schemas (Objects) XML
Students can select either VB or C# for their training language.
70-516 Accessing Data with Microsoft .NET Framework 4.0
Section 1 - Working with Disconnected Classes ADO.NET Classes - DataTable ADO.NET Classes - DataRow Enumerating a Data Table DataSet Object DataRelation Object Merging DataSets DataTable and DataSet Classes Write XML Data Binding Review Test Our Knowledge
Section 2 - Working with Connected Classes Connected Classes DbConnection Object Connection Strings SQL Server Connection String Connection Pooling DbCommand Object Multiple Active Result Sets DbDataAdapter Object DataRow Object Saving Changes Using Update Opening the Connection DbProviderFactory Classes Working with Transactions Transaction Isolation Levels Distributed Transactions Review Test Our Knowledge
Section 3 - Understanding Language-Integrated Query Deferred Execution Object Initializers Lambda Expressions Extension Methods Query Extension Methods Last Extension Method LINQ Enabled Features Using LINQ Queries Review Test Our Knowledge
Section 4 - Using ADO.NET LINQ to SQL Modeling Your Data Mapping Stored Procedures Examining an Entity Class DataContext Class Eager Loading vs. Lazy Loading Executing Queries Projections Inner Joins Outer Joins Grouping Paging Changes to the Database Life Cycle of an Entity Modifying Existing Entities Adding an Entity Stored Procedures Submitting Changes Review Test Our Knowledge
Section 5 - Using ADO.NET LINQ to XML XMLDocument Object Searching XMLReader Class XDocument Family XDocument Class Using LINQ to XML Review Test Our Knowledge
Section 6 - ADO.NET Entity Framework LINQ to SQL vs. Entity Framework Data Model Mapping Code First Model Database First Model Generated Model Mapping Details Properties ObjectContext Provider and Connection String Information Working with Complex Types Implement Stored Procedures Partial Classes and Methods Implementing Inheritance TPC inheritance Updating the Database Schema Entity Object Generator POCO Entities Model Defined Functions Querying and Updating Opening an Entity Connection EntityCommand Object Functions and Methods Entity Sets ObjectContext Class Deleting Entities Stored Procedures Submitting Changes Review Test Our Knowledge
Section 7 - Using WCF Data Services Creating Data Services Configuring Data Services Return Database Information Querying the Data Service Working with Filters OData Functions Consuming Data Services Binding to Data Service SaveChangesOption Payload Formats Using Interceptors Review Test Our Knowledge
Section 8 - Developing Reliable Applications Implementing Instrumentation Monitor Performance Handling Exceptions Protecting Your Data Symmetric Cryptography Asymmetric Cryptography RSA Encryption Hashing and Salting Synchronization Microsoft Sync Framework Review
Section 9 - Test Our Knowledge Using ADO.NET Deployment Visual Studio Deployment Package Publish Web Tab Web.config Transformations Silverlight Considerations Review Test Our Knowledge Program Review and Resources
Really informative & very positive... They cut out all the nonsense and just gave it to me in plain terms: This is what you're going to get - and this is where you'll end up. That's all I wanted really.
David : UK
My advisor told me absolutely everything I needed to know. If I needed to know the specifics of a certain subject, he told me everything about that. He was friendly and really helpful.
Leroy : UK
They seemed very knowledgeable about the course... I made a decision quite easily, based on what they said.
Donna : UK
The advice was good. It wasn't overly complicated, so I wasn't bogged down with words that were unnecessary - and I understood where they were coming from. It was very professional.
Hayley : UK
I'd definitely recommend them. I think the price was very competitive - some of the courses out there were three times the price of what they were offering. To me, it's ideal.
Clive : UK
I feel I got good value for money. If you're a practically minded person, the course is perfect. I've also passed your details onto some other people I work with, because they're also interested in that field.
Lee : UK
I'd give the course 10/10. I've already convinced someone else to do one. I just think it's awesome to be quite honest - as long as you're prepared to put the effort in.
Leroy : UK
The advisor was absolutely brilliant. I felt like he was honest... I just can't fault it really.
Shelley : UK
The advisor was very friendly. He came across as very competent with his knowledge of the industry. He gave me a lot of confidence from that point of view.
Tim : UK
The advisor was fantastic I have to say - the way he described everything and helped me to find the right course. Everything he said made sense.