 |
Courses & Certifications
|
 |
MS2389 Programming with Microsoft ADO.NET
|
Dates for next course: | Call 02 4969-0690 for the next course date |
| Training Format: |
Classroom |
| Price: | Call 02 4969-0690 for pricing |
Overview
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.
Prerequisites
The course assumes that students have the following skills:
- Understanding of relational database concepts: table, row, column, primary keys, foreign keys, constraints, and views
- Data query and modification experience, including experience with SELECT, INSERT, UPDATE, and DELETE commands
- Exposure to XML documents, style sheets, and schemas
- Experience with Visual Basic .NET, Visual Basic for Applications, or previous versions of Visual Basic
- Experience building user interfaces, including Web applications or Microsoft Windows applications
Course Outline
Module 1: Data-Centric Applications and ADO.NET
- Design of Data-Centric Applications
- ADO.NET Architecture
- ADO.NET and XML
Module 2: Connecting to Data Sources
- Choosing a .NET Data Provider
- Defining a Connection
- Managing a Connection
- Handling Connection Exceptions
- Connection Pooling
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
|
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
Module 5: Reading and Writing XML with ADO.NET
- Creating XSD Schemas
- Loading Schemas and Data into DataSets
- Writing XML from a DataSet
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
Module 7: Building and Consuming a Web Service That Uses ADO.NET
- Building and Consuming a Web Service That Returns Data
|
|
Forsythes IT & Training provides instructor led computer training on the Microsoft Office and Adobe range of applications.
We service Newcastle, the Hunter Valley, Lake Macquarie and the Central and Northern Coasts of New South Wales (NSW) Australia.
With our mobile training room we can provide a range of courses on-site at your premises.
|
|
|
|
