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.
Overview
Syllabus
Introduction
- Course introduction
- Agenda
- Setting expectations
- Subqueries
- Set operators
- Challenge
- Solution
- Self and inequality joins
- Lateral joins
- Challenge
- Solution
- Ordered set functions
- Grouping sets
- Challenge
- Solution
- Recursions
- The cursors curse
- Conclusion
Taught by
Ami Levin
