Advanced Data Access with Microsoft Visual Studio 2005 Training

Advanced Data Access with Visual Studio 2005 Training Package Includes

• 6 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 needed to use advanced data access features and techniques in the Microsoft .NET Framework and Microsoft Visual Studio 2005. The workshop describes how to access data and how to implement database functionality by using Microsoft ADO.NET 2.0 and Microsoft SQL Server 2005. The course also describes how to locate, edit, and transform XML by using XPath and Extensible Style sheet Language for Transformations (XSLT).
 

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

Advanced Data Access with Visual Studio 2005 Course Contents
 

Module 1 - Minimizing and Handling Database Operation Conflicts

Minimizing and Handling Database Operation Conflicts
Demo - Show Example of Database Conflict
Why Do Data Conflicts Arise?
Optimistic
Pessimistic
"Last One In Wins"
Demo - Show Effects of Locks
Isolation Levels in SQL Server 2005
Isolation Levels Matrix
Using SQL Server 2005 Isolation Levels
Using ADO.NET to Handle Conflicts
Demo - Handle Database Concurrency Issues
Lab Demonstration 1
Module 1 Review

Module 2 - Handling Large Objects

Handling Large Objects
Binary Large Objects
Character Large Objects
Large Value Data Types
Reading Large Objects from a Database
Demo - Read Large Objects
Writing Large Objects to a Database
Demo -Write Large Object to a Database
Lab Demonstration 2
Module 2 Review

Module 3 - Transactional Operations

Enhancing Database Performance
ADO.NET Enhancements in the .NET Framework 2.0
MARS
Demo - How MARS Works
Asynchronous Operations
Demo - Show Effects of Asynchronous Operations
Demo - Show Batch Dataset Update
Demo - Show Bulk Data Copy
SQL Server Provider Statistics
Demo - Setting up a Performance Trace
Lab Demonstration 3
Module 3 Review

Module 4 - Creating Managed Code Objects for SQL Server 2005

Creating Managed Code Objects for SQL Server 2005
.NET and SQL Server 2005
Managed Objects
Demo - Create/Deploy a Stored Procedure & Function to SQL Server
The Benefits of Creating Managed Code Objects
Importing an Existing Assembly into SQL Server 2005
Implement Managed Code Objects in SQL Server 2005
Demo - Create SQL Project
Lab Demonstration 4
Module 4 Review

Module 5 - Querying XML by Using Xpath

XPath Data Model
Node Types
Selecting XML Data Using XPathNavigator
Demo - Use XPathNavigator to Select Data
Editing XML Data Using XPathNavigator
Demo - Use XPathNavigator to Edit Data
Evaluating XPath Expressions Using XPathNavigator
Demo - Use XPathNavigator to Evaluate Data
Module 5 Review

Module 6 - Transforming XML by Using XSLT Style Sheets

Transforming XML by Using XSLT Style Sheets
What is XSLT?
Demo - Create and show XSLT Style Sheet
Using an XSLT Style Sheet
Executing an XSLT Style Sheet
Executing an XSLT Style Sheet Sample
Demo - Use XSLT Style Sheet
Add Parameters
XslCompiledTransform Object
Using the Resolver
XslCompiledTransform Object Cont.
Demo - Use Parameters and XslCompiledTransform
Extension Objects
Create Extension
Benefits and Drawbacks of Extension Objects
Demo - Create and Use Extension Object
Lab Demonstration 5
Module 6 Review
Course Closure