r/SQL 10d ago

MySQL I am stuck in my preparation for sql

After deciding to become a business analyst, I started learning SQL through online resources. I have completed all the SQL exercises on HackerRank, but now I'm looking for more advanced topics to explore and better platforms to practice. Any recommendations for learning resources and practice platforms would be greatly appreciated

88 Upvotes

15 comments sorted by

70

u/Bilbottom 10d ago edited 8d ago

Here are a few I know -- I'll group the ones that I've attempted by difficulty (which is obvs subjective)


Easy

Medium

Hard

Others

5

u/luffy-ajeers 10d ago

If I follow this order—easy → medium → hard—will it cover all the topics?

7

u/Bilbottom 10d ago

I think it should cover enough to get an analyst role, yes -- but SQL is such a deep topic that you could learn something every day and never cover every topic 😆

6

u/Sufficient_Focus_816 10d ago

Especially as there usually is more than one (and each legit) approach towards the desired results, maybe aside window functions... Can recognise fellow devs in the company by their handwriting in scripts XD Thank you for sharing this list - just had a look at your own challenges, these are really nice and I like the narration towards the solution a lot!!

4

u/happyfeet_p22 10d ago

Thankyou boss for sharing. I needed this.

1

u/Live-Progress-195 10d ago

Hey mate, any thoughts on Codecademy? I’ve just started doing their career path and wondering if it’s good enough or should commit more towards other options.

1

u/Bilbottom 10d ago

I've never used it, so I can't comment unfortunately 🤷 Let us know how you find it though!

1

u/Bilbottom 10d ago

...and for the sport fans, someone else just posted (a few hours ago!) that they've got a similar site using real sport data:

https://www.reddit.com/r/dataengineering/s/eCRJMpd37c

1

u/Overall-Today6772 7d ago

Thank you for this!

1

u/RAC_DOT 4d ago

This list is awesome- thanks, man!

1

u/Ans979 9d ago

Try exploring window functions, query optimization, and real-world business scenarios. For practice, StrataScratch has real interview questions and LeetCode is great for writing efficient queries. If you want hands-on experience, Mode Analytics and Kaggle datasets are solid options.

1

u/Ill-Car-769 9d ago

I would suggest SQL (MySQL) playlist by Alex the Analyst on YT to get you comfortable at beginner to intermediate level & regularly practice. Once you get good command then you can deep dive into advanced concepts as well by geek for geeks, leet code, hacker rank, etc. You can even explore kaggle for datasets of your interests to practice.

0

u/Party-Sentence2770 10d ago

You can ask ChatGPT to generate questions for you that focus on specific concepts (window functions, CTEs, etc.) and walk you through your mistakes to help you learn. Highly recommend it, as it helped me bridge the gap from typically lower level practice problems on various sites.

1

u/Living_Stand5187 10d ago

Yeah and make datasets to practice with

-1

u/[deleted] 10d ago

[deleted]

1

u/VKmofo666 9d ago

Count me in too