Professional Courses
Industry-relevant training in Business, Technology, and Design to help professionals and graduates upskill for real-world careers.
Categories
Interactive Games
Fun, engaging games to boost memory, math fluency, typing speed, and English skills—perfect for learners of all ages.
Typing
Memory
Math
English Adventures
Knowledge
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 related to the topic.
Question 1
Easy
What does INNER JOIN do?
💡 Hint: Think about how it works with overlapping data.
Question 2
Easy
What is a LEFT JOIN?
💡 Hint: What happens to non-matched records?
Practice 4 more questions and get performance evaluation
Interactive Quizzes
Engage in quick quizzes to reinforce what you've learned and check your comprehension.
Question 1
What does an INNER JOIN do?
- A. Combines all records
- B. Fetches matching records from both tables
- C. Only shows records from the right table
💡 Hint: Consider what it means for records to match.
Question 2
True or False: A LEFT JOIN will return only matching records from the left table.
- True
- False
💡 Hint: Think about the nature of all records being included.
Solve 1 more question and get performance evaluation
Challenge Problems
Push your limits with challenges.
Question 1
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.
Question 2
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.
Challenge and get performance evaluation