MOC-2783: Designing the Data Tier for SQL Server 2005 Training

MOC 2783: Designing the Data Tier for Microsoft SQL Server 2005Training Package Includes

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

Course Introduction

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

Keith Nicholson - SQL 2005 Trainer (MCT, MCDBA, MCSD.NET, MCSE Security, CEH, Security+) Keith Nicholson is an engaging international speaker and trainer focusing on .NET development and database technologies. A year ago, Keith completed a multi-city tour and introduced the new features and benefits of .NET 2.0. Prior to founding KSDynamics, Keith architected and created some award-winning applications using .NET and SQL Server. He is the INETA Membership Manager for user groups in Arkansas, Oklahoma and North Texas. Keith has been a Microsoft MVP for over 2 years in .NET development (C#). He enjoys sharing his enthusiasm and helps others gain a love for technology and its uses.

List of Course Features

MOC 2783: Designing the Data Tier for Microsoft SQL Server 2005Course Contents
 

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