2784 -Tuning and Optimizing Queries using Microsoft SQL Serv
Sponsored links
This three-day instructor-led workshop 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 workshop focuses on systematic identification and optimization of database factors that impact query performance.
| Delivery: |
|
| Category: |
Further Details
At the end of this course participants will be able to:
Normalize databases
Design a normalized database.
Optimize a database design by denormalizing.
Optimize data storage
Manage concurrency
Manage concurrency by selecting the appropriate transaction isolation level.
Select a locking granularity level.
Optimize and tune queries for performance
Optimize an indexing strategy.
Decide when cursors are appropriate.
Identify and resolve performance-limiting problems.
Information provided is for information purposes only and no guarantees are made with regards to accuracy. It is advised that all details are checked prior to making a booking. Contents © 1999 - 2012. All rights reserved.
