Core Data Access with Microsoft Visual Studio 2005
(Microsoft Training Course: 2541) - 3 days - £1700 exc VAT

This course provides students with the knowledge and skills to develop data-access applications by using the Microsoft .NET Framework and Microsoft Visual Studio 2005. It is intended for corporate and Independent Software Vendor (ISV) application developers who have a desire to learn more about specific technology areas in distributed application development.

1. Connecting to Databases and Reading Data
2. Querying and Updating Databases by Using Commands
3. Performing Transactional Operations
4. Performing Disconnected Operations Programmatically
5. Performing Disconnected Operations by Using Visual Studio 2005 Wizards
6. Performing XML Operations on Disconnected Data
7. Reading and Writing XML Data
8. Processing XML Data by Using DOM

---

Supplementary Information All VS2005 exams retire by 30/6/11, Why not consider upgrading to VS2010?

---

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

---

Before attending this course, students must have the following pre-requisites:

• Ability to manage a solution environment using the Visual Studio 2005 integrated development environment IDE and tools.
• Understand the .NET Framework 2.0 and the Common Language Runtime.
• Ability to program an application using a .NET Framework 2.0 compliant language.
• Knowledge of making assemblies available to other applications.
• A good understanding of basic relational database concepts.
• Be able to use basic SQL commands.
• Have a good understanding of XML including XML declaration, elements, attributes, and namespaces.
• Be able to explain XML schema concepts.

At the end of the course, students will be able to connect to databases and read data; query and update databases by using commands; perform transactional operations; perform disconnected operations programmatically; perform disconnected operations by using Visual Studio 2005 wizards; perform XML operations on disconnected data; read and write XML data; process XML data by using the Document Object Model DOM.

All VS2005 exams retire by 30/6/11, Why not consider upgrading to VS2010?