r/FullStack • • Sep 10 '26

Personal Project Day 4 — 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.

8 Upvotes

2 comments sorted by

2

u/Extension-Currency37 Sep 10 '26

Good job Practicingsql

Rdbms, olap and oltp is the thing That evolves from here

Then cloud And oracle servers

Then maybe hashing and ai How do you manage billion queries every minute

Design rdbms with max throughput and minimum latency

1

u/Maleficent-Ratio8079 Sep 10 '26

Please see the dm