2541 Core Data Access with Microsoft Visual Studio 2005

New Horizons Computer Learning Centers
Training overview
3 days
Next start date: Contact for info. - United States of America

Course description

This workshop provides students with the knowledge and skills to develop data-access applications by using the Microsoft .NET Framework and Microsoft Visual Studio 2005. The workshop describes how to access and update data in a database by using ADO.NET.

Course Outline

Connecting to Databases and Reading Data

  • What Is ADO.NET?
  • The Process for Connecting to a Database and Reading Data
  • What Is Connection Pooling?

Querying and Updating Databases by Using Commands

  • ADO.NET Commands
  • The Process for Passing Parameters into Commands

Performing Transactional Operations

  • What Is a Transaction?
  • The Process for Managing Local Transactions
  • The Process for Managing Distributed Transactions
  • Isolation Levels

Performing Disconnected Operations Programmatically

  • What Is the ADO.NET Disconnected Model?
  • The Process for Loading and Saving Data in a DataSet
  • What Are DataViews?

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

Performing XML Operations on Disconnected Data

  • XML Representations of DataSets
  • What Are DiffGrams?

Reading and Writing XML Data

  • The Process for Serially Reading XML Data
  • The Process for Serially Writing XML Data

Processing XML Data by Using DOM

  • What Is DOM?
  • What Are DOM Trees?
  • Types of XML Nodes in a DOM Tree

Course Objectives

After completing this workshop, 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.

Who should attend?

This workshop 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.

About New Horizons Computer Learning Centers

New Horizons Computer Learning Centers - Find Training

Premier Provider of Computer Courses and Certifications

New Horizons Computer Learning Centres provide high quality, flexible and intuitive training that is always delivered by award-winning instructors and uses the best resources available. New Horizons is the world’s largest independent IT training company, that has provided industry-leading technical training for...

Read more and show all training delivered by this supplier

New Horizons offer an extensive array of the vendor-authorized training and certifications that are in highest demand—including Microsoft, Cisco, CompTIA and VMware. They are the Worl'ds Largest IT Training provider delivering courses at more than 300 centers.

Contact info

New Horizons Computer Learning Centers

View again
Supplier Directory
Join our Supplier Directory to:
- Gain Traffic
- Get Noticed
- Showcase Your Services
- Free Listing Available