SQL Server 2005 Architecture Internals and Tuning

The following is a list of available SQL Server 2005 Architecture Internals and Tuning classes at ISInc. If you do not see the course you are interested in, please contact us. We can setup dedicated, online and onsite classes too!

Course Number: ISI-1079

Much of the information is relevant to SQL Server 2000 as well.

Description

This 5-day intensive seminar was developed by one of the world's leading experts in SQL Server internals, Kalen Delaney, author of the best selling book Inside SQL Server 2000 and Inside SQL Server 2005. Kalen has been a columnist at SQL Server Magazine since the first issue, as well as writing for MSDN and TechNet Magazines. Kalen's courses and seminars on SQL Server Internals have successfully delivered at internal Microsoft training events and as on-site courses for premier Microsoft partners around the world.

This is an advanced 5-day course designed for advanced SQL Server professionals. The course includes extensive demonstrations that illustrate the details of SQL Server internals as well as tuning techniques. This course will be presented on SQL Server 2005 and cover features specific to that version, but much of the information is relevant to SQL Server 2000 as well.

Topics to be covered include the following:
SQL Server Architecture and Metadata
Physical Storage Structures
Index Design and Tuning
Query Processing and Query Plans
Optimization and Recompilation
Concurrency Control: Locking, Blocking and Row Level Versioning
Query Tips and Techniques
Troubleshooting Tools

The course includes extensive demonstrations that illustrate the details of SQL Server internals as well as performance tuning techniques. Optional hands-on labs are available.

Prerequisites

Before attending this course, students should have a good understanding and practical experience of SQL Server programming and administration. This is an advanced seminar designed for advanced SQL Server professionals.

List Price

$3950.00

Upcoming Classes

Available classes for SQL Server 2005 Architecture Internals and Tuning
Start Date End Date Class Status Days Location
02/02/2009 02/06/2009 Seats Available Consecutive days Sacramento CA Enroll
Skip to top