Cart Subtotal: $0.00

Welcome Student!

  • Contact Us
  • (888) 840-2378
  • Tech Support: (866) 830-9276
  • Click here to chat!

Microsoft 70-516: Accessing Data with Microsoft .NET Framework 4 - VB

Click on image to zoom

Be the first to review this product

SKU# 198456VB

Availability: In stock

$399.00

$99.00

Secure shopping trustmarks

Quick Overview

Microsoft 70-516: Accessing Data with Microsoft .NET Framework 4 - VB

QuickCert Exam Pass Guarantee

QuickCert’s online IT training programs are guaranteed to get you certified – or we will pay for your make-up exam. Our quality online IT courseware, packed with instruction, exercises, practice exams and test simulators will ensure you pass the exam. Learn more.

Course Description

Our Microsoft Exam 70-516 TS: 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.

Students can select either VB or C# for their training language.

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)
  • Stored procedures
  • Database Structures/Schemas (Objects) XML

We create the highest quality course curriculum possible, ensuring you receive the training and knowledge needed to succeed. 

Syllabus

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

Instructor Bio

Brian Roach

Reviews
Write Your Own Review

You're reviewing: Microsoft 70-516: Accessing Data with Microsoft .NET Framework 4 - VB

  •  
    1 star
    2 stars
    3 stars
    4 stars
    5 stars
    Quality
    Price
    Value

* Required Fields

Free Demo