This clinic is intended for current professional database developers who have three or more years of on-the-job experience developing SQL Server database solutions in an enterprise environment.
Слушателям выдаются учебные материалы, авторизованные Microsoft.
По окончании курса слушатели получают сертификат компании Microsoft международного образца.
Session 1: 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
|
|
Session 2: Designing an Exception Handling Strategy |
| Exception Types and Their Purposes
Detecting Exceptions
Managing Exceptions
|
|
Session 3: Choosing a Cursor Strategy |
| Common Scenarios for Row-Based vs. Set-Based Operations
Selecting Appropriate Server-Side Cursors
Selecting Appropriate Client-Side Cursors
|
|
Session 4: 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
|
|
Session 5: 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
|
|
Session 6: Designing a Scalable Data Tier for Database Applications |
| Identifying the Need to Scale
Scaling Database Applications to Avoid Concurrency Contention
Scaling SQL Server Database Syst Scaling Database Applications Using a Service-Oriented Architecture
Improving Availability and Scalability by Scaling Out Front-End Systems
|
|
