Workshop Information

Workshop CodeMS2542 (MOC2542) (M2542)
Fee£645 (Exclusive of VAT)
SaveMCTS .NET CertSaver(s): Foundation | Windows | Web | Distributed
Alternative SavingseLearning CertSaver(s): Foundation | Windows | Web | Distributed
DurationTwo Days
Delivery FormatInstructor-Led
Scheduled Dates:
Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
- - 24 - TBA - 14 - TBA - -

Introduction

This two-day instructor-led workshop provides students with the knowledge and skills needed to use advanced data access features and techniques in the Microsoft .NET Framework and Microsoft Visual Studio 2005. The workshop describes how to access data and how to implement database functionality by using Microsoft ADO.NET 2.0 and Microsoft SQL Server 2005. The workshop also describes how to locate, edit, and transform XML by using XPath and Extensible Style sheet Language for Transformations (XSLT).

Audience

This workshop is intended for corporate and Independent Software Vendor (ISV) application developers who have a desire to learn more about specific technology areas in distributed application development.

Completion

After completing this workshop, students will be able to:

Prerequisites

Before attending this workshop, students must:

Examinations

This course will help the learner to prepare for:

Materials

The student kit includes a comprehensive workbook and other necessary materials for this class.

Workshop Outline

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

Lab 1: Minimizing and Handling Database Operation Conflicts

After completing this unit, students will be able to:

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

Lab 2: Handling Large Objects

After completing this unit, students will be able to:

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

Lab 3: Enhancing Database Performance

After completing this unit, students will be able to:

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

Lab 4: Creating Managed Code Objects for SQL Server 2005

After completing this unit, students will be able to:

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

Lab 5: Querying XML by Using XPath

After completing this unit, students will be able to:

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

Lab 6: Transforming XML by Using XSLT Style Sheets

After completing this unit, students will be able to: