Mastering the Basics of SQL Server Query Optimization
What you'll learn
- At the conclusion of this course you'll understand how the optimizer works at a very high level.
- You will be able to read showplans. These are created when a query is executed.
- You'll understand the caching mechanisms behind SQL Server optimizer.
Requirements
- This course was designed for anyone with a working knowledge of relational databases, specifically SQL Server.
- It can be anything other than Express also
- Other than SQL Server nothing else is needed to take the course.
- I've included code samples for the course in the Course Download lecture.
- You will need to download and install SQL Server 2012, 2014 or 2016 Express Edition
- You'll also need to download a copy of the Adventureworks database.
Description
Student Warning: Even though this is a beginners class it's fast paced and will require some outside study on your part.
I've included 4 different preview lessons so you could better gauge the speed of the course. Please take a moment to preview all of them. If those lessons are too fast then please take this course after you've taken my entry level courses. Thanks.... Mike
Recent Unsolicited Testimonials
“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
In this course we are going to delve into the Query Optimizer, easily one of the most complicated pieces of software ever written.
The Query Optimizer is the SQL Server component that tries to give you an optimal execution plan for your queries. The Query Optimizer tries to find that execution plan as quickly as possible. Not the perfect plan but a good one.
The SQL Server Query Optimizer is a cost-based optimizer. It analyzes a number of execution plans for a given query, estimates the cost of each of these plans, and chooses the plan with the lowest cost.
The optimizer seeks to find balance between the optimization time and the quality of the selected plan.
The course will be a balance of hands on query performance tuning and understanding the basics of the optimizer’s architecture.
We are going to learn about the execution engine, statistics and cost estimation, index selection and the optimization process.
At the core of the SQL Server Database Engine are two major components: the storage engine and the query processor also called the relational engine.
In this course our sole focus will be on the query processor. This part of the engine accepts all queries submitted to SQL Server and creates a plan for optimal execution.
See you in the course!!!
Who this course is for:
- This is a mid level course aimed at those who have a working foundation of SQL Server.
- This is not an entry level course.
- Everything you need to take the course will be included. There are no items you'll have to purchase.
Instructor
- 4.2 Instructor Rating
- 24,737 Reviews
- 265,905 Students
- 49 Courses
I'm the founder of LogikBot. I've worked at Microsoft and Uber. I helped design courses for Microsoft's Data Science Certifications. If you're interested in machine learning, I can help.
I've worked with databases for over two decades. I've worked for or consulted with over 50 different companies as a full time employee or consultant. Fortune 500 as well as several small to mid-size companies. Some include: Georgia Pacific, SunTrust, Reed Construction Data, Building Systems Design, NetCertainty, The Home Shopping Network, SwingVote, Atlanta Gas and Light and Northrup Grumman.
Over the last five years I've transitioned to the exciting world of applied machine learning. I'm excited to show you what I've learned and help you move into one of the single most important fields in this space.
Experience, education and passion
I learn something almost every day. I work with insanely smart people. I'm a voracious learner of all things SQL Server and I'm passionate about sharing what I've learned. My area of concentration is performance tuning. SQL Server is like an exotic sports car, it will run just fine in anyone's hands but put it in the hands of skilled tuner and it will perform like a race car.
Certifications
Certifications are like college degrees, they are a great starting points to begin learning. I'm a Microsoft Certified Database Administrator (MCDBA), Microsoft Certified System Engineer (MCSE) and Microsoft Certified Trainer (MCT).
Personal
Born in Ohio, raised and educated in Pennsylvania, I currently reside in Atlanta with my wife and two children.