r/learnSQL • • 7h ago

i need to learn as much sql in one week as possible from zero

14 Upvotes

Hi guys i have somthing that is database reateld in about one and half weeks and i need to learn as much SQL and database desing is possible in the next 1.5 weeks. i have about 3 hours of studytime a day. i corrcrtnly dont know much. can someone tell me where to start. i heard about SQLbolt but that it.


r/learnSQL • • 6h ago

I made a free set of 54 short SQL exercises that tell you *why* your query is wrong, not just that it is

2 Upvotes

Hi r/learnSQL, I'm a data engineer and I built SQL Dojo https://sqldojo.dev to practise SQL the way I wish I had learned it: lots of short steps, each one checked, with an explanation when you get it wrong.

What it looks like:

  • Each step asks a question about a realistic dataset (an online shop, a SaaS, product events…) and checks your result.
  • When it's wrong, it tells you how: too many rows, missing rows (and which ones), values that differ, and the likely cause, like a join that duplicates rows or a NULL hiding in a NOT IN.
  • A "step by step" view runs your query one clause at a time, in the order the database actually runs it (FROM, then WHERE, then GROUP BY…). This is the thing that made SQL click for a lot of people I've taught.
  • Spaced reviews bring back the steps you struggled with.

It runs in your browser: no install, no database to set up, no account needed to start.

The white belt (54 steps, about 3 hours, from your first SELECT to joins and GROUP BY) and the reference library are free. The later belts (window functions, CTEs, data modeling, interview runs) are a one-time payment, no subscription, and you don't need them to get value from the free part. There a also a practice section with real datasets.

I'd really like feedback from people learning right now: where did you get stuck, was an explanation unclear, is the pace right?


r/learnSQL • • 11h ago

count(*) vs count(col), i keep mixing them up

5 Upvotes

ok so my teacher said count(*) counts rows and count(col) skips nulls, but then he did an example with a left join and the numbers looked off to me and i didnt catch why. is the rule basically use count(right_table.id) after a left join if you want 0 for the ones with no match? or does count(*) still give 1 there


r/learnSQL • • 23h ago

Title: Day 70-72 — Combined update: HashMap/HashSet, full core Java revision, and planning a Hospital Management System

7 Upvotes

Over the last three days I:

  • Covered HashMap and HashSet
  • Revised all of core Java again, this time implementing everything in code instead of only reading my notes
  • Picked my next project: a Hospital Management System that uses all the core Java topics I’ve learned so far

For the planning, I used Claude as a guide, more like a mentor than a code generator. It helped me think through the structure and finalize a plan without giving me the code, so the implementation will still be mine. I start building tomorrow.

Based on the feedback I got here on my earlier projects, I’ll test each part as I build it and not leave all the errors for the end.

For people who’ve built a hospital or similar management system as a beginner: what would you plan before writing code, and what did you wish you’d designed differently?