From the course: Advanced SQL: High Performance Relational Divisions
Agenda - SQL Tutorial
From the course: Advanced SQL: High Performance Relational Divisions
Agenda
- [Instructor] As usual, we will start by establishing the theoretical foundations before jumping into the practice. I believe that memorizing a technique will not get you very far. You might as well just copy someone else's queries from stack overflow, right? We will cover the formal definitions and mathematical foundations of relational division, using a fictional chess tournament analogy. After we learn what relational division is all about, we will apply this theory to solve various relational division challenges using three different techniques. Aggregations, set operators, and the magical nested double negative correlated subqueries. Finally, after mastering all three techniques we will crack a few interesting nuances of relational divisions, which will take the challenge levels to new heights.
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.