SQL Server 2017 Internals and Query Tuning is an advanced 5-day course designed for experienced SQL Server professionals. This course will be presented on SQL Server 2017 and cover features specific to that version, but much of the information is relevant to earlier versions as well.

This 5-day intensive seminar was developed by one of the world's leading experts in SQL Server internals. 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

In-memory OLTP

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.

Determine if concurrency issues are causing problems with performance and choose an appropriate solution.

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 experienced SQL Server professionals.

SQL Server Internals

Kalen Delaney teaches the most advanced SQL Server courses in the world. Her 5-day course “SQL Server Internals and Tuning” is designed for advanced SQL Server professionals who want to know how SQL Server really works, in order to take maximum advantage of its potential.