Skip to main content
DatabricksPySparkSnowflakeApache Airflow
Code Keys/SQL Academy/Module 06
SQL ACADEMY • MODULE 06

Advanced Joins & Sets

Perform full data reconciliations with FULL OUTER JOIN, model hierarchies with SELF JOIN, combine sets with UNION, and append datasets with UNION ALL.

Advanced📚 4 Lessons⭐ 0 / 1600 XP⏳ In Progress
0 / 4 Lessons Completed (0%)
CHALLENGE CURRICULUM

Module Lessons

0 / 4 Complete
LESSON 21

🔓 SQL FULL OUTER JOIN

⏱ 3 Mins • ⭐ 380 XP • Advanced

Start Mission →
LESSON 22

🔒 SQL SELF JOIN

⏱ 3 Mins • ⭐ 390 XP • Advanced

LESSON 23

🔒 SQL UNION

⏱ 3 Mins • ⭐ 400 XP • Advanced

LESSON 24

🔒 SQL UNION ALL

⏱ 3 Mins • ⭐ 430 XP • Advanced

← Previous ModuleNext Module →