Microsoft (MOC) Courses > MOC 2542: Advanced Data Access with Visual Studio 2005

MOC 2542: Advanced Data Access with Visual Studio 2005


MOC 2542: Advanced Data Access with Visual Studio 2005

PACKAGE INCLUDES

  • 6 CD-ROMs featuring live instructor-led classroom sessions with full audio, video and demonstration components
  • Printable courseware
  • Step-by-step hands-on-labs
  • Focused on practical solutions to real-world development problems


    • Single User CD Course
    £ 198
    Single User Online Course
    £ 158
    Multi User CD Course
    £ 396

    COURSE INTRODUCTION

    Schedule our instructor led classroom training at your convenience and never miss another lecture or fall behind. You are in complete control. We invited the Best Microsoft-Certified Trainers in the industry to help us develop the ultimate training & certification program which includes everything you will need to succeed.

    This instructor-led course 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 course also describes how to locate, edit, and transform XML by using XPath and Extensible Style sheet Language for Transformations (XSLT).

    Course Outline


    Module 1 - Minimizing and Handling Database Operation Conflicts

    Minimizing and Handling Database Operation Conflicts
    Demo - Show Example of Database Conflict
    Why Do Data Conflicts Arise?
    Optimistic
    Pessimistic
    "Last One In Wins"
    Demo - Show Effects of Locks
    Isolation Levels in SQL Server 2005
    Isolation Levels Matrix
    Using SQL Server 2005 Isolation Levels
    Using ADO.NET to Handle Conflicts
    Demo - Handle Database Concurrency Issues
    Lab Demonstration 1
    Module 1 Review

    Module 2 - Handling Large Objects

    Handling Large Objects
    Binary Large Objects
    Character Large Objects
    Large Value Data Types
    Reading Large Objects from a Database
    Demo - Read Large Objects
    Writing Large Objects to a Database
    Demo -Write Large Object to a Database
    Lab Demonstration 2
    Module 2 Review

    Module 3 - Transactional Operations

    Enhancing Database Performance
    ADO.NET Enhancements in the .NET Framework 2.0
    MARS
    Demo - How MARS Works
    Asynchronous Operations
    Demo - Show Effects of Asynchronous Operations
    Demo - Show Batch Dataset Update
    Demo - Show Bulk Data Copy
    SQL Server Provider Statistics
    Demo - Setting up a Performance Trace
    Lab Demonstration 3
    Module 3 Review

         		 

    Module 4 - Creating Managed Code Objects for SQL Server 2005

    Creating Managed Code Objects for SQL Server 2005
    .NET and SQL Server 2005
    Managed Objects
    Demo - Create/Deploy a Stored Procedure & Function to SQL Server
    The Benefits of Creating Managed Code Objects
    Importing an Existing Assembly into SQL Server 2005
    Implement Managed Code Objects in SQL Server 2005
    Demo - Create SQL Project
    Lab Demonstration 4
    Module 4 Review

    Module 5 - Querying XML by Using Xpath

    XPath Data Model
    Node Types
    Selecting XML Data Using XPathNavigator
    Demo - Use XPathNavigator to Select Data
    Editing XML Data Using XPathNavigator
    Demo - Use XPathNavigator to Edit Data
    Evaluating XPath Expressions Using XPathNavigator
    Demo - Use XPathNavigator to Evaluate Data
    Module 5 Review

    Module 6 - Transforming XML by Using XSLT Style Sheets

    Transforming XML by Using XSLT Style Sheets
    What is XSLT?
    Demo - Create and show XSLT Style Sheet
    Using an XSLT Style Sheet
    Executing an XSLT Style Sheet
    Executing an XSLT Style Sheet Sample
    Demo - Use XSLT Style Sheet
    Add Parameters
    XslCompiledTransform Object
    Using the Resolver
    XslCompiledTransform Object Cont.
    Demo - Use Parameters and XslCompiledTransform
    Extension Objects
    Create Extension
    Benefits and Drawbacks of Extension Objects
    Demo - Create and Use Extension Object
    Lab Demonstration 5
    Module 6 Review
    Course Closure
    Page Execution time is 18.563 seconds.