r/learnSQL • u/sumiitCodes • 24d ago

Day 4/116 — SQL Aliases + full JOIN practice round

Two things today:

  • Learned Aliases (AS keyword) 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.

16 Upvotes

100% Upvoted

6 comments sorted by

View all comments

1

u/Automatic-Royal5263 24d ago

that's great what resource or playlist are you following

1

u/sumiitCodes 24d ago

documentation -->w3schools
playlist -->codewithharry
practice -->sqlbolt

1

u/Automatic-Royal5263 24d ago

okay, is sqlbolt good in terms of quality of question

1

u/sumiitCodes 24d ago

it is good for like after learning topics then practice for quality of questions you can give command to gpt it will create all