Course Ref: 42137

Course: MS2783 Designing the Data Tier for Microsoft SQL Server 2005

Course Summary

This one-day instructor-led clinic provides students with the knowledge and skill 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

The Modules are as follows:

  • Choosing Data Access Technologies and an Object Model
  • Designing an Exception Handling Strategy
  • Choosing a Cursor Strategy
  • Designing Query Strategies Using Multiple Active Result Sets
  • Designing Caching Strategies for Database Applications
  • Designing a Scalable Data Tier for Database Applications
By the end of the day, delegates will be able to:

  • Choose data access technologies and an object model to support an organization's business needs.
  • Design an exception handling strategy.
  • Choose a cursor strategy.
  • Design query strategies using Multiple Active Result sets (MARS).
  • Design caching strategies for database applications.
  • Design a scalable data tier for database applications.

Where & When

LocationWokingham
Start Date13 Oct 08
Price (ex. VAT)£295.00
Venue Info Wokingham - Mulberry Business Park
ResidentialNo
AvailabilityFull
Duration1 or 2 days
Delivered AsVenue and on-site
Pre-course Reading
No precourse reading is specified.
Exam IncludedNo
Course Ref42137