CERTIFICATIONS

PROGRAMS

LEARN > Find a Class > Class Summary

MS2783 - Designing the Data Tier for Microsoft SQL Server 2005

If you have any questions about registering for this class, please call (877) 832-0688 Ext. 1493 or email us at getsmart@LRS.com

This clinic provides students with the knowledge and skill to design the data tier for Microsoft SQL Server 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.

Click here for a printer-friendly version of this page.

This course has not been scheduled yet. Please contact us by clicking the link below to learn about availability.

Prerequisites

Before attending this course, students must: Have experience reading user requirements and business-need documents. For example, development project vision/mission statements or business analysis reports. Have basic knowledge of the Microsoft .NET Framework, .NET concepts, and service oriented architecture (SOA). Be familiar with the tasks that application developers typically perform. Understand Transact-SQL syntax and programming logic. Be able to design a database to third normal form (3NF) and know the trade offs when backing out of the fully normalized design (denormalization) and designing for performance and business requirements in addition to being familiar with design models, such as Star and Snowflake schemas. Have basic monitoring and troubleshooting skills. Specifically, how to use SQL Profiler and dynamic management views. Have basic knowledge of the operating system and platform. That is, how the operating system integrates with the database, what th

Detailed Class Syllabus

Choosing Data Access Technologies and an Object Model

Introduction to Data Access Technologies

Choosing Technologies for Accessing Data

Building a Data Access Layer

Designing Data Access from SQL Common Language Runtime (CLR) Objects

Available Data Object Models for Administering SQL Server

Designing an Exception Handling Strategy

Exception Types and Their Purposes

Detecting Exceptions

Managing Exceptions

Choosing a Cursor Strategy

Common Scenarios for Row-based vs. Set-based Operations

Selecting Appropriate Server-side Cursors

Selecting Appropriate Client-side Cursors

Designing Query Strategies Using Multiple Active Result Sets

Introduction to MARS

Designing Query Strategies for Multiple Reads

Designing Query Strategies for Mixing Reads and Writes in the Same Connection

Concurrency Considerations When Using MARS

Designing Caching Strategies for Database Applications

Why Caching Is Important

Data and Query Caching in SQL Server 2005

Using Caching Technologies Outside of SQL Server

Custom Caching Techniques

Designing a Scalable Data Tier for Database Applications

Identifying the Need to Scale

Scaling Database Applications to Avoid Concurrency Contention

Scaling SQL Server Database Systems

Scaling Database Applications Using a Service-Oriented Architecture

Improving Availability and Scalability by Scaling Out Front-End Systems