Skip to main content
Back to course
Log in
Get started
Someone wanted to learn this too, so Grasp built them a personal learning path.
Create your own
SQL for product designers
ยท
Module 3
Connecting Product Data with Joins
1
Linking Tables with Primary and Foreign Keys
Explain the role of primary and foreign keys in linking tables like 'users' and 'events'.
Explain the role of primary and foreign keys in linking tables like 'users' and 'events'.
2
Joining Tables with INNER JOIN
Use INNER JOIN to combine rows from two tables based on a matching key (e.g., link users to their actions).
Use INNER JOIN to combine rows from two tables based on a matching key (e.g., link users to their actions).
3
Simplifying Joins with Table Aliases
Use table aliases (AS) to simplify and clarify queries with joins.
Use table aliases (AS) to simplify and clarify queries with joins.
4
LEFT JOIN for User Actions
Use LEFT JOIN to find users who have or have not performed a certain action.
Use LEFT JOIN to find users who have or have not performed a certain action.
5
Filtering Joined Tables with WHERE
Apply the WHERE clause to filter the results of a joined table.
Apply the WHERE clause to filter the results of a joined table.
Previous module
Filtering and Sorting for User Insights
Next module
Calculating Core Product Metrics