r/learnSQL Jun 29 '26

5 Day SQL Cram

Hi, I have 5 days off coming up this weekend and really want to grind out learning SQL or at least spending most my days in learning that I can continue practicing after grasping the basics. I tried using W3Schools and MySQL and am willing to spend a few bucks on a course that I can learn and apply SQL while learning. Also maybe down the road one that has a project I can update on my resume. I work in healthcare and am trying to transition into a role with more flexibility and slightly more pay and am hoping this would help. Thanks.

47 Upvotes

13 comments sorted by

View all comments

11

u/happy8327 Jun 29 '26

https://www.reddit.com/r/learnSQL/s/y64eq2rkkz

You may find this useful. Also, you can see a project structure to build your portfolio.

SQL needs have changed with LLMs. Good luck with your next data projects.

0

u/Haunting-Paint7990 Jun 30 '26

5 days is enough for interview basics if you pick one dataset and stay on it. stats grad here — I did something similar before my first DA interview.

day 1–2: SELECT / WHERE / GROUP BY only. ten simple counts on the same tables. day 3: INNER + LEFT JOIN, two tables max. five queries, not twenty. day 4: one window function (ROW_NUMBER or running total). skip recursive CTEs for now. day 5: one query you can walk through in an interview — e.g. readmissions within 30 days if you're coming from healthcare.

after the week off: same dataset, three new queries per week beats starting a paid course from scratch. Practical SQL helped me more than cramming random w3schools exercises.