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

#2784 Tuning and Optimizing Queries using Microsoft SQL Server 2005

Академия -> Курсы -> Базы данных ->#2784 Tuning and Optimizing Queries using Microsoft SQL Server 2005

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

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

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

This course 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 международного образца.

Программа курса

Unit 1: Measuring Database Performance

Importance of Benchmarking

Key Measures for Query Performance: Sysmon

Key Measures for Query Performance: Profiler

Guidelines for Identifying Locking and Blocking

Unit 2: Optimizing Physical Database Design

Performance Optimization Model

Schema Optimization Strategy: Keys

Schema Optimization Strategy: Responsible Denormalization

Schema Optimization Strategy: Generalization

Schema Optimization Strategy: Generalization

Unit 3: Optimizing Queries for Performance

Performance Optimization Model: Queries

What Is Query Logical Flow?

Considerations for Using Subqueries

Guidelines for Building Efficient Queries

Unit 4: Refactoring Cursors into Queries

Performance Optimization Model: Query-Set-based solutions • Five Steps to Building a Cursor • Strategies for Refactoring Cursors

Unit 5: Optimizing an Indexing Strategy

Optimizing an Indexing Strategy

Performance Optimization Model: Indexes • Considerations for Using Indexes • Best Uses of the Clustered Index • Best Practices for Non-Clustered Index Design • How to Document an Indexing Strategy

Unit 6: Managing Concurrency

Performance Optimization Model: Locking and Blocking • Multimedia - "How to Use Efficient Queries to Reduce Locking and Blocking" • Strategies to Reduce Locking and Blocking

Академия -> Курсы -> Базы данных ->#2784 Tuning and Optimizing Queries using Microsoft SQL Server 2005

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