Databricks · Databricks Data Analyst Associate
Joins and set operations
Databricks Data Analyst Associate · Lesson 8 of 18 · 55:20
YouTube loads only after you press play. This chapter opens at its timestamp in the full course. Watch on YouTube ↗
In this lesson
Prepare for the Databricks Certified Data Analyst Associate exam. In this lesson: inner, left, right, and full outer joins, joins on multiple keys with ON or USING, keys that multiply rows, cross joins, semi and anti joins, and UNION, UNION ALL, INTERSECT, and EXCEPT. Includes three original practice questions.
Preview the topics
- A weekly report must list every Cobbleway store with its rentals of the week, including the stores with no rental yet. The stores table is on the left. Which join should the analyst write?
- The daily targets and daily sales tables both hold one row per store and per day. The analyst joins them on the store ID only, and the totals come out far too high. What fixes the query?
- The rentals of the north and south regions sit in two tables with the same columns, and no rental can belong to both. The analyst wants them stacked in one result, as fast as possible. Which operation fits?