Member-only story
Every SQL Join Explained Visually
The simplest explanation you will find on the internet
For Non-Members link to the full story
SQL has always been a non-negotiable skill for most tech roles. As a matter of fact, I was asked an SQL question in 75% of my total interviews. The roles that I was applying for were ML Engineer, AI Engineer, Data Scientist, and Analyst.
My interviewers expected me to know SQL. This is because knowing SQL indicates that your fundamentals are strong.
So I started looking through interview experiences online to see which SQL concepts appeared most often.
I saw the questions vary from role to role, but there was one common question asked everywhere.
And that question was about SQL Joins.
Give me the next few minutes. We will go through every SQL JOIN, understand it through images and real examples.
Once you see how they work, you won’t be able to forget them again.
What is a JOIN?
Imagine you have built an e-commerce application.
For now, you’re maintaining two tables. One for your customers and the second for the orders that they have placed.
