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.

ADO.NET - Learning Segments

INTRODUCTION

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

ADO vs ADO.NET

Web Resources

Review

MODULE 2: Overview

Data Providers

Collection of Classes

Connection Class

Creating Connections

Web Resources

SQL Server Security

Dynamic Help

Connection Objects

Exceptions

Connection Pools

Pool Management Tools

Web Resources

Review

MODULE 3: Overview

Command Object

ExecuteScalar

Select Statement

ExecuteNonQuery

ExecuteReader

ExecueXmlReader

Adding Parameters

Visual Studio .NET

Stored Procedures

Database Transactions

Review

MODULE 4: Overview

DataReader Object

Schema Table

DataReader Object

Data Binding

Output Parameters

Multiple Statements

Review

MODULE 5: Overview

DataSet Overview

DataSet Object Model

DataSet

Data Adapter

DataAdapter

DataSet Schemas

Fill Schemas

Review

MODULE 6: Overview

Extending DataSets

Back & Front End Schema

Custom Expressions

Additional Constraints

Foreign Key Constraints

Setting Foreign Key Rules

Data Relations

Selecting Data

DataView

Strongly Typed DataSets

Typed DataSet Tools

Review

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

Review

MODULE 8: Overview

Writing XML Data

Formatting XML

Reading XML Data

Writing XML Schema

Reading XML Schema

XML Data Document

Serialization

Review

MODULE 9: Overview

Code Generation: Server Explorer

Code Generation: Toolbox

Writing Code

InfoMessage Event

Data Binding

DataGrid

Updating Data

Resources

Review

MODULE 10: Overview

Stateless Programming Overview

Integrated Security

Data Binding

DataGrid

DataView

Output Caching

Caching

Resources

Review

MODULE 11: Overview

Web Service Architecture

XML Web Service

Returning DataSets

Passing Parameters

Web Service Data Return

Consuming Web Services

Resources

Review

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.

	E-BOOKS (PDF) 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!