|
|
 |
Microsoft SQL Server 2005
Tuning and Optimizing Queries using Microsoft SQL Server 2005 (2784)
|
|
|
Who Should Attend
| 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. |
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 monitoring tools.
|
|
|
| Students should have a basic knowledge of application architecture, know how use a data modeling tool, and be familiar with SQL Server 2005 features, tools and technologies. They should also have finished Microsoft Certified Technology Specialist: Microsoft SQL Server 2005 or equivalent experience. It is also recommended to finish the following courses: (2778) Writing Queries Using Microsoft SQL Server 2005 Transact-SQL, (2779) Implementing a Microsoft SQL Server 2005 Database, and (2780) Maintaining a Microsoft SQL Server 2005 Database |
Course Objectives
| 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. |
Course Content
| 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 |
Dates Europe
To book a course, please click on the required city name.
Germany
|
|
|
|
Neumuenster