Компьютерная Академия СофтДжойс Компьютерная Академия СофтДжойс Компьютерная Академия СофтДжойс

#2783 Designing the Data Tier for Microsoft SQL Server 2005

Академия -> Курсы -> Базы данных ->#2783 Designing the Data Tier for Microsoft SQL Server 2005

Описание курса

Записаться на курс
Продолжительность: 1 дн.
Стоимость: 5 000 р.

Назначение курса

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

Академия -> Курсы -> Базы данных ->#2783 Designing the Data Tier for Microsoft SQL Server 2005

  
Компьютерная Академия СофтДжойс
   Ваш e-mail: 
Компьютерная Академия СофтДжойс
 
группа вКонтакте Яндекс.Метрика