Core Data Access with Microsoft Visual Studio 2005 Training

Core Data Access with Visual Studio 2005 Training Package Includes

• 8 CD-ROMs featuring live instructor-led classroom sessions with full audio, video and demonstration components
• Printable courseware
• Step-by-step hands-on-labs
• Focused on practical solutions to real-world development problems

Course Introduction

Schedule our instructor led classroom training at your convenience and never miss another lecture or fall behind. You are in complete control. We invited the Best Microsoft-Certified Trainers in the industry to help us develop the ultimate training & certification program which includes everything you will need to succeed.

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

PRESENTER - Jeff Cook Jeff Cook - MCT, MCSD, MCAD, MCP, A+ and MCDBA. He has been a Microsoft Certified Trainer for 6 years and has been in the training industry for 9 years. Also, he has developed mid-level and Enterprise level applications allowing him to implement a large amount of "real world" experience into his training. Jeff has been a prinicipal instructor for numerous training organizations since June 1998 with over 1,400 days of teaching experience and an average student survey score of 9.62 on a 10 point scale

List of Course Features

Core Data Access with Visual Studio 2005 Course Contents
 

Module 1 - Connecting to Databases and Reading Data

ADO.Net
Connect and Read Data
Creating a Connection
Demo - Creating and Using Connections/Commands
Connection Events
Connection Exceptions
Connection Pooling
Pool Settings
Demo - Connection Pooling
Module 1 Review

Module 2 - Querying and Updating Databases

ADO.Net Commands
Command Properties
Command Methods
Demo - Create Commands
Bind Data to Control
Demo - Binding Commands to Controls
Pass Parameters to Command
Parameter Properties
Demo - Execute a Command with Parameters
Server Explorer
Demo - Using Server Explorer
Module 2 Review

Module 3 - Transactional Operations

What is a Transaction?
Transaction Support
Transaction Characteristics
Managing Local Transactions
Local Transaction Example
Demo - Local Transaction
Managing Distributed Transactions
Create Transaction
Demo - Use Distributed Transaction
Isolation
Isolation Levels
Isolation Matrix
Demo - Show Effects of Isolation Levels
Lab Demonstration 1
Module 3 Review

Module 4 - Disconnected Operations

ADO.NET Disconnected Model
Create DataSet Model
Demo - Create a Dataset
Special Columns
Constraints and Relations
Demo - Add Special (Nondata) Columns
DataSet Relations
Demo - Create Dataset Relation
Demo - Use Relation to Access Child Records
Data Adapter
Loading and Saving Data in a DataSet
Data Adapter Properties
Demo - Create and Use Data Adapter
Data Views
Data View Properties
Demo - Create and Use Data view
Module 4 Review

Module 5 - Performing Disconnected Operations by Using Visual Studio 2005 Wizards

Disconnected Datasets
Untyped vs. Typed Datasets
Tables in Typed Dataset
Demo - Creating a Dataset and Datatable
Retrieve Data from a DataTable
DataTable Methods
DataTable Properties
Demo - Work with Datatable's
Table Adapters
Demo - Create Table adapter
Lab Demonstration 2
Module 5 Review

Module 6 - XML Operations on Disconnected Data

XML and ADO.Net
Work with XML and DataSets
Demo - Load a Dataset from XML
Demo - Write XML from Dataset
Diff Gram
Demo - Show Results of Diff gram
Module 6 Review

Module 7 - Reading and Writing XML Data

Serially Reading XML Data
Create XML Reader
Sample XML Reader
Demo - Create and Use XML reader
Serially Writing XML Data
Create XML Writer
Sample XML writer
Demo - Create and Use XML writer
Module 7 Review

Module 8 - Processing XML Data by Using DOM

What Is DOM?
Load an XML Document
Demo - Create and Load XML Dom Object
What Are DOM Trees?
Dom Tree
XML Nodes in a DOM Tree
XML Collection Classes
Demo - Use XML Dom Object by Navigating Nodes
Lab Demonstration 3
Module 8 Review