New Horizons Computer Learning Center
410-597-9722

2542: Advanced Data Access with Microsoft Visual Studio 2005

Course Length: 2 Days

Overview:
This two-day instructor-led workshop 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 workshop also describes how to locate, edit, and transform XML by using XPath and Extensible Style sheet Language for Transformations (XSLT).

Prerequisites:
Course 2541: Core Data Access with Microsoft Visual Studio 2005 Workshop

Course Objectives:
Upon successful completion of this course, students will be able to:

• Minimize and handle database operation conflicts
• Handle large objects
• Enhance database performance
• Create managed code objects for SQL Server 2005
• Query XML by using XPath
• Transform XML by using XSLT style sheets

Course Content

Lesson 1: Minimizing and Handling Database Operation Conflicts

• Why Do Data Conflicts Arise?
• Isolation Levels Available in SQL Server 2005
• Guidelines for Using SQL Server 2005 Isolation Levels
• Lab 1: Minimizing and Handling Database Operation Conflicts
• Exercise 1. Reading Committed Data by Using Locks
• Exercise 2. Reading Committed Data by Using Statement-Level Snapshots
• Exercise 3. Reading Committed Data by Using Transaction-Level Snapshots
• Exercise 4. Handling Data Concurrency by Using ADO.NET

Lesson 2: Handling Large Objects

• What Are Binary Large Objects and Character Large Objects?
• The Process for Reading Large Objects from a Database
• The Process for Writing Large Objects to a Database
• Lab 2: Handling Large Objects
• Exercise 1. Reading Large Values from SQL Server
• Exercise 2. Writing Large Values to SQL Server
• Exercise 3. Conserving Resources When Writing Large Values to SQL Server

Lesson 3: Enhancing Database Performance

• ADO.NET Enhancements in the .NET Framework 2.0
• SQL Server Provider Statistics
• Lab 3: Enhancing Database Performance
• Exercise 1. Accessing Multiple Result Sets Concurrently
• Exercise 2. Performing Asynchronous Data Access Operations
• Exercise 3. Performing a Batch Update
• Exercise 4. Performing a Bulk Data Copy

Lesson 4: Creating Managed Code Objects for SQL Server 2005

• The Benefits of Creating Managed Code Objects
• Demonstration: The Process for Importing an Existing Assembly into SQL Server 2005
• Demonstration: The Process for Implementing Managed Code Objects in SQL Server 2005
• Lab 4: Creating Managed Code Objects for SQL Server 2005
• Exercise 1. Creating Managed Stored Procedures and Triggers
• Exercise 2. Creating Managed User-Defined Functions
• Exercise 3. Creating a Managed Aggregate
• Exercise 4. Creating a Managed User-Defined Type
• Exercise 5. Importing Existing Assemblies into SQL Server 2005 (if time permits)

Lesson 5: Querying XML by Using XPath

• The XPath Data Model
• The Process for Selecting and Editing XML Data by Using XPathNavigator
• The Process for Evaluating XPath Expressions by Using XPathNavigator
• Lab 5: Querying XML by Using XPath
• Exercise 1. Selecting XML Data by Using XPathNavigator
• Exercise 2. Evaluating XPath Expressions by Using XPath Navigator
• Exercise 3. Creating and Using Compiled XPath Expressions
• Exercise 4. Editing XML Data by Using XPathNavigator

Lesson 6: Transforming XML by Using XSLT Style Sheets

• What Is XSLT?
• The Process for Executing an XSLT Style Sheet
• What Are Extension Objects?
• Lab 6: Transforming XML by Using XSLT Style Sheets
• Exercise 1. Transforming an XML Document by Using an XSLT Style Sheet
• Exercise 2. Resolving External Resources During XSLT Processing
• Exercise 3. Passing Parameters into an XSLT Style Sheet
• Exercise 4: Creating and Using Extension Objects

6940 Tudsbury Road, Baltimore, MD 21244
P: 410-597-9722
www.nhbaltimore.com