Transmenu powered by JoomlArt.com - Mambo Joomla Professional Templates Club

Course Length: 3 days.   

Overview

This three-day instructor-led workshop provides database developers working in enterprise environments using Microsoft SQL ServerT 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.

At the end of the course, students will be able to normalise databases, optimise data storage, and manage concurrency. They will be able to optimise and tune queries for performance and an indexing strategy and decide when cursors are appropriate. Lastly, students will be able to identify and resolve performance-limiting problems.

Audience

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.

Outline

1. Measuring Database Performance
2. Optimising Physical Database Design
3. Optimising Queries for Performance
4. Refactoring Cursors into Queries
5. Optimising an Indexing Strategy
6. Managing Concurrency

Prerequisites

Before attending this workshop, students must have working knowledge of data storage, be familiar with index structures, index utlisation and have had hands-on database developer experience. Students should also be familiar with the locking model, understand Transact-SQL syntax and programming logic. Additionally, they should be able to design a database to third normal form (3NF) and know the trade offs when backing out, have strong monitoring and troubleshooting skills, which includes using mo