Udemyintermediateen

Mastering the Basics of SQL Server Query Optimization

Master query execution! Learn to build optimal plans for faster, more efficient database performance. Improve your SQL skills today.

4.2(1,073)
5,202students
1h 8m
Certificate
Mike West
Mike WestCreator of LogikBot

Course Content

Mastering the Basics of SQL Server Query Optimization is an intermediate-level Udemy course taught by Mike West. It runs 1h 8m, is taught in English, and includes a certificate of completion. Learners rate it 4.2 out of 5 from 1,073 reviews, with 5,202 students enrolled. It is a paid course, first published February 2016.

Dive into SQL Server Query Optimization with this focused course! Even though designed for beginners, this course moves at a brisk pace and benefits from some independent study. We provide four preview lessons to help you assess the learning speed – we recommend foundational SQL knowledge before starting.

This course unlocks the secrets of the SQL Server Query Optimizer, a critical component for achieving peak database performance. The Query Optimizer is the engine within SQL Server that works tirelessly to determine the most efficient execution plan for your database queries. It doesn't aim for perfect, but rather a good plan, found quickly.

Learn how the SQL Server Query Optimizer, a cost-based optimizer, analyzes various execution plans, estimates their costs, and selects the plan with the lowest estimated cost. The optimizer balances the time spent optimizing with the quality of the resulting plan.

This course blends hands-on query performance tuning with a solid understanding of the optimizer's architecture. You'll explore:

  • Execution Engine: Understand how SQL Server processes queries.
  • Statistics and Cost Estimation: Learn how the optimizer estimates the cost of different execution plans.
  • Index Selection: Discover how indexes impact query performance.
  • Optimization Process: Gain insight into the steps the optimizer takes to find the best plan.

We'll focus specifically on the query processor (relational engine), one of the two major components of the SQL Server Database Engine (the other being the storage engine). The query processor receives your SQL queries and constructs the plan for optimal execution.

Here's what others are saying:

  • "Learned lots from this well constructed and easy to follow course - thanks Mike!" – Caroline
  • "Feel much more confident in MSSQL now. Thanks!" – Jef Yo
  • "This short course is excellent and will give you a good understanding of the basics in SQL server administration." – Luke Dunn

Get ready to master SQL Server performance tuning and become proficient in optimizing your database queries!

$ whoami — the devs behind tutorialsearch.io

Hire the developers behind TutorialSearch.io

We built this site — full-stack web apps, AI integration & automation. Tell us what you need and we'll build yours.

5.0
26m
intermediate
pluralsight
5.0(1,983)
8h 27m
all
skillshare
5.0(346)
1h 6m
all
skillshare