SQL Server 2005 > MOC 2783: Designing the Data Tier for SQL Server 2005

MOC 2783: Designing the Data Tier for SQL Server 2005


MOC 2783: Designing the Data Tier for SQL Server 2005

PACKAGE INCLUDES

  • 6 CD-ROMs Featuring live instructor-led classroom sessions with full audio, video and demonstration components
  • Printable courseware
  • Focused on practical solutions to real-world development problems
  • Free 1 Year Upgrade Policy


    • Single User CD Course
    £ 98
    Single User Online Course
    £ 78
    Multi User CD Course
    £ 196

    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 have invited the Best Microsoft Trainers in the industry to help us develop the ultimate training and certification program which includes everything you will need to fully prepare for the Microsoft certification exams.

    his one-day instructor-led clinic provides students with the knowledge and skills to design the data tier for Microsoft SQL ServerT 2005. The clinic focuses on teaching database developers working in enterprise environments to understand and decide how application developers are going to access and consume their data. This is a major failure point of database solutions today.

    Course Outline


    Module 1 - Accessing Data with SQL Server 2005

    Accessing Data Over The Years
    Reaching The Server
    MDAC vs. SQLNCLI
    Demo - SQLNCLI
    ADO.NET SqlClient
    Native XML Web Services
    Remote Data Calls
    Data Access Layers
    Data Pooling
    Demo - Connection Pooling
    CLR in SQL
    SQLNCLI Objects
    Managing SQL Server Objects
    Module 1 Review

    Module 2 - Exception Handling

    Exceptions, Bugs, Defects
    Severity Levels
    Patterns to Creating Exceptions
    How to CATCH the Exception
    Deadlocks
    What Is Done With Errors?
    Demo - Recognizing and Dealing with Errors
    Even If Code is Good…
    Module 2 Review

    Module 3 - Cursors and Sets

    Cursors Have Their Place….
    … Yet, Not Usually in SQL Server
    So, Why Do We Create Them?
    Thoughts on Refactoring
    A Good Use for Pivots
    CTE’s Make Life Easier
    Server Side Cursors
    Client Side Cursors
    Demo - Data Connection
    Module 3 Review

         		 

    Module 4 - Multiple Active Result Sets

    Destination - MARS
    MARS Depends on Client Libraries
    Snapshot Isolation in MARS
    System Catalog Views
    Demo - Snapshot Isolation
    Interleaving
    Data Manipulation Practices With MARS
    Lessons on MARS
    Module 4 Review

    Module 5 - Store Your Cache for Databases Applications

    Demo - Cache
    So Much Cache! Where to Begin?
    Balance the Budget
    DataSet Benefits
    Denormalization is Not a Bad Word
    Let Someone Else Hold Your Cache
    Persist Data at Client
    Module 5 Review

    Module 6 - Serve Several Requests with a Scalable Architecture

    High Availability vs. Scalability
    Scalability Up or Out
    It’s All About Your Attitude
    Spreading the Databases
    Partition Tables & Indexes
    Distributed Data Options
    Not All Requests Are Alike
    Demo - Set Operations
    Demo - External Data
    Designing the Middle Tier
    Component Services
    Service Oriented Architecture
    Bypass the Physical Middle Man
    Demo - CLR
    Scaling Out Application Servers
    Module 6 Review

    Course Closure
    Page Execution time is 18.735 seconds.