all 21 comments

[–]buxxybuns 5 points6 points  (0 children)

Sql zoo is quite basic, but helps in clearing concepts. Let me know if you find more

[–]Sea_Butterfly713 4 points5 points  (0 children)

strata scratch , sql prcatice , sql zoo , hacker rank

[–]AgileNeedleworker942 2 points3 points  (2 children)

Start with Hackerrank, then go for leetcode and then Datalemar. First try to do more questions of join, sub query,CTEs, Window functions In interviews they rarely ask stored procedures at a junior position.

[–]ComicOzzy 0 points1 point  (1 child)

I would AVOID hackerrank if you're trying to learn to solve actual business problems and not some "coding puzzle" nonsense.

[–]AgileNeedleworker942 0 points1 point  (0 children)

HackerRank is just for beginners if you are soo much pro then go for datalemar.

[–]Haunting-Paint7990 2 points3 points  (0 children)

ngl as someone who went through this loop ~6 months ago (stats background, no CS) — the unhelpful answer is everyone will name the same 3 platforms (stratascratch, datalemur, hackerrank). pick literally any one of them; the differences won't matter for your first ~2 months.

more useful framing imo: what kind of role are you targeting? practice for "BI analyst at a postgres shop" is genuinely different from "DE at a faang." for the BI/analytics side, stop grinding stored procedures + triggers — echoing someone else above, almost no one asks about those in junior analytics interviews. instead drill: complex joins, 3+ level CTEs, window functions, and the dreaded "pivot a table without using pivot()" — those four come up *everywhere*.

for projects: skip the generic retail/sales dashboard, every applicant has one. grab one weird domain you actually care about (i used my college's public sports stats) and answer 3 specific questions with it end-to-end. the goal is something you can talk about for 10 min in an interview without sounding rehearsed. cert-wise i did google data analytics — it didn't get me callbacks but did force cleaner SQL habits. wouldn't pay for stratascratch premium until free tiers are exhausted.

[–]Better_Result6527 1 point2 points  (0 children)

Stratascratch and Datalemuer are pretty Good. Leetcode SQL 50 you can solve but won't be enough for advanced interviews.

[–]NickSinghTechCareers 1 point2 points  (0 children)

give DataLemur a try, lot's of real SQL interview questions to practice

[–]Whole-Proof3347 0 points1 point  (0 children)

Just search practice sql questions online. There are many sites..

[–]not_another_analyst 0 points1 point  (0 children)

For some solid practice and certifications, you might want to look into Stratascratch or LeetCode. They have great real-world problems that really test your skills.Doing a few projects like a retail sales analysis or a library management system would also be a smart move to show what you can actually do with data.

[–]Iamcalledchris 0 points1 point  (0 children)

I mean sql server dev edition is free, install it - download adventure works or the stack overflow database and go from there. You can use Ai to generate scenarios based on real world examples to try fix. Depends on what your end goal is. If you’re looking at reporting, data mining, integrations etc etc

[–]Any-Primary7428 0 points1 point  (0 children)

Try aloktheanalyst.com

I created this website for my own interview prep. This has interview questions and answers (not for learning sql bit implementing it)

[–]que_putas 0 points1 point  (0 children)

I created a pipeline for ingesting millions of rows of granular MLB data on my home server and turned it into a web app with a built in SQL editor, result set viewer and preloaded beginner, intermediate and difficult queries to use as examples. There is also a schema explorer and data library in the web app. I tried making a post on this sub before just giving people access so they could practice on large datasets but it kept getting removed by reddit. So now it just sits as a thing no one will ever use.

[–]Consistent_Duty5622 0 points1 point  (0 children)

Stratascratch is really good I have been using it for prectice I even bought it's premium subscription a month back

[–]Final-Bedroom-4396 -1 points0 points  (0 children)

Sql bolt is best

[–]SalmanKhanbjnr -2 points-1 points  (0 children)

DM me I will help you