19.1.5 - Advanced Joins and Set Operations
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 a FULL OUTER JOIN do?
💡 Hint: Think about how rows might not match between two tables.
What does SELF JOIN allow you to do?
💡 Hint: Consider comparing entries within the same entity.
4 more questions available
Interactive Quizzes
Quick quizzes to reinforce your learning
What will a FULL OUTER JOIN return?
💡 Hint: Consider what each join type typically provides.
True or False: INTERSECT will return all rows from the first dataset.
💡 Hint: Think about the commonality of data between two datasets.
1 more question available
Challenge Problems
Push your limits with advanced challenges
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.
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.
Get performance evaluation
Reference links
Supplementary resources to enhance your learning experience.