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 a FULL OUTER JOIN do?
💡 Hint: Think about how rows might not match between two tables.
Question 2
Easy
What does SELF JOIN allow you to do?
💡 Hint: Consider comparing entries within the same entity.
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 will a FULL OUTER JOIN return?
- Only matching rows
- All rows from both tables
- Only rows from the left table
💡 Hint: Consider what each join type typically provides.
Question 2
True or False: INTERSECT will return all rows from the first dataset.
- True
- False
💡 Hint: Think about the commonality of data between two datasets.
Solve 1 more question and get performance evaluation
Challenge Problems
Push your limits with challenges.
Question 1
Create an SQL query that utilizes FULL OUTER JOIN and CROSS APPLY between two tables, demonstrating how they work together in a complex dataset.
💡 Hint: Consider how CROSS APPLY can dynamically apply functions to pulled rows.
Question 2
Write a complex query using INTERSECT and EXCEPT to filter down a list of products that are available in both the current inventory and the archived sales, excluding any that are marked as discontinued.
💡 Hint: Break down the query by defining each part before composing it together for clarity.
Challenge and get performance evaluation