Formation Optimizing an Indexing Strategy Using Microsoft® SQL Server™ 2005
In this 2-hour workshop you will learn how to apply various indexing strategies in order to enhance performance in your Microsoft® SQL Server™ 2005 Database solutions. Topics include index types, guidelines for designing indexes, and using clustered vs nonclustered indexes.Within the workshop, you will analyze bottlenecks and apply indexes to various tables in order to improve performance. As a workshop, most of the learning will be done within the lab itself.Having this experience will enable you to address performance issues that arise from poorly performing queries within your database solutions.This course will also prepare you for exam 70-442 PRO: Designing and Optimizing Data Access by Using Microsoft® SQL Server™ 2005.
Programme de la formation
| Workshop Overview | | Module Introduction | | Navigation Overview | | Lab Information | | Optimizing an Indexing Strategy | | Module Introduction | | Optimizing an Indexing Strategy | | Lesson Introduction | | Performance Optimization Model: Indexing | | Types of Indexes in Database Optimization | | Guidelines for Designing an Indexing Strategy | | Guidelines for Using Clustered Indexes | | Guidelines for Nonclustered Index Usage and Design | | How to Document an Indexing Strategy | | Self Test | | Lab: Optimizing an Indexing Strategy | | Lesson Introduction | | Scenario | | Tasks and Resources | | Launch the Lab | | Lab Review | | Workshop Summary | | Glossary | | Module Introduction |
|
Informations
| Code : |
4374 |
| Durée : |
2 heures |
Actions
|