Search on keywords

 


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

 
Meet The Certified Cisco Instructor:

a

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 an employee of Premier Knowledge Solutions, Inc 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. point scale.

a
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