SQL Tutorial - Logical Query Processing

Published: 29 May 2017
on channel: BeardedDev
10,176
185

This video demonstrates the differences between how we write a query in Microsoft SQL Server and how the query is processed by the database engine. It is very important to understand the logical query processing order to understand how write queries correctly and also when analysing queries from a performance perspective.

T-SQL Querying
https://www.amazon.com/gp/product/073...

T-SQL Fundamentals
https://www.amazon.com/gp/product/150...

Microsoft SQL Server 2012 High-Performance T-SQL Using Window Functions
https://www.amazon.com/gp/product/073...

Logical Query Processing Order:
1. FROM
2. WHERE
3. GROUP BY
4. HAVING
5. SELECT
6. ORDER BY


On this page of the site you can watch the video online SQL Tutorial - Logical Query Processing with a duration of hours minute second in good quality, which was uploaded by the user BeardedDev 29 May 2017, share the link with friends and acquaintances, this video has already been watched 10,176 times on youtube and it was liked by 185 viewers. Enjoy your viewing!