|
|
|
Module 1: Connecting to Databases and Reading Data
- What Is ADO.NET?
- The Process for Connecting to a Database and Reading Data
- What Is Connection Pooling?
- Lab: Connecting to Databases and Reading Data
Skills
- Describe the key features of ADO.NET.
- Explain the process for connecting to a database and reading data from a database.
- Describe the benefits of connection pooling.
- Connect to a database.
- Save a connection string securely in an application configuration file.
- Retrieve data from a database.
- Handle connection events and exceptions.
Top |
|
Module 2: Querying and Updating Databases by Using Commands
- ADO.NET Commands
- The Process for Passing Parameters into Commands
- Lab: Querying and Updating Databases by Using Commands
Skills
- List the different types of ADO.NET commands.
- Explain the process for creating and executing parameterized commands.
- Create and run query commands.
- Create and run parameterized commands.
- Create and run update commands.
Top |
|
|
Module 3: Performing Transactional Operations
- What Is a Transaction?
- The Process for Managing Local Transactions
- The Process for Managing Distributed Transactions
- Isolation Levels
- Lab: Performing Transactional Operations
Skills
- Describe the concept of transactional operations.
- Explain the process for managing a local transaction.
- Explain the process for managing a distributed transaction.
- Describe the effect of setting the isolation level for a transaction.
- Perform data updates within a transaction.
- Choose an appropriate isolation level for a transaction.
- Enlist in a distributed transaction.
Top |
|
Module 4: Performing Disconnected Operations Programmatically
- What Is the ADO.NET Disconnected Model?
- The Process for Loading and Saving Data in a DataSet
- What Are DataViews?
- Lab: Performing Disconnected Operations Programmatically
Skills
- Describe the ADO.NET disconnected data model.
- Explain the process for loading and saving data in a DataSet.
- Describe how to use DataViews to provide a view on data.
- Create a DataSet programmatically.
- Populate and save a DataSet.
- Add, modify, and delete data in a DataSet.
- Merge DataSets.
Top |
|
|
Module 5: Performing Disconnected Operations by Using Visual Studio 2005 Wizards
- Comparing Untyped DataSets with Typed DataSets
- What Are Table Adapters?
- Demonstration: Creating a Typed DataSet by Using Visual Studio 2005 Wizards
- Lab: Performing Disconnected Operations by Using Visual Studio 2005 Wizards
Skills
- Explain the differences between untyped DataSets and typed DataSets.
- Explain how table adapters work in conjunction with data tables in a typed DataSet.
- Describe the process for creating a typed DataSet by using Visual Studio 2005 Wizards.
- Create a typed DataSet by using the DataSet Designer.
- Load, display, and save data in a typed DataSet.
- Add code to a typed DataSet.
- Create a typed DataSet by using the Data Source Configuration Wizard.
Top |
|
Module 6: Performing XML Operations on Disconnected Data
- XML Representations of DataSets
- What Are DiffGrams?
- Lab: Performing XML Operations on Disconnected Data
Skills
- Describe scenarios in which you can represent a DataSet as XML data.
- Explain how a DiffGram retains information about modifications to a DataSet.
- Save a DataSet as XML data.
- Load a DataSet from XML.
- Save and load DataSet schema information.
Top |
|
|
Module 7: Reading and Writing XML Data
- The Process for Serially Reading XML Data
- The Process for Serially Writing XML Data
- Lab: Reading and Writing XML Data
Skills
- Describe the process for serially reading XML data.
- Describe the process for serially writing XML data.
- Write XML data by using XmlWriter.
- Read XML data by using XmlReader.
Top |
|
Module 8: Processing XML Data by Using DOM
- What Is DOM?
- What Are DOM Trees?
- Types of XML Nodes in a DOM Tree
- Lab: Processing XML Data by Using DOM
Skills
- Explain what DOM is and describe how to process XML data in memory by using DOM.
- Explain what a DOM tree is and describe how to represent XML documents as a DOM tree.
- List the types of nodes in a DOM tree.
- Read XML data by using DOM.
- Modify XML data by using DOM.
Top |
|
|
|
Exams:
-
There are no exams directly associated with this course
|
|
Price Options ex VAT:
Classroom Training
? |
Distance Learning
? |
eLearning Options
? |
Book Learning
? |
£
1050
(€1614)
|
£
674.00
(€1036)
|
- |
No Books Supported for Course at present
|
|
|
Call Free on 0800 169 1890
Print 2 Page Flyer
Last Modified 13 March 2006
|
|
