M2389 - Programming with ADO.NET - 3 days
[ Course Schedule ] Module 1: Data-Centric Applications and ADO.NET
The following topics are covered in this module:
- Design of Data-Centric Applications
- ADO.NET Architecture
- ADO.NET and XML
After completing this module, 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.
Lab 1.1: Data-Centric Applications and ADO.NET
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
After completing this module, 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.
Lab 2.1: Connecting to Data Sources
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
After completing this module, 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.
Lab 3.1: Performing Connected Database Operations
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
After completing this module, 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.
Lab 4.1: Building, Binding, Opening, and Saving DataSets
Lab 4.2: Manipulating DataSets
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
Contact the training coordinator for pricing and details at 613-563-NOVA (6682)
Ext:267 0r training@novaknowledge.com
Nova Networks can also customize this course to topics of your choice which will reduce the course cost.
Copyright Statement
This site is Copyright © 2007 Nova Networks Inc.
Reproduction of any part of this site for personal or commercial
purposes without permission is strictly prohibited. The information
at this site may be downloaded onto a disk or printed for your personal
use provided that you include this copyright notice on each copy and
that you make no alterations to any of the pages and do not use any of
the information in any other work or publication whatsoever whether the
publication is paper based or electronic. No part of the information may be
distributed or copied for any commercial purpose.
|
