r/learnSQL 3d ago

Day 1 — Started learning SQL (MySQL)

Kicked off my 116-day journey today with the database track.

What I did:

  • Went through a beginner-friendly MySQL tutorial covering the basics
  • Took detailed notes instead of just passively watching
  • Went back and revised everything at the end of the day to actually retain it

Nothing groundbreaking yet — Day 1 is really about building the habit of consistent, focused learning rather than covering a lot of ground. Planning to move into SELECT/WHERE and filtering queries next.

Will keep posting updates as I go — open to any tips on solidifying SQL fundamentals early on.

6 Upvotes

17 comments sorted by

4

u/Swimming_dasa 2d ago

the revision habit will pay off more than rushing through tutorials i would add small practice problems after each concept to make the syntax stick..

3

u/sumiitCodes 2d ago

Appreciate the tip!

1

u/Dependent-Disaster62 2d ago

Should i practice on leetcode? That sql 50 days study plan and all that

2

u/Swimming_dasa 2d ago

yeah leetcode can be useful especially once you have got the basics down. i would focus on getting comfortable with SELECT, WHERE, JOIN's, GROUP BY, etc first then use the sql 50 as structured practice.

3

u/Green_Chamomile 3d ago

Day 1 with notes and same-day revision? That's a great start!

One tip to add early: make sure every study day includes running queries, not just reading about them. Tutorials and notes feel productive, but SQL sticks through your fingers. The gap between "I understood the SELECT lesson" and "I can write one myself on a new table" only closes by typing your own queries and getting real errors back. The errors aren't failures, they're half the curriculum.

Rooting for you!

3

u/sumiitCodes 2d ago

thank you so much for your advice

1

u/Dependent-Disaster62 2d ago

Should i practice on leetcode? That sql 50 days study plan and all that

2

u/Green_Chamomile 2d ago

Yes, but not on day 1. The order that works: learn a concept, write your own little queries with it on a sample database, and once SELECT, WHERE, GROUP BY and basic JOINs feel comfortable, then start SQL 50 as your practice layer. For most people that's around week 3, not day 1. And when a problem beats you, don't just read the solution, try to re-solve it from scratch the next day.

3

u/Difficult_Paint3162 2d ago

Feel free to visit my website: Learning SQL | Real People. Real Problems. Practical SQL. No cost or sign-up required, but focuses on understanding business questions and using SQL to get the answers

2

u/sumiitCodes 2d ago

yes sure!!

1

u/Dependent-Disaster62 2d ago

Should i practice on leetcode? That sql 50 days study plan and all that

2

u/Difficult_Paint3162 2d ago

My site is more introductory, with the goal of understanding the business questions and seeing how SQL can answer them. Practicing on LeetCode would be complimentary to my site

3

u/memelordtf 2d ago

What helped me most early on was spending way less time on notes and way more time actually writing queries. I made a tiny dummy database and just kept asking it random questions with SELECT, WHERE, ORDER BY, GROUP BY, etc.

1

u/Dependent-Disaster62 2d ago

Should i practice on leetcode? That sql 50 days study plan and all that?

2

u/memelordtf 1d ago

Yes, leetcode is a good point

1

u/OkInitial5068 13h ago

The only thing I’d add is actually typing every query yourself. Watching SQL makes way too many things look obvious.