2 - Joins (Combining Tables)
Enroll to start learning
You’ve not yet enrolled in this course. Please enroll for free to listen to audio lessons, classroom podcasts and take practice test.
Practice Questions
Test your understanding with targeted questions
What does INNER JOIN do?
💡 Hint: Think about how it works with overlapping data.
What is a LEFT JOIN?
💡 Hint: What happens to non-matched records?
4 more questions available
Interactive Quizzes
Quick quizzes to reinforce your learning
What does an INNER JOIN do?
💡 Hint: Consider what it means for records to match.
True or False: A LEFT JOIN will return only matching records from the left table.
💡 Hint: Think about the nature of all records being included.
1 more question available
Challenge Problems
Push your limits with advanced challenges
Create a dataset of students and classes. Write a SQL query that lists all students and their classes, including students who are not enrolled in any classes.
💡 Hint: Think of how you can keep all students in the results.
You have two tables: Employees and Projects. Use a FULL OUTER JOIN to find all employees and their projects, showing employees without projects and projects without employees.
💡 Hint: Consider how to capture every employee and project, regardless of their pairing.
Get performance evaluation
Reference links
Supplementary resources to enhance your learning experience.