Advanced Data Access with Microsoft Visual Studio 2005

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

Pre-Requisites

Before attending this course, students must:

• Have attended or studied Workshop 2541, Core Data Access with Microsoft Visual Studio 2005, or possess equivalent knowledge and skills.
• Know how to use delegates.
• Be able to use database stored procedures, triggers, and aggregates.
• Be able to explain XPath concepts and basic syntax.
• Be able to explain XSLT style sheet concepts.

Outcomes

After completing this course, students will gain the skills to:

• Minimize and handle database operation conflicts.
• Handle large objects.
• Enhance database performance.
• Create managed code objects for SQL Server 2005.
• Query XML by using XPath.
• Transform XML by using XSLT style sheets.

---

User Reviews

Not yet rated. You will need to follow this course before you can write a review.