I made a beginner-friendly SQL JOINs tutorial using PostgreSQL

[u/yahoo_06]

Hey everyone!

I just published a new video about SQL JOINs for beginners.

In this lesson, I explain:

- why relational databases use multiple tables

- how JOIN works

- INNER JOIN

- LEFT JOIN

- how the ON condition connects tables

- table aliases

- how to join multiple tables

- and how to combine JOINs with WHERE and ORDER BY

I use the Pagila PostgreSQL database for the examples and practice, so everything is demonstrated with actual data rather than just theory.

I'm building a beginner-friendly SQL tutorial series, so I'd really appreciate any feedback on the explanations or examples!

Video:

https://youtu.be/cRN6ikxtdpo?si=_Q2h5e-8BcCAJEYB

[u/Jonsinator]

Is it as sloppy as the image?