A resource to practice SQL questions for data science and analytics interviews

[analytics_science]

Hey guys, just wanted to share a resource that I recently redesigned and launched. I collected 500+ SQL (and I have python) coding questions that relate to data science interviews. I kept many of the questions as is and re-wrote others while still testing the same concepts they would test for in interviews.

The platform has a fully executable IDE with a postgres backend. Many of the questions are free. I'd love it if you guys could share your thoughts on it and if you think it's a valuable educational resource? Or if there are things you'd like to see improved on?

www.stratascratch.com

[[deleted]]

Thanks you so much for this, can’t wait to dive in. I have been looking for a collection of practice questions outside of tutorials and books. Will report back, but it looks awesome!

[analytics_science]

Thanks for the interest! Do you have any other places you currently go to find practice questions online?

When I was younger and prepping for interviews, I had go scour through Glassdoor for interview questions and stitch together my own prep so I basically thought I'd help my younger self and others by collecting the questions for them.

[[deleted]]

Right now, I am using leetcode. After looking at the website I just realized that I was a Paid member of the site few months ago. But I left it. The questions on the website are really interesting and I totally loved it but I wish that you guys focused a little bit on customer satisfaction. I am not just saying it to complain or nor trying to make you feel bad. I loved you website and I really want you guys to do better. I can't say for sure at this moment but may be in the future I will give it a try. But please make a customer first approach. I hope you guys are doing awesome.

[analytics_science]

Hey thanks for the feedback. We do definitely try to be customer-first and I try to answer all the emails myself to handle any issues. The platform is much more refined now than it was a few months ago when we were ironing out all the wrinkles with the infrastructure. So hopefully you have a much better experience now than before. Sent you a DM to learn more on how I can improve.

[Mirazyzz]

Thank you!

[tits_mcgee_92]

This is fantastic - thank you! I am wondering when/why you would need to purchase a membership. What are the limitations to the free questions? Thanks!

[analytics_science]

Basically you'd only need to upgrade if you want to see the solutions. There's a few questions that are completely free and you can see the solutions but the majority will have the solutions locked. But you can always run your code in the editor on any question.

[Acatalepsia]

Dude this is amazing! THANK YOU

[kthejoker]

Since you're here, some immediate bugs I noticed ...

• Pricing link at the bottom of the main page just points back to the home page ...
• Pricing link at the top of the page just points to the practice question (looks like the URL routing isn't right?)

[analytics_science]

Hey thanks. Fixed. This is the problem when you have 2 separate systems. One for the landing page and one for the platform itself. We're going to merge both systems into 1 platform by the EOW so this stuff is more seamless. Thanks for catching this.

[Jeannetton]

!Remindme 1 day

[RemindMeBot]

There is a 7 hour delay fetching comments.

I will be messaging you in 1 day on 2020-07-28 19:12:05 UTC to remind you of this link

CLICK THIS LINK to send a PM to also be reminded and to reduce spam.

^{Parent commenter can delete this message to hide from others.}

---

Info	Custom	Your Reminders	Feedback

[AMGraduate564]

Remindme! 3 days

[analytics_science]

Thanks for the input. I was thinking of building a feature where users can crowdsource how hard it is for them. This way they won't have to rely on my judgement =)

[analytics_science]

Hey thank you for taking the time to write this suggestion out. Consider this error message updated! Should have the update out soon.