This course is aimed at SQL Developers who wish to improve their coding abilities by going deeper into SQL Server internals to ensure that their code works with and not against the database engine.
Basic SQL Server Optimizer Knowledge.Intermediate Execution Plan Analysis.Intermediate understanding of T-SQL.
The purpose of the course is to provide SQL Developers with a deep knowledge of the SQL Server Optimizer and Execution engines to enable them to write highly performant code and get the very best performance from their servers.
Module 1: Data Storage and Access
Module 9: Cost Based Queries
Module 2: The Buffer Pool
Module 10: Parameter Sniffing
Module 3: Basic Execution Plans
Module 11: Intermediate Execution Plan Analysis
Module 4: Indexing
Module 12: Locking and Blocking
Module 5: Optimizer Join Types
Module 13: Isolation Levels
Module 6: Memory Grants
Module 14: In-Memory
Module 7: Statistics
Module 15: Wait Statistics
Module 8: Parallelism
Module 16: Advanced Execution Plan Analysis
Stay current with our latest insights
© Copyright 2021 Kutech Solutions Ltd.