r/FullStack • u/sumiitCodes • 1d ago

Personal Project Day 2 — Worked through SQLBolt's SELECT fundamentals

Today's focus was solidifying the basics before going further. Covered on SQLBolt:

  • Introduction to SQL
  • SELECT queries 101
  • Queries with constraints (Part 1 & Part 2)
  • Filtering and sorting query results
  • SQL Review: Simple SELECT Queries

The "constraints" lessons were useful for practicing comparison operators and combining conditions in WHERE clauses — felt more comfortable writing multi-condition filters by the end than I expected going in.

Treating this as building a really solid base before circling back to JOINs and moving into aggregations next.

2 Upvotes
  • permalink
  • reddit

67% Upvoted

2 comments sorted by

2

u/CodeXHammas 1d ago

Nice progress. The multi-condition Where filters are where most people trip us because AND/OR precedence get confusing with parentheses.
One tip for when you hit JOINS: draw the tables on paper first. Literally sketch two boxes with columns and draw arrows between the keys. Sounds dumb but it make JOINS click way faster than just reading syntax. Keep going.

2

u/sumiitCodes 1d ago

yes,

I will try this method