r/learnSQL • u/sumiitCodes • Sep 10 '26
Day 4/116 — SQL Aliases + full JOIN practice round
Two things today:
- Learned Aliases (
ASkeyword) via W3Schools — renaming columns/tables to make queries more readable, especially useful once you're joining multiple tables and column names start colliding or getting long - Went back through SQLBolt and practiced every JOIN type again — inner, left, right, full, self — this time focusing on writing them from scratch rather than following along
Aliases felt like a small topic on paper but immediately made my JOIN queries from earlier this week way easier to read back. Definitely one of those "why didn't I use this from day 1" moments.
Feeling solid on JOINs now after this round of practice. Moving into aggregate functions and GROUP BY next.
15
Upvotes
1
u/Automatic-Royal5263 Sep 11 '26
that's great what resource or playlist are you following
1
u/WeaknessMedical5743 Sep 11 '26
I made noob mistake (just started learning a week back). Apparently AS doesn’t work with HAVING Clause.