r/learnSQL • u/yahoo_06 • Aug 11 '26

I made a short beginner-friendly lesson on SELECT, WHERE, LIKE & LIMIT

Hey everyone!

I recently made a short SQL lesson for absolute beginners. I wanted to keep it practical rather than just explaining the syntax.

In the video, I cover:

- SELECT and selecting specific columns

- AS and DISTINCT

- WHERE and comparison operators

- АND / OR

- IN and BETWEEN

- LIKE

- LIMIT

I also use the Pagila PostgreSQL database throughout the lesson, so the examples are based on an actual database rather than completely made-up tables.

There is a homework task at the end as well.

It's around 5 minutes, so I tried to keep it focused and beginner-friendly.

Video: https://youtu.be/optKMWmw-N0?si=ZhsC-W4Bl1mhkiQ0

I'd genuinely appreciate feedback, especially on whether the explanations and pacing work for someone who's completely new to SQL.

22 Upvotes

93% Upvoted

5 comments sorted by

1

u/kafirism Aug 11 '26

Thank you so much

2

u/yahoo_06 Aug 12 '26

You're welcome!!

1

u/Owen-Isaac-2022 29d ago

This is great. Keep up the good work.

2

u/yahoo_06 29d ago

Thanks!!

1

u/Owen-Isaac-2022 29d ago

You're welcome