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

Course introduction - SQL Tutorial

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

Start my 1-month free trial

Course introduction

(upbeat uplifting music) - [Instructor] I recently published a course titled "Advanced SQL Logical Query Processing." You liked this course so much that you've been asking me in the Q and A section, in the feedback and in personal messages for more. And the truth is, I was planning to do a part two anyway. Leaving good materials from part one on the editing room floor is a huge incentive for people like me to do a sequel. Pun intended. So it's with great pride and joy that I present to you "Advanced SQL Logical Query Processing Part Two." You will learn new techniques and language constructs, subqueries, set operators, lateral joins, grouping sets, recursive WITH clauses, ordered set functions, and more. You will learn how and when to use them, and I'll warn you of the common pitfalls. It'll be educational and fun. Well fun, at least, for me. If you haven't watched part one yet, please go do it now. Go, go, don't worry; I can wait. I'll be here when you come back. I promise. (upbeat uplifting music)

Contents