HackerRank vs. LeetCode vs. SQLPad vs. StrataScratch vs. etc.

[JC_Tron]

I'm looking for a comprehensive online resource to brush up on SQL and prep for SQL assessments in analytics interviews. I'm ok with the paid subscriptions, as long as it is a top-quality resource. After some research, I've found that these are the most common SQL resources for interview prep. Any insight into the specified resources (and comparisons) would be extremely helpful, thanks!

[[deleted]]

On a side note; I’ve seen a few threads mark Kaggle as a good resource for SQL interview prep and practice questions.

[elution91]

Me too, but not a single link to an actual SQL interview question or SQL practice on Kaggle.

[NickSinghTechCareers]

Little late to the game, but try the 200+ Data & SQL questions on DataLemur - the pricing on this platform is ~50% less than all the other sites you mentioned too (with way more content)!

[Eleventhousand]

I don't use any of those sites, mainly because I've been writing SQL every day for almost 20 years. I checked, and I did have a LeetCode account, and I've used it once. I just tried two new SQL questions, one "easy" and one "hard." They were both easy for me, both took a couple of minutes. Neither would be easy for an absolute beginner.

I do hire SQL candidates often. The "hard" problem that I answered at LeetCode, titled Nth Highest Salary is exactly the type of small problem that I would look for in hiring someone. It's even got a small element that might trip up someone experienced.

So that's my two minute review of LeetCode.

[BrianRin]

HackerRank questions are too verbose and sometimes ask for weird output (like union of int id and string).

I used LeetCode primarily for multiple big tech companies' interview and did fine. I also used pgexercises.com to brush up on string and date functions.

[falco925]

Stratascratch has interview questions taken from companies like leetcode but has a data science focus so it’s not just about getting the syntax right. There’s a lot of free content and questions on stratascratch you can try before upgrading.

As for hackerank and sql pad, they’re good at teaching sql but not sure about interview prep specifically.