Advanced Data Access with Microsoft Visual Studio 2005 (2542)

Printer-friendly version
Vendor: 
Microsoft
Subject: 
Programming
Overview: 

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

Course Contents: 

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

Prerequisites: 
  • 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.
    • Benefits: 

    After completing this workshop, students will be able 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.
    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.

    Materials Available: 
    Yes
    Duration: 
    16 hours
    For more information on Advanced Data Access with Microsoft Visual Studio 2005 (2542) please feel free to contact us online or call us at 416-513-1535.