|
|
|
Module 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
- Lab: Minimizing and Handling Database Operation Conflicts
Skills
- 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.
Top |
|
Module 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
- Lab: Handling Large Objects
Skills
- 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.
Top |
|
|
Module 3: Enhancing Database Performance
- ADO.NET Enhancements in the .NET Framework 2.0
- SQL Server Provider Statistics
- Lab: Enhancing Database Performance
Skills
- 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.
Top |
|
Module 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
- Lab: Creating Managed Code Objects for SQL Server 2005
Skills
- 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.
Top |
|
|
Module 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
- Lab: Querying XML by Using XPath
Skills
- 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.
Top |
|
Module 6: Transforming XML by Using XSLT Style Sheets
- What Is XSLT?
- The Process for Executing an XSLT Style Sheet
- What Are Extension Objects?
- Lab: Transforming XML by Using XSLT Style Sheets
Skills
- 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.
Top |
|
|
|
Exams:
|
|
Price Options ex VAT:
Classroom Training
? |
Distance Learning
? |
eLearning Options
? |
Book Learning
? |
£
700
(€994)
|
£
449.00
(€638)
|
- |
No Books Supported for Course at present
|
|
|
Call Free on 0800 169 1890
Print 2 Page Flyer
Last Modified 01 May 2008
|
|
