SQL Joins
The JOIN operator tells how to combine different tables in SQL. It’s a simple and yet powerful concept that requires some time to get used to. Most explanations online describe SQL joins as Venn diagrams, like here, but I find these confusing for so many reasons. SQL has its own versions of set operations (UNION, INTERSECT and EXCEPT). These operations are closer to the Venn diagrams than JOIN.