From the course: Advanced SQL: Logical Query Processing, Part 1

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Course review and takeaway

Course review and takeaway - SQL Tutorial

From the course: Advanced SQL: Logical Query Processing, Part 1

Start my 1-month free trial

Course review and takeaway

“

- [Instructor] We started our query processing adventure less than two hours ago, with me making some wild claims and promises about this course. I hope you found our time together worthwhile. We started at the same place the database engine begins processing of every query, the FROM clause. We saw how to use single and multiple source datasets and how the different types of joins are processed. We learned how SQL handles missing data and the intricacies of ternary logic. We saw why the processing order of join qualification predicates versus the WHERE row filter is so critical. That was a fun chapter. Well, at least for me it was. We followed the datasets path to the GROUP BY clause, where it was transformed beyond recognition. We realized why it introduces limitation as to what can and can't be referenced from that point on, and to the role of aggregate functions. You might have noticed that there was no dedicated…

Contents