SQL Query Logical Processing - Part 1

Query processing order is one of the most fundamental aspects of SQL.
In this session we’re going to explore the sub-atomic structure of a SQL query from a fresh new angle which will bring radical new insights into SQL’s beauty and power.
You'll begin to see SQL queries through the eyes of the database engine, exactly as it processes each clause, unveiling the intricacies and logic of each. These new understandings will enable you to write more efficient, elegant queries, troubleshoot and optimize existing code with ease, and save many hours of frustration and hair pulling.
You'll learn:
• How the server REALLY processes your queries
• Logical implications of processing order
• Performance implications of processing order
• Understand and avoid common pitfalls

[MrKumaranraj]

Thank you so much for making this video. I always had some trouble in understanding how the query processing work and what is the logic behind it. This three part video helps me to understood some extent. Please take a detailed session on how indexing works, really love to see that.