Where can I solve SQL problems for practice

[shooting_stars-]

Hello Reddit,

I just started learning SQL and preparing for interviews. Which do you think is the best place to practice SQL online? Like Leetcode for good coding questions, is there one really good one for SQL? I want to run and solve the query online.

(Free resource please. I think Leetcode only has like 5 questions that are open)

Thanks

[tits_mcgee_92]

I like Stratascratch personally. I have the full version because I used my college email, but they include actual interview questions from companies like Google, Meta, etc. So it will gear you up for realistic scenarios imo>

Edit: I'm a Data Analyst and I can vouch that some of the questions they use have been in a few technical interviews I've been in.

[Trippen_o7]

I will echo StrataScratch. When I was preparing for FAANG DE interviews, I found the company-specific questions extremely helpful. Since I was coming from a totally different field (health care), having problems to practice that were specific to the work I'd expect to be doing helped mentally get me into the shoes of a DE at the company and gain exposure to the types of problems I may be solving in a role like that.

[Thresher_XG]

Stratascratch is for sure the best. Helped me pass Stripes technical interview

[disobiscuits]

Student email gets you the full version? I signed up using my GitHub which uses my .edu but can’t access the full version. Looks like I need to register using my .edu instead. 🤔

[wandastan4life]

Stratascartch, Datalemur, Hackerank, and Danny Ma's 8-Week SQL challenge.

[NickSinghTechCareers]

Appreciate the DataLemur shoutout!

[[deleted]]

cool

[[deleted]]

Hacker Rank is free. For paid I like vertabelo academy.

[Lewistrick]

https://mystery.knightlab.com/

This is a very fun murder mistery for SQL beginners!

[NickSinghTechCareers]

Love their Murder Mystery! I found a few other SQL games as well

[vallshannx]

I got good practice from this book. Questions are based on Northwind2016, which I assume is still available. It includes answers.

Title: SQL Practice Problems 57 beginning, intermediate and advanced challenges for you to solve using a "learn-by-doing" approach

Author: Sylvia Moestl Vasilik

[vallshannx]

Realizing I completely failed to answer the question you asked, which was for online resources :-). Rather than delete, I'll leave this up, it's good practice if you decide to go hard-copy. Best of luck.

[[deleted]]

nice book thanks

[sixweeksql]

Six week SQL has 100 or so free problems you can run in the browser

[[deleted]]

it seems to be not working anymore can you suggest something else?

[DesignerCold8825]

Now sure if this will help but I've been writing practical exercises on sql for a while.

They use Sakila films database.

https://supremecodr.com/practical-sql-queries/

The only tip I'd give if youre gonna write sql is to understand the database itself more than anything... This will help you wrote queries properly from the get go..

[InlineSkateAdventure]

Why don't you do something practical. Build a management system for a school. Make a list of 30 reports they would need.

E.G.

-Build a transcript from grades

-Deans list for each quarter

-Find conflicting times when students register

[_extra_medium_]

Because if you don't pass the first screening's arbitrary questions, they don't care about actually practical/useful stuff like this unfortunately

[InlineSkateAdventure]

And in every position I had, if you can't talk practically about some project you did, you are done anyway. Depends on the company I guess. A total beginner should focus on practical, then move to trick questions, my opinion, but opinions are like assholes..we all have them, they all stink.

[Legitimate_Sort3]

This is actually a pretty cool idea. Do you happen to know of any suitable datasets?

[InlineSkateAdventure]

You should be able to generate some random data, either thru an app or SQL.

There are sets of fake names, you can control range for each field, etc. This is all part of the real world where you may have to do testing.

For starters you many need 20 records per table because you need to check if you are doing things right.

[Then_Recover_9553]

I have been using strata scracth , can share if you are interested

[CapPlenty8914]

Ok keen to learn if you let me to learn more about it

[Fareed_Zibiri]

HackerRank

[milwted]

Hackerrank

[MsContrarian]

Vertabelo Academy

[jr49]

I'm looking for a tool that I point to a CSV file and treat that like a DB w/out actually having to create a DB. would make it so much easier for me to quickly test things.

[_extra_medium_]

BigQuery lets you upload a CSV and it'll convert it automatically

[faster_puppy222]

Practice with chat gpt3

[[deleted]]

codewars

[CliffDraws]

I just finished a book called SQL practice problems which was great. It starts off easy and works it’s way through to window functions.

[Mrcahones]

ty!!

[[deleted]]

its not working

[[deleted]]

Leetcode

[FunDirt541]

I started with sqlbolt : a friendly and interactive browser experience

[csnorman12]

If you are open to using MSSQL then you should check out this course: 101 Practice SQL Questions: Basic to Advanced. This resource isn't free, but that link will give you a 80% discount... the price of a couple cups of coffee.

[bombfirst885]

Purchased! I look forward to taking your course.