New Horizons Lexington KY Computer Training
New Horizons Computer Learning Center presents
 

2542 Advanced Data Access with Microsoft Visual Studio 2005 On-Site Training

This on-site training class is also available as Public Schedule Seminar.

This 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

Course Description/Agenda


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

Who Should Attend:
This workshop is intended for corporate and Independent Software Vendor (ISV) application developers who have a desire to learn more about specific technology areas in distributed application development.

At Course Completion:
After completing this workshop, 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.


Prerequisite(s) or equivalent knowledge:
2541 Core Data Access with Microsoft Visual Studio 2005
 
Outline:
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
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
Lesson 3: Enhancing Database Performance
ADO.NET Enhancements in the .NET Framework 2.0
SQL Server Provider Statistics
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
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
Lesson 6: Transforming XML by Using XSLT Style Sheets
What Is XSLT?
The Process for Executing an XSLT Style Sheet
What Are Extension Objects?

 

More Seminar Information

New Horizons Computer Learning Center
New Horizons Lexington KY Computer Training

Delivery Method

On-Site Training On-Site Training

Also Available As

Seminar Seminar

 
Add to favorites Add to favorites
Email Email this page
 

On-Site Training
Information Request Form

Please complete the form for more information and/or a quote for this on-site class.

Name:

Email

Phone:

City and State

Company:

Number of students:
(at least 10 for consideration)

When do you want to hold the
seminar?

How long would you like for the
seminar?

Additional comments to trainer:

We value your privacy!