|
Unit 1: Minimizing and Handling Database Operation Conflicts
This unit describes how to minimize data access conflicts, and how to handle
these conflicts when they occur. It describes how to implement optimistic
concurrency in the ADO.NET disconnected model, and how to implement optimistic
concurrency by using the various isolation levels available in SQL Server
2005.
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
This unit describes how to read and write large values efficiently to a SQL
Server database. It describes how to read large binary values and large text
values by using SequentialAccess for a SqlDataReader. It also describes how to
write large binary values and large text values, and how to conserve resources
when writing large values.
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
This unit describes how to enhance database performance by using new features
available in ADO.NET 2.0. The unit describes how to perform asynchronous data
operations, create multiple active result sets, perform batch updates, and
perform bulk copies.
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
This unit describes how to create database objects for SQL Server 2005 in a
.NET Framework programming language. It describes how to create stored
procedures, triggers, user-defined functions, aggregates, and user-defined types
in managed code. Additionally, it describes how to deploy an assembly that
contains managed objects into SQL Server 2005, and how to declare database
objects to reference the managed objects.
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
This unit describes how to use XPath in a .NET Framework application. It
describes how to create an XPathNavigator object on an XML document, and how to
locate content and evaluate expressions by using the XPathNavigator object.
Additionally, it describes how to edit XML data by using the XPathNavigator
object.
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
This unit describes how to transform XML documents in a .NET Framework
application. It introduces how to load an XSLT style sheet in an application,
and how to execute the style sheet to transform an XML document. The unit also
describes how to pass parameters into a style sheet, and how to create and use
extension objects.
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. |
|
