Zero
To
Job
First Job
Courses
Log in
Sign up
Supabase: The Complete Guide
SQL III: Relationships & Joins
SQL III: Relationships & Joins
Foreign keys and ON DELETE, one-to-many, many-to-many, INNER vs LEFT, anti-joins, the accidental Cartesian product, subqueries.
0 / 6 concepts complete
20
Foreign keys & ON DELETE actions
Schema
~95%
21
Modeling one-to-many
Schema
~95%
22
Many-to-many & the join table
Schema
~85%
23
INNER JOIN & LEFT JOIN
SQL
~100%
24
Anti-joins, self-joins & the Cartesian product
SQL
~60%
25
Subqueries, EXISTS & IN
SQL
~75%
0%
Roadmap
Love it? Share