Practice It: SQL Joins

Learn about four different types of SQL joins and get hands-on practice creating the joins in GitHub Codespaces.

Introduction

• Welcome to the course
• Prerequisites and preassessment
• Getting started with GitHub Codespaces
• Installing the database in GitHub Codespaces

1. SQL JOIN and Descriptions

• 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

2. Inner Join

• Understanding inner joins
• Try it: Inner join
• Check it: Inner join
• Understanding self joins
• Try it: Self join
• Check it: Self join

3. Left Join

• Understanding left joins
• Try it: Left join
• Check it: Left join
• Try it: Multiple complex joins
• Check it: Multiple complex joins

4. Right Join

• Understanding right joins
• Try it: Right join
• Check it: Right join
• Try it: Full outer join
• Check it: Full outer join

5. Cross Join

• Understanding cross joins
• Try it: Cross joins and Cartesian joins
• Check it: Cross joins and Cartesian joins

Conclusion

• Continuing on with SQL