Programming with Microsoft ADO.NET Training Course


Microsoft Official Curriculum Course Number: 2389
Printer Friendly Printer Friendly

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

Course Completion Skills:
  • Describe data-centric applications, ADO.NET architecture, and ADO.NET and XML. 
  • Connect to SQL Server and other data sources. 
  • Perform connected database operations including executing SELECT commands, database definition commands, dynamic SQL commands, and commands that return data from a SQL Server database in XML. 
  • Build a DataSet schema, populate it with data, and modify the data programmatically. 
  • Build a DataSet from an existing data source. 
  • Use XML techniques while working with DataSets, including mapping tables and columns, creating XSD schemas, building strongly typed DataSets, and interacting with XMLDataDocuments. 
  • Build a Web service that uses ADO.NET to query and update a data source. 
  • Troubleshoot errors within an ADO.NET application. 
Module 1 Data-Centric Applications and ADO.NET 
Take a closer look: Download Sample Module 1 (Portable Document Format, 1.12 MB).

The following topics are covered in this module:
  • Design of Data-Centric Applications
  • ADO.NET Architecture
  • ADO.NET and XML
Labs
  • Data-Centric Applications and ADO.NET 
After Completing This Goal, Students will be Able To
  • Give examples of storage options. 
  • Diagram the architecture of data-centric applications. 
  • Choose a connected, disconnected, or mixed environment based on application requirements. 
  • Use the System.Data namespaces in applications. 
  • Diagram the ADO.NET object model. 
  • Analyze typical business scenarios. 
  • Explain how to use ADO.NET with XML. 

Module 2 Connecting to Data Sources 

The following topics are covered in this module:
  • Choosing a .NET Data Provider
  • Defining a Connection
  • Managing a Connection
  • Handling Connection Exceptions
  • Connection Pooling
Labs
  • Connecting to Data Sources 
After Completing This Goal, Students will be Able To
  • Choose a .NET data provider. 
  • Connect to SQL Server. 
  • Connect to OLE DB data sources. 
  • Manage a connection. 
  • Handle common connection exceptions. 
  • Implement and control connection pooling. 

Module 3 Performing Connected Database Operations 

The following topics are covered in this module:
  • Working in a Connected Environment
  • Building Command Objects
  • Executing Commands That Return a Single Value
  • Executing Commands That Return Rows
  • Executing Commands That Do Not Return Rows
  • Using Transactions
Labs
  • Performing Connected Database Operations 
After Completing This Goal, Students will be Able To
  • Build a command object. 
  • Execute a command that returns a single value. 
  • Execute a command that returns a set of rows, and process the result. 
  • Execute a command that defines database structure and permissions by using the data definition language (DDL) and data control language (DCL). 
  • Execute a command that modifies data. 
  • Use transactions. 

Module 4 Building DataSets 

The following topics are covered in this module:
  • Working in a Disconnected Environment
  • Building DataSets and DataTables
  • Binding and Saving a DataSet
  • Defining Data Relationships
  • Modifying Data in a DataTable
  • Sorting and Filtering
Labs
  • Building, Binding, Opening, and Saving DataSets 
  • Manipulating DataSets 
After Completing This Goal, Students will be Able To
  • Describe the disconnected environment. 
  • Build a DataSet and a DataTable. 
  • Bind a DataSet to a DataGrid. 
  • Open and save a DataSet. 
  • Define a data relationship. 
  • Modify data in a DataTable. 
  • Find and select rows in a DataTable. 
  • Sort and filter a DataTable by using a DataView. 

Module 5 Reading and Writing XML with ADO.NET 

The following topics are covered in this module:
  • Creating XSD Schemas
  • Loading Schemas and Data into DataSets
  • Writing XML from a DataSet
Labs
  • Working with XML Data in ADO.NET 
After Completing This Goal, Students will be Able To
  • Generate an XSD schema from a DataSet by using graphical tools. 
  • Save a DataSet structure to an XSD schema file. 
  • Create and populate a DataSet from an XSD schema and XML data. 
  • Save DataSet data as XML. 
  • Write and load changes by using a DiffGram. 

Module 6 Building DataSets from Existing Data Sources 

The following topics are covered in this module:
  • Configuring a DataAdapter to Retrieve Information
  • Populating a DataSet Using a DataAdapter
  • Configuring a DataAdapter to Update the Underlying Data Source
  • Persisting Changes to a Data Source
  • How to Handle Conflicts
Labs
  • Retrieving Data into a Disconnected Application 
  • Retrieving and Updating Customers and Orders Data 
After Completing This Goal, Students will be Able To
  • Configure a DataAdapter to retrieve information. 
  • Populate a DataSet by using a DataAdapter. 
  • Configure a DataAdapter to modify information. 
  • Persist data changes to a data source. 
  • Manage data conflicts. 

Module 7 Building and Consuming a Web Service That Uses ADO.NET 

The following topic is covered in this module:
  • Building and Consuming a Web Service That Returns Data
Labs
  • Troubleshooting an ADO.NET Application 
After Completing This Goal, Students will be Able To
  • Build a Web service. 
  • Consume a Web service in a client application. 
  • Troubleshoot errors in an ADO.NET application.

Current User's Login:


Fill out the information as a first time user:
Name:
(First/Last)
 
Email:
(UserName)
Confirm Email:
Company:
(if applicable)
Title:
Address 1:
Address 2:
City:
State/Province:
Postal Code:
Country:
Phone:
Discount Code:
Comments:
To Redeem SATV vouchers please have your voucher redemption number ready


Live Instructor-led Programming with Microsoft ADO.NET Training Dates

SATV Eligible
Filter By...
Providers:       Location:      
Date Range:  
 to 
Provider Location Date Type Duration Price 0 course(s)
  << Prev  Next >> 

Online Self-Paced Programming with Microsoft ADO.NET Training Options

SATV Eligible
No online results

Request Training Assistance

Please complete the form below and a TrainUp.com support specialist will send you information on the course you've selected. Our staff typically responds to your requests within 30 minutes or less. You can also reach us toll-free at 1-866-540-9677

Request Training Assistance

Please complete the form below and a TrainUp.com support specialist will send you information on the course you've selected. Our staff typically responds to your requests within 30 minutes or less. You can also reach us toll-free at 1-866-540-9677

//