Explaining SQL Joins the Right Way

(Photo by author)

This article takes the perspective of someone who needs to introduce people to the concept of Joins in databases, e.g. LEFT JOIN. This can be a senior analyst role, data scientists, or actual teachers and tutors. This combines the worlds of data and education science on a practical level.

When teaching Joins in SQL, chances are you will use or see Venn diagrams — just image search JOINS SQL and they’re…