M2541: Core Data Access Development with Visual Studio 2005 (Workshop)

Level:
Costs:
Total time:
Provider rating: 10Perpetual Solutions has an average rating of 10 (out of 1 reviews)
Logo Perpetual Solutions

Tip: Receive more information about the programme, starting dates & price. Or request a proposal from multiple providers for in-house training.

Overview

Your experience of this course?

Did you attend the course M2541: Core Data Access Development with Visual Studio 2005 (Workshop) at Perpetual Solutions? Help other people by submitting your review at Springest!

Springest will donate £1.- to the Edukans Foundation as a thank you for each review

 
Schedule:
Daytime
Run time:
3 Days
Location type:
Open

vat information, completion, maximum participants, and starting dateplaces are unknown for this course.

Prerequisites:

Before attending this workshop, students must:

-
Be able 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
- Be able to program an application using a .NET Framework 2.0 compliant language
Know how to make assemblies available to other applications
- Have 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

Course Description:

This three-day instructor-led workshop provides s…

Read the complete description

Description

Prerequisites:

Before attending this workshop, students must:

-
Be able 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
- Be able to program an application using a .NET Framework 2.0 compliant language
Know how to make assemblies available to other applications
- Have 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

Course Description:

This three-day instructor-led 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. The workshop also describes how to create, read, and write XML data.

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.

Elements of this syllabus are subject to change.

This course includes the following modules:

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

  • Exercise 1. Performing Data Updates within a Transaction
  • Exercise 2. Choosing an Appropriate Isolation Level for a Transaction
  • Exercise 3. Enlisting in a Distributed Transaction
  • Exercise 4. Managing Transactions in the Data Tier (if time permits)

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 DataSet.
  • 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

  • Exercise 1. Reading XML Data by Using DOM
  • Exercise 2. Writing XML Data by Using DOM

For online live training advice please visit our Learning Advice Centre on our website. Be sure to follow us on Twitter to receive special course offers, news and updates!

Reviews

There are no reviews yet. Submit your review and help other people make the right choice. As a thank you for your effort we will donate £1.- to Stichting Edukans.

More courses within this subject:

Compare 37,378 training courses in subjects like Microsoft ADO.NET

Sign up to create your own Learning Lists.

Not for humans