| | Tuning And Optimizing Queries Using Microsoft SQL Server 2005 (2784) |
|
|
Imparte
|
New Horizons Barcelona
|
 Imprimir |
|
|
Precio
|
Gratuito
|
 Enviar |
|
|
Fechas
|
Convocatoria Continua
|
|
|
Lugar
|
Se imparte en
(Barcelona).
Dirección :
C/ Luca, 1.
08022
|
|
|
Duración
|
12 Horas
|
|
|
Tipo de curso
|
Presencial en (Barcelona)
|
|
 |
|
|
|
|
|
|
|
|
|
Objetivos:
|
This course provides database developers working in enterprise environments using Microsoft SQL Server 2005 the knowledge and skills to evaluate and improve queries and query response times. The course focuses on systematic identification and optimization of database factors that impact query performance.
www.nhbarcelona.com
|
|
|
Programa:
- Measuring Database Performance
- Importance of Benchmarking
- Key Measures for Query Performance: Sysmon
- Key Measures for Query Performance: Profiler
- Guidelines for Identifying Locking and Blocking
- Optimizing Physical Database Design
- Performance Optimization Model
- Schema Optimization Strategy: Keys
- Schema Optimization Strategy: Responsible Denormalization
- Schema Optimization Strategy: Generalization
- Optimizing Queries for Performance
- Performance Optimization Model: Queries
- What Is Query Logical Flow?
- Considerations for Using Subqueries
- Guidelines for Building Efficient Queries
- Refactoring Cursors into Queries
- Performance Optimization Model: Query-Set-based solutions
- Five Steps to Building a Cursor
- Strategies for Refactoring Cursors
- 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
- 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
www.nhbarcelona.com
|
|
|
|
New Horizons Barcelona
|
New Horizons, líder en formación informática e inglés a nivel mundial, centra su actividad en impartir formación de alta calidad, tanto para empresas como para el público en general. En la actualidad forma a más de 3 millones de alumnos anualmente y cuenta con una red de franquicias de más de 250 centros en 57 países.
New Horizons Barcelona ofrece un extenso programa de formación informática, que incluye desde clases de aplicaciones ofimáticas, gráficas, de Internet o multimedia, como de formación técnica de diferentes fabricantes de software (Microsoft, Oracle, CompTIA, Linux, Sun, Lotus....
+ info
- Más cursos de New Horizons Barcelona
|
|
