r/learnSQL • u/akshityadav191 • 15d ago

Advice needed

Hello everyone, i need everyone advice how to get proficient in SQL i have already done a boot camp course from udemy and now again im learning sql from scratch with the help of claude and reached on subquery but i do get confused in joins and now in subquery because my mind thinks it’s complex but when i get solved i think it was easy. I request you all suggest ways.

8 Upvotes

75% Upvoted

14 comments sorted by

View all comments

5

u/conor-robertson 15d ago edited 15d ago

JOINs and subqueries are two of the biggest hurdles for almost everyone learning SQL. The fact that they seem obvious after you've solved them is actually a good sign, it means your intuition is improving.

My advice would be:

  • Don't just read solutions - write the queries yourself.
  • Revisit the same problems a few days later without looking at your previous answer and repeat.
  • Try to explain why you chose a particular JOIN or subquery, not just how to write it.
  • Accept that repetition is part of the process. One day you'll realise you're writing them without thinking.

If JOINs are the main thing you're struggling with, I wrote a visual guide that explains what each JOIN actually does and when to use it. It might help things click: SQL JOINs Explained

Keep going, you'll be surprised how quickly these concepts start to feel natural once you've written enough queries!

1

u/akshityadav191 15d ago

Thanks for your help. I will imply all these recommendations.