Developing Data Access Solutions With Microsoft Visual Studio 2010 Training

Live Online & Classroom Enterprise Certification Training

In this course, the student will learn to develop and optimize data access solutions using Microsoft .NET Framework 4 technologies.

Looking for a private batch ?

REQUEST A CALLBACK

Certified Trainer
Authorized Courseware
Completion Certificate from ATP

Enterprise Reporting
Lifetime Access
CloudLabs
24x7 Support
Real-time code analysis and feedback

What is Developing Data Access Solutions With Microsoft Visual Studio 2010 Certification Training about?

In this course, experienced developers who know the basics of data access (CRUD) in Windows client and Web application environments will learn to optimize their designs and develop better performing data access code by using the ADO.NET Entity Framework, LINQ, WCF Data Services, the Sync Framework, and ADO.NET.

What are the objectives of Developing Data Access Solutions With Microsoft Visual Studio 2010 Certification Training ?

Evaluate a variety of business cases, and then select an appropriate combination of data access technologies and tools most appropriate to each case. Describe the roles of Entity Framework, WCF Data Services, and ADO.NET for building and maintaining applications. Use LINQ on top of these technologies to improve productivity and the quality of their applications.

Use the tools provided with the Entity Framework to map the conceptual model used by the business logic of an application to the logical data model provided by a database.

Query an Entity Data Model (EDM) by using common methods such as LINQ to Entities, Entity SQL, and the classes in the EntityClient namespace.

Perform data modification tasks on data in an EDM.

Who is Developing Data Access Solutions With Microsoft Visual Studio 2010 Certification Training for?

This course is intended for professional .NET software developers who use Microsoft Visual Studio in a team-based, medium-sized to large development environment. They will have experience implementing data access and data binding within their Web and/or Windows client applications and are interested in learning to optimize data access code in their applications by using the Entity Framework, LINQ, and ADO.NET. Members of the audience are experienced users of Microsoft Visual Studio 2008 SP1 or newer releases of the Visual Studio product. The audience has some experience using Visual Studio 2010 for either Windows client or Web application development.

What are the prerequisites for Developing Data Access Solutions With Microsoft Visual Studio 2010 Certification Training?

An understanding of the problem-solving techniques that apply to software development, including the following principles of software development:

Modern software development models

Typical phases of a software development lifecycle

Concepts of event-driven programming

Concepts of object-oriented programming

Creating use-case diagrams

Designing and building a user interface

Available Training Modes

Live Online Training

40 Hours

Classroom Training

5 Days

Course Outline Expand All

Expand All

Module 1: Architecture and Data Access Technologies

Data Access Technologies

Data Access Scenarios

Module 2: Building Entity Data Models

Introduction to Entity Data Models

Modifying the Entity Data Model

Customizing the Entity Data Model

Module 3: Querying Entity Data

Retrieving Data by Using LINQ to Entities

Retrieving Data by Using Entity SQL

Retrieving Data by Using EntityClient Provider

Retrieving Data by Using Stored Procedures

Unit Testing Your Data Access Code

Module 4: Creating, Updating, and Deleting Entity Data

Understanding Change Tracking in the Entity Framework

Modifying Data in an Entity Data Model

Module 5: Handling Multi-User Scenarios by Using Object Services

Handling Concurrency in the Entity Framework

Transactional Support in the Entity Framework

Module 6: Building Optimized Solutions by Using Object Services

The Stages of Query Execution

Change Tracking and Object Materialization

Using Compiled Queries

Using Design-Time Generated Entity Framework Views

Monitoring Performance

Performing Asynchronous Data Modifications

Module 7: Customizing Entities and Building Custom Entity Classes

Overriding Generated Classes

Using Templates to Customize Entities

Creating and Using Custom Entity Classes

Module 8: Using POCO Classes with the Entity Framework

Requirements for POCO Classes

POCO Classes and Lazy Loading

POCO Classes and Change Tracking

Extending Entity Types

Module 9: Building an N-Tier Solution by Using the Entity Framework

Designing an N-Tier Solution

Defining Operations and Implementing Data Transport Structures

Protecting Data and Operations

Module 10: Handling Updates in an N-Tier Solution by Using the Entity Framework

Tracking Entities and Persisting Changes

Managing Exceptions in an N-Tier Solution

Module 11: Building Occasionally Connected Solutions

Offline Data Caching by Using XML

Using the Sync Framework

Module 12: Querying Data by Using WCF Data Services

Introduction to WCF Data Services

Creating a WCF Data Service

Consuming a WCF Data Service

Protecting Data and Operations in a WCF Data Service

Module 13: Updating Data by Using WCF Data Services

Creating, Updating, and Deleting Data in a WCF Data Service

Preventing Unauthorized Updates and Improving Performance

Using WCF Data Services with Nonrelational Data

Module 14: Using ADO.NET

Retrieving and Modifying Data by Using ADO.NET Commands

Retrieve and update data by using DataSet objects.

Implement transactions and handle concurrency exceptions.

Module 15: Using LINQ to SQL

Implementing a Logical Data Model by Using LINQ to SQL

Managing Performance and Handling Concurrency

Who is the instructor for this training?

The trainer for this Developing Data Access Solutions With Microsoft Visual Studio 2010 Training has extensive experience in this domain, including years of experience training & mentoring professionals.

Developing Data Access Solutions With Microsoft Visual Studio 2010 Certification Training - Certification & Exam

SpringPeople is the Authorized Training Partner of Microsoft.
The training fees is exclusive of exam cost.
For any queries; feel free to reach us at microsoft@springpeople.com

Reviews

My outlook on training changed completely after attending SpringPeople BPC training. The content, the trainer and infrastructure at SpringPeople were top notch and perfectly in tune with the industry requirements. Regardless to say, training is now something that I look forward to to. Kudos to everyone at SpringPeople!

Shweta Priya

Sony

I attended the 3-day AngularJs training at SpringPeople. The trainer was an industry veteran with vast experience in the subject. Notably, the hands-on training, and the Q&A session stood out. Overall, I found SpringPeople a great place to learn with excellent facilities and great trainers. Would recommend SpringPeople to my colleagues and friends.

Swati Singh

I attended the training on API Design for Mulesoft. The sessions were well planned and value-laden. I benefited immensely from the hands-on experience enabled through virtual labs. I would like to specifically commend the efficiency of the support team who were always available to resolve my concerns.

Nikhil Kohli

Stryker

I attended the jQuery training batch, conducted by Mr. Vijay, an SME who did a thorough coverage of all the essentials. He took us through concepts such as jQuery animations, event handlers, plugins, and jQuery-UI by small programs, very easily. The sessions were useful and well structured. By the end of the training, I was well equipped to develop a SPA on Product Management System. Overall, the learning experience at SpringPeople was great!

Heena Rajan

Mindtree