Learn about four different types of SQL joins and get hands-on practice creating the joins in GitHub Codespaces.
Overview
Syllabus
Introduction
- Welcome to the course
- Prerequisites and preassessment
- Getting started with GitHub Codespaces
- Installing the database in GitHub Codespaces
- SQL commands for determining relationships
- Try it: Schema description SQL commands
- Check it: Schema description SQL commands
- Try it: Table and column description SQL commands
- Check it: Table and column description SQL commands
- Understanding inner joins
- Try it: Inner join
- Check it: Inner join
- Understanding self joins
- Try it: Self join
- Check it: Self join
- Understanding left joins
- Try it: Left join
- Check it: Left join
- Try it: Multiple complex joins
- Check it: Multiple complex joins
- Understanding right joins
- Try it: Right join
- Check it: Right join
- Try it: Full outer join
- Check it: Full outer join
- Understanding cross joins
- Try it: Cross joins and Cartesian joins
- Check it: Cross joins and Cartesian joins
- Continuing on with SQL
Taught by
Nikiya Simpson
