Skip to main content
grasp.study
About
Explore
Pricing
Log in
Try it for free
Back to course
👋
Welcome to a Grasp lesson
Create a free account
to keep studying and create your own study path.
Job-ready SQL and database skills
·
Module 3
Joining Multiple Tables
1
Primary and Foreign Keys: Building Database Relationships
Explain the function of primary keys and foreign keys in establishing relationships.
2
Joining Tables with INNER JOIN
Combine rows from two tables using `INNER JOIN` based on a matching condition.
3
Understanding LEFT and RIGHT JOINs
Use `LEFT JOIN` and `RIGHT JOIN` to include unmatched rows from one table.
4
Table Aliases for Readability in Joins
Apply table aliases to improve the readability of multi-table join queries.
5
Multi-Table Joins
Construct queries that join three or more tables.
6
Self-Joining for Hierarchical Data
Perform a self-join to query hierarchical relationships within a single table.
Previous module
The Relational Model and SQL Fundamentals
Next module
Aggregation and Grouping