 |
GET IN THE LEAD - get certified today!
Experience the benefits of classroom learning - anytime, anywhere! QuickCert's expert instruction and multi-media courses are to get you certified - or your money back!
Read why successful professionals choose QuickCert > |
QuickCert's 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
QuickCert creates the highest quality course curriculum possible, ensuring you receive the training and knowledge needed to succeed. QuickCert is so certain this course meets and exceeds the exam objectives, we guarantee you will pass your exam!
Not sure what course is right for you?
Contact one of our Career Advisors at 888.840.2378 for assistance.
Your QuickCert Microsoft Exam 70-516 TS: Accessing Data with Microsoft .NET Framework 4 Training Package Includes:
| Delivery Format |
Instructor Led Modules |
Practice Exam Simulator |
Exam Pass Guarantee |
DVDs
or online |
|
|
|
Exam Pass Guarantee - Learn More
Free Product Upgrades
Toll Free Educational Support
Compatibility with:
98 | 2000 | ME | XP | 2003| Vista | Windows 7 | Windows 8
“I’m 100% satisfied with QuickCert’s training program. I love that it’s broken into manageable sections. This is an all-inclusive training solution… they give you the manuals, the lectures broken into short segments, and practice tests that really mirror the actual tests I’ve taken. I plan to renew my membership!!”
— Karen S., Network Administrator, Calabasas, California
Questions? Contact one of our Career Advisors at 888.840.2378 for assistance or email sales@quickcert.com.
Microsoft Exam 70-516 TS: Accessing Data with Microsoft .NET Framework 4 Course Curriculum:
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
Questions? Contact one of our Career Advisors at 888.840.2378 for assistance or email sales@quickcert.com.
