Microsoft ADO.NET: ADO.NET for VB.NET

Course Overview

The ADO.NET for VB Developers training course provides a thorough, detailed and structured walkthrough of ADO.NET concepts

CourseMonster only uses quality Microsoft training suppliers who have been through our rigorous standards to ensure that you receive the best quality training available.

Related Courses

• Microsoft ADO.NET: Effective ADO.NET for developers
• Microsoft ADO.NET: ADO.NET for C#
• Microsoft ADO.NET Entity Framework 4.0: Entity Framework 4.0 with Data Services
• Microsoft ADO.NET ENtity Framework 4.0: Workshop ADO.NET Entity Framework 4.0

Audience

ADO.NET for VB Developers is useful for .NET developers or architects developing database applications.

Prerequisites

• Experience with developing VB.NET applications

Course Outline

Introducing ADO.NET

• What Is ADO.NET?
• Why ADO.NET?
• Major Components of ADO.NET
• Extensions to ADO.NET
• Connecting to External Data

Building Tables of Data

• Implementing Tables
• Adding Data Columns
• Dataset Designer

Storing Data in Memory

• Adding Data
• Examining and Changing Data
• Removing Data
• Batch Processing
• Validating Changes

Accessing the Right Data Values

• Querying and Sorting Data
• Using Expression Columns

Bringing Related Data Together

• Collecting Tables into Sets
• Establishing Relationships Between Tables
• Defining Table Constraints

Turning Data into Information

• Aggregating Data
• Setting Up Indexed Views

Saving and Restoring Data

• Serializing DataSet and DataTable
• Objects
• Guiding XML Generation

Establishing External Connections

• Using Connection Strings
• Understanding Data Providers
• Connecting to SQL Server via a Data Provider

Querying Databases

• Processing SQL Queries
• Returning Query Results

Adding Standards to Queries

• Developing Parameterized Queries
• Using Parameters in Stored Procedures

Making External Data Available Locally

• Understanding Data Adapters
• Moving Data from Source to Memory
• Moving Data from Memory to Source
• Table and Column Mapping

Guaranteeing Data Integrity

• Transactions and Concurrency
• Using Local Transactions
• Using Distributed Transactions

Binding Data with ADO.NET

• Binding Data in Windows Forms
• Binding Data in WPF
• Binding Data in ASP.NET

Providing RESTful Services with WCF Data Services

• Getting to Know the Service Layers
• Setting Up a Data Service
• Accessing a Data Service using REST