Day 3 of 45 · SQL Masterclass · Free
Day 3: JOINS
Reconstruct complete ShopKart order fulfillment records and audit orphaned payments.
About 60 minutes of learning and 90 minutes of practice. It runs in your browser, with no install.
What you will be able to do
- Join tables with INNER, LEFT, RIGHT, FULL, and CROSS joins while tracking row count changes.
- Explain why relational normalization divides data across tables and why joins reconstruct it.
- Diagnose and prevent Cartesian join explosions caused by duplicate join keys.
What the day covers
INNER, LEFT, RIGHT, FULL, CROSS, SELF JOIN.
Questions you should be able to answer afterwards
- Why does a LEFT JOIN sometimes produce more rows than the left table originally had?
- What is a CROSS JOIN and what is the formula for its output row count?
- Why is normalisation used in OLTP databases?
Practice this day's skills
Each page shows the idea moving, then lists problems from easiest.
Builds on Day 2.
Days 1 to 7 are free. Days 8 to 45 need a pass; the plan page lists what each day covers, and the glossary defines each term.