(<img height='1' width='1' border='0' src="http://www.googleadservices.com/pagead/conversion/1072619999/?value=1&label=Lead&script=0" />)
F1
About F1Course ScheduleOther ServicesSite MapContactHome

Programming with ADO .NET

Exchange Server
Office (inc Access)
SQL Server
Visual Studio .NET
Windows
Web Development
Visual FoxPro
Programming
Business
Knowledge Management
Certification
Learning Options
Reserve a Place
19 May Bath
27 May London
16 Jun Bath
23 Jun London
21 Jul Bath
28 Jul London
18 Aug Bath
26 Aug London
15 Sep Bath
23 Sep London
13 Oct Bath
21 Oct London
10 Nov Bath
18 Nov London
08 Dec Bath
16 Dec London
05 Jan Bath
13 Jan London
02 Feb Bath
02 Feb Bath
02 Feb Bath
10 Feb London
10 Feb London
10 Feb London
View Other Courses in Same Category

Module 1: Data-Centric Applications and ADO.NET

  • Design of Data-Centric Applications
  • ADO.NET Architecture
  • ADO.NET and XML
  • Lab: Data-Centric Applications and ADO.NET
Skills
  • 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.
Top

Module 2: Connecting to Data Sources

  • Choosing a .NET Data Provider
  • Defining a Connection
  • Managing a Connection
  • Handling Connection Exceptions
  • Connection Pooling
  • Lab: Connecting to Data Sources
Skills
  • 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.
Top

Module 3: Performing Connected Database Operations

  • 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
  • Lab: Performing Connected Database Operations
Skills
  • 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.
Top

Module 4: Building DataSets

  • 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
  • Lab: Building, Binding, Opening, and Saving DataSets
  • Lab: Manipulating DataSets.
Skills
  • 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.
Top

Module 5: Reading and Writing XML with ADO.NET

  • Creating XSD Schemas
  • Loading Schemas and Data into DataSets
  • Writing XML from a DataSet
  • Lab: Working with XML Data in ADO.NET
Skills
  • 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.
Top

Module 6: Building DataSets from Existing Data Sources

  • 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
  • Lab: Retrieving Data into a Disconnected Application
  • Lab: Retrieving and Updating Customers and Orders Data
Skills
  • 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.
Top

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

  • Building and Consuming a Web Service That Returns Data
  • Lab: Troubleshooting an ADO.NET Application.
Skills
  • Build a Web service.
  • Consume a Web service in a client application.
  • Troubleshoot errors in an ADO.NET application.
Top
.

Exams:

Price Options ex VAT:

Classroom Training
?		 Distance Learning
?		 eLearning Options
?		 Book Learning
?
£ 1050
(€1491) 		£ 674.00
(€957) 		£297.00
(€422) 		No Books Supported for Course at present

Call Free on 0800 169 1890
Print 2 Page Flyer
Last Modified 01 May 2008