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 |
|
