Instructor-led Classroom Learning - 2.00 Day(s)
Online Live - 4.00 Sessions
Mentored Learning - Flexible
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
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?