Advanced SQL: Logical Query Processing, Part 2

Take your SQL skills to the next level. Continue learning about aspects of logical query processing: from subqueries to ordered set functions, and from lateral joins to cursors.

Introduction

• Course introduction
• Agenda
• Setting expectations

1. Subqueries and Set Operators

• Subqueries
• Set operators
• Challenge
• Solution

2. Advanced Joins

• Self and inequality joins
• Lateral joins
• Challenge
• Solution

3. More on Grouping

• Ordered set functions
• Grouping sets
• Challenge
• Solution

4. Recursions and Cursors

• Recursions
• The cursors curse

Conclusion

• Conclusion