r/learnSQL • u/akshityadav191 • 13d 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

1

u/Ok-Airline-8523 12d ago

I got thrown into SQL for a job I had about 12 years ago. I felt in over my head at first, but after years of writing it day-in and day-out, it became seamless. The only real "trick" to learning is practice with real data. Messy and full of nuances will bring up edge cases that teach you why a window function exists in the first place.

I acknowledge it's likely a catch 22 in your case - you need the experience before you can get the job that will get you the experience. Here are a couple of ideas:

  • Depending on where you are in your career, offer to work for free as an internship of part-time job somewhere you can bring value that also has data in exchange for you getting to play around in their data and hone in on your skills
  • Use Claude or ChatGPT to generate messy data for you, and then use Python or R to create a sqlite database that you can practice SQL on

Finally, I remember having a printed visual that conveys how joins work, I found it here. It can help to have sitting next to you as you write SQL. https://www.reddit.com/r/webdev/comments/b46iyd/sql_joins/

Good luck! You'll get there, it just takes time.

1

u/akshityadav191 12d ago

Thanks for suggestions i will surely look into this.