Mastering the Basics of SQL Server Query
Mastering the Basics of SQL Server Query Optimization
Learn to
Create Optimal Execution Plans for Your Queries
Description
Student Warning: Even though this is a beginner’s class it's
fast-paced and will require some outside study on your part. 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.
“Learned lots from this well-constructed and straightforward to follow the course"
This short course is superb and can offer you an honest
understanding of the fundamentals in SQL server administration.” Luke Dunn
In this course, we are getting to delve into the Query
Optimizer, easily one among the foremost 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 variety of execution plans for a given query, estimates the value of every one of
those plans, and chooses the plan with rock bottom cost.
The optimizer seeks to find a 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 is two major components: the storage engine and the query the processor also called the relational engine.
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 show plans. These are created when a query is executed.
- You'll understand the caching mechanisms behind SQL Server optimizer.
Who this the 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.
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 Adventure works database
 |
Click Here To Join |
 |
Click Here To Download |
Post a Comment