Designing Caching Strategies for Microsoft® SQL Server„¢ 2005 Database Applications(4354)


In this 1-hour premium course, you will learn about how to design a caching strategy within your Microsoft® SQL Server™ 2005 Database solutions. Topics covered include server side and client-side caching techniques as well as conflict resolution and query notifications.

Having this experience will enable the design of reliable database applications that can perform well under heavy load.

This course will also prepare you for exam 70-442 PRO: Designing and Optimizing Data Access by Using Microsoft® SQL Server™ 2005.



  • Implement caching
    • Describe types of caching
    • Identify benefits of data caching
    • Describe techniques of caching
    • Use caching techniques within a database application
  • Implement Data and Query Caching in Microsoft® SQL Server™ 2005
    • Describe how Data Caching Works
    • Use Procedure Cache and Buffer Cache
    • Maximize and Monitor Cache Utilization
  • Implementing Caching Technologies in Client-side Components
    • Use the Caching Application Block
    • Describe Microsoft® ADO.NET
    • Use the Data Access Application Block
  • Query Notifications
  • Query Notification process
  • Managing Conflicts
    • How Cached Data Can Cause Conflicts
    • Resolving Conflicts
  • Custom Caching Techniques
    • Alternate Techniques for Caching
    • Denormalization as a Caching Technique
    • Managing Dynamic User Interfaces
    • Object serialization
    • Caching Objects Locally
    • Custom Caching Strategies


User Reviews

Not yet rated. You will need to follow this course before you can write a review.

Course Info

  • Code: EL-DCS-205DA
  • Duration: 1 hours
  • Price: Call for price

Next Step

Enquire Now
Tell a Friend