ADO .NET Training Course


ADO.NET Training

This course will teach developers to build data-centric applications and Web services with Microsoft ADO.NET, Microsoft SQL ServerT 2000, and the Microsoft .NET Framework.

This course is designed for the professional platform developer who is responsible for designing and building data-centric, distributed applications for his or her organization. It is designed for developers who have component and Web application development skills, and who have previously built solutions by using Microsoft Visual Studio®.

Whether you have been using Microsoft's ADO or have been creating applications that access data sources, this introduction to ADO.NET development will introduce you to how the .NET framework can be used with various data sources. Besides discussing data-centric applications, connecting to data sources, performing database operations, and DataSets, this course discusses the advanced features of database related technologies and their .NET implementation. Finally, it introduces the use of XML with data sources. Following this course, you will be able to build connected applications that make the most efficient use of modern data sources in the Microsoft .NET framework.

  After completing the course, students will be able to:
Describe data-centric applications, ADO.NET architecture, and ADO.NET and XML.

n Our easy-to-use delivery format allows you to concentrate on the lesson at hand and not how to run the delivery software - saving you time and frustration. Our comprehensive course materials are delivered in an easy-to- understand format - allowing you to get the most out of your time. n

Our courses incorporate audio, video, and text training and then the total experience is reinforced with exercises and practice tests to ensure that you have really grasped the material.

This Course is available online or via DVD's:
Online Course = All items marked with are included.
DVD Study Kit = Everything! - If its marked with then its included.
For Pricing - Click Here
Live Video,
Courses =
Courses =
Online Streaming Video
(Broadband min 512k)
12 Months subscription
Featuring live instructor-led classroom-like sessions in digital video format. Multimedia-rich delivery brings experienced subject matter experts to your desktop or laptop.
Training Simulations  
DVD Courses = Delivered on DVD
Online Courses = Online Access
Interactive hands-on practice lab
Email Support  
1 Year's Technical Email Support
DVD Courses= Delivered
on DVD
Online Courses = Downloadable
Free Upgrades  
12 months of Free Upgrades.
Compatibility with:  

XP | Win 2003/8 server | Vista
Exam Simulator  
Exam Simulator for closest replication to the real exam!



Content on this page requires a newer version of Adobe Flash Player.

Get Adobe Flash player





ADO.NET - Learning Segments

Course Prerequisites
Course Overview
MODULE 1: Overview
What is ADO.NET?
Data Architectures
Connected & Disconnected Environments
Data Stores
ADO.NET Namespaces
ADO.NET File Locations
Data Retrieval & Updates
Web Resources
MODULE 2: Overview
Data Providers
Collection of Classes
Connection Class
Creating Connections
Web Resources
SQL Server Security
Dynamic Help
Connection Objects
Connection Pools
Pool Management Tools
Web Resources
MODULE 3: Overview
Command Object
Select Statement
Adding Parameters
Visual Studio .NET
Stored Procedures
Database Transactions
MODULE 4: Overview
DataReader Object
Schema Table
DataReader Object
Data Binding
Output Parameters
Multiple Statements
MODULE 5: Overview
DataSet Overview
DataSet Object Model
Data Adapter
DataSet Schemas
Fill Schemas
MODULE 6: Overview
Extending DataSets
Back & Front End Schema
Custom Expressions
Additional Constraints
Foreign Key Constraints
Setting Foreign Key Rules
Data Relations
Selecting Data
Strongly Typed DataSets
Typed DataSet Tools
MODULE 7: Overview
Updating DataSets
Tracking Updates
Row State & Data Row Version
Updating Data Sources
Data Source Update Code: Option 1
Data Source Update Code: Option 2
Updating Data Sources
Updating Errors
Detecting Updating Conflicts
Handling Updating Conflicts
Minimizing Conflicts
Minimizing Conflicts
MODULE 8: Overview
Writing XML Data
Formatting XML
Reading XML Data
Writing XML Schema
Reading XML Schema
XML Data Document
XML Data Document
MODULE 9: Overview
Code Generation: Server Explorer
Code Generation: Toolbox
Writing Code
InfoMessage Event
Data Binding
Updating Data
MODULE 10: Overview
Stateless Programming Overview
Integrated Security
Data Binding
Output Caching
MODULE 11: Overview
Web Service Architecture
XML Web Service
Returning DataSets
Passing Parameters
Web Service Data Return
Consuming Web Services
Final Comments


Full motion video

Each class is presented in full motion video allowing you to see the steps, hear the explanations, and perform the tasks which includes our interactive hands-on training simulations, students will learn from real-world scenarios taught by our expert instructor.

Instructor-Led Training

Combines both the convenience and affordability of computer-based training with the effectiveness of a traditional classroom setting. The instructors featured in our multi-media DVD's are not only certified in their area of expertise, but also have years of real world experience and are subject matter experts in their fields.


We supply a complete line of e-books to offer a complete training solution. Our courses include e-books for CompTIA, CISCO and Microsoft certifications.Supplied on DVD for DVD courses or downloadable for Online Courses.

Practice Exam Simulators

We offer exam simulators for all technical certifications. Our exam simulators are the closest replication to the real exam!

Our exam simulators creates a simulation of an actual certification exam. Under timed conditions, IntelliSage? sets up a test with 60 randomly chosen questions designed to help you get ready for the real exam. As with the Practice Exam, the Certification Simulator allows you to mark questions you cannot answer for review at the end of the test.
If you ask, IntelliSage? will show you the correct answer. IntelliSage? will also explain why it is the correct answer when you select the "Learn Now" feature. The Practice Exam is the first IntelliSage? step in getting you ready to pass your certification exams.

Hands-on Lab Simulation

Hands-on Lab Simulation is a crucial component of your IT training. Practice make perfect. Step-by-step hands-on labs with detail instructions are included to reinforce all key concepts. When you complete a topic, choose the Lab Simulation button to select the associated hands-on lab exercises. Labs allow you to reinforce concepts by performing the tasks you've just learned..

Free Upgrades

A unique benefit of the our Learning System, is that
it allows you to stay current with the ever-changing certification requirements. When a certification test changes and we produce an upgrade for the certification program, we offer our customers free upgrades on their interactive DVD's for up to 1 year from date of original purchase? absolutely free!


Online Course:£210 ex. VAT
DVD Study Kit:£210 ex. VAT
List Price:£695  
Online Library: 95% off

1yr Unlimited Online Access to 143 Courses
Save 95%

      What's included in each option?

mcse training
 ©Copyright 2010 All Rights Reserved
ADO .NET Training Course