Understanding Query Optimization in SQL Server
This module lays the theoretical foundations for optimizing SQL Server queries. It answers the fundamental question: when should you start optimizing your T-SQL queries?
Retrieving data from SQL Server efficiently and effectively is an art in itself. This course teaches how to get the most out of your T-SQL queries.
Prerequisites: Knowledge of basic data structures and fundamental notions of the T-SQL language.
Key principle: You must identify the queries that have the most impact on the system and concentrate optimization efforts on them.
Sign in to read this course
A free account unlocks all 514 courses. 20 are readable without one.
What's inside
10 sections- 1 Table of Contents
- 2 Course presentation
- 3 Introduction to Query Optimization in SQL Server
- 4 Understanding Query Plans
- 5 Understanding the Reuse Plan and the Cache Plan
- 6 Understanding Indexes and Statistics
- 7 Optimize Ad Hoc Expressions and Parameterization
- 8 Understanding Plan Guides and Query Hints
- 9 Overall course summary
- 10 Demo Code Files
More Microsoft SQL Server courses
View all 8Advanced Querying Techniques in SQL Server
This training explores several advanced querying techniques in Transact-SQL (T-SQL), the SQL dialect used by Microsoft SQL Server. It is aimed at developers and database administrators wh...
Introduction to SQL Server
At the end of this course, you will know how Microsoft SQL Server can help you manage your data challenges and needs.
Optimizing Query Performance with Columnstore Indexes
This course introduces and explores in depth Columnstore Indexes in SQL Server — one of the most powerful features for improving the performance of analytical queries on large volumes of...
Querying Data with SQL Server
SQL (Structured Query Language) is the programming language used to communicate with relational databases. It has been around for over 50 years and remains omnipresent in all areas relate...
Securing SQL Server Applications
This course is aimed at developers and DBAs who work with SQL Server and want to improve the security posture of their databases. Data is an organization's most valuable asset, and SQL Se...
SQL Server Security Fundamentals
This demo uses T-SQL (not SSMS) for all examples.
Interested in this course?
Contact us to book it or get a custom training plan for your team.