|
Unit 1: Minimizing and Handling Database Operation Conflicts
Lessons
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
After completing this unit, students will be able to:
Explain why data conflicts arise.
Describe the isolation levels that are available in SQL Server 2005.
Describe the guidelines for using SQL Server 2005 isolation levels.
Read committed data by using locks.
Read committed data by using statement-level snapshots.
Read committed data by using transaction-level snapshots.
Handle data concurrency by using ADO.NET.
Unit 2: Handling Large Objects
Lessons
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
After completing this unit, students will be able to:
Describe binary large objects and character large objects.
Explain the process for reading large objects from a database.
Explain the process for writing large objects to a database.
Read large values from SQL Server.
Write large values to SQL Server.
Conserve resources when writing large values to SQL Server.
Unit 3: Enhancing Database Performance
Lessons
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
After completing this unit, students will be able to:
Describe the ADO.NET enhancements in Microsoft .NET Framework 2.0.
Describe the support for run-time statistics in the .NET Framework Data Provider for SQL Server.
Access multiple result sets concurrently.
Perform asynchronous data access operations.
Perform a batch update.
Perform a bulk data copy.
Unit 4: Creating Managed Code Objects for SQL Server 2005
Lessons
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)
After completing this unit, students will be able to:
Describe the benefits of creating managed code objects for SQL Server 2005.
Explain the process for importing an existing assembly into SQL Server 2005.
Explain the process for implementing managed code objects in SQL Server 2005.
Create managed stored procedures and triggers.
Create managed user-defined functions.
Create a managed aggregate.
Create a managed user-defined type.
Unit 5: Querying XML by Using XPath
Lessons
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
After completing this unit, students will be able to:
Describe the XPath data model.
Explain the process for selecting and editing XML data by using XPathNavigator.
Explain the process for evaluating XPath expressions by using XPathNavigator.
Select XML data by using XPathNavigator.
Evaluate XPath expressions by using XPathNavigator.
Create and use compiled XPath expressions.
Edit XML data by using XPathNavigator.
Unit 6: Transforming XML by Using XSLT Style Sheets
Lessons
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
After completing this unit, students will be able to:
Describe the purpose of XSLT.
Explain the process for executing an XSLT style sheet.
Describe the purpose of extension objects.
Transform an XML document by using an XSLT style sheet.
Resolve external resources during XSLT processing.
Pass parameters into an XSLT style sheet.
Create and use extension objects.
|
