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