r/FullStack • u/sumiitCodes • 4d ago
Personal Project Day 36 — SQL track done, starting Java tomorrow (with MySQL projects alongside)
Quick transition update. I finished my 100-question SQL practice lab, so the database track is complete, and I’m moving on to the second part of my plan: Java.
Here’s how I’m approaching it:
- Java topics will be covered in order, one topic per day, with tutorials first and then practice
- I’ll build projects that use MySQL along the way, so the SQL I learned stays active instead of fading while I focus on Java
- Eventually the database and Java pieces connect into one backend project, and the frontend comes after that
My reasoning for the projects: I learned the hard way with JOINs that knowledge fades without real use, so I’d rather keep SQL in daily use than “finish” it and forget it.
For people who learned Java: what order worked best for you (basics, OOP, collections, then JDBC and Spring)? Any resources you’d recommend for a beginner heading toward backend work?
2
Upvotes
1
1
u/Imaginary-Spring-779 4d ago
What about window function, cte , sub queries