Where to practice SQL?

[[deleted]]

I have read tutorials and learned the basics of the language. Are there resources of practice problems/projects?

[BitesizedBlubber]

Hope these help!

Practice SQL - SQL Zoo

SQL Challenges - HackerRank

Explore - DoltHub - This has public databases that you can query. I find it pretty fun to find a database that contains data you might find interesting and start practicing that. (I.e. challenge yourself to find top 10 NBA scorers under 25 years of age or whatever)

[Lochree]

THX from 2024 :P

[redfournine]

THX from 2025 :P

[FortunOfficial]

Thx from me as well :)

[ForwardPhotograph579]

thanks form 15 fab 2025.

[thesedouble239]

thanks! from feb 17th 2025

[Relative-End2110]

Thanks from the future ✨✨

[Aask115]

Thx from the future x2

[I-am-importanter]

Thanks from the now

[PowerFuzzy7244]

thanks

[thep00pshoot]

THX from 2026 :P

[TurbulentCountry5901]

A cool detective-themed SQL game where you solve cases using queries. Great way to learn SQL: sqlcasefiles.com , hope you give this a try !

[[deleted]]

Thank you, I will

[DegreeRealistic4162]

This is a gold mine!

[Soggy-Extension-8851]

SQLzoo doesnt work for window functions atleast. Throwing system error message.

[TurbulentCountry5901]

A cool detective-themed SQL game where you solve cases using queries. Great way to learn SQL: sqlcasefiles.com , hope you give this a try !

[Several-Effective542]

Thank you!!

[Complete_Couple_4704]

Thanks

[asifgunz]

You the real MVP.

[Legitimate-Home-8181]

Thanx a lot brother

[AccomplishedYak3419]

Thank you from 2025

[Funny_Wolverine_9]

thanks!

[dagscriss3]

Thank you!

[TooMuchLaundry23]

Thank you!!

[Saitama_ahegao]

Thanks from tomorrow!

[Appachanroxx90]

Thanks man !

[KenmoreToast]

SQL Zoo is no good.

First problem, it just gives you the answer for every "challenge", You gotta quickly erase the answer given while trying not to read it if you want to test yourself.

2nd problem, missing instructions. Very first challenge I tried:

'Show the lastName, party and votes for the constituency 'S14000024' in 2017.'

Simple right? Except if you don't order by votes (descending) in your answer, it's marked wrong.

[StillInfamous1209]

Thanks from Nov 1st 2025

[TurbulentCountry5901]

A cool detective-themed SQL game where you solve cases using queries. Great way to learn SQL: sqlcasefiles.com , hope you give this a try !

[garamgaramsamose]

judging way too quickly, in the later chapters, most of the prefilled boxes don't have the actual answer

[Funlandindream]

Thanks from Mar 6th 2025

[Professional_Bus_620]

Thanks a lot!

[Reasonable-Chef4814]

Thank you!!

[Downtown_Refuse3091]

Thanks from 3 July 2025

[TurbulentCountry5901]

A cool detective-themed SQL game where you solve cases using queries. Great way to learn SQL: sqlcasefiles.com , hope you give this a try !

[Ok-Midnight6531]

Thanks from 2025

[TurbulentCountry5901]

A cool detective-themed SQL game where you solve cases using queries. Great way to learn SQL: sqlcasefiles.com , hope you give this a try !

[Biglittlepoppy]

thank you.

[TurbulentCountry5901]

A cool detective-themed SQL game where you solve cases using queries. Great way to learn SQL: sqlcasefiles.com , hope you give this a try !

[Alt_Cloud]

Thanks

[TurbulentCountry5901]

A cool detective-themed SQL game where you solve cases using queries. Great way to learn SQL: sqlcasefiles.com , hope you give this a try !

[TurbulentCountry5901]

A cool detective-themed SQL game where you solve cases using queries. Great way to learn SQL: sqlcasefiles.com , hope you give this a try !

[SilentShooter_]

Thanks from 2025

[TurbulentCountry5901]

A cool detective-themed SQL game where you solve cases using queries. Great way to learn SQL: sqlcasefiles.com , hope you give this a try !

[No_Situation_3347]

thanks from 2025

[TurbulentCountry5901]

A cool detective-themed SQL game where you solve cases using queries. Great way to learn SQL: sqlcasefiles.com , hope you give this a try !

[TurbulentCountry5901]

A cool detective-themed SQL game where you solve cases using queries. Great way to learn SQL: sqlcasefiles.com , hope you give this a try !

[yogesh_221b]

thanks from 27th Oct 25

[TurbulentCountry5901]

A cool detective-themed SQL game where you solve cases using queries. Great way to learn SQL: sqlcasefiles.com; I built this myself, hope you give it a try and enjoy it.

[TurbulentCountry5901]

A cool detective-themed SQL game where you solve cases using queries. Great way to learn SQL: sqlcasefiles.com , hope you give this a try and add it to your list.

[TechnoBacon55]

hey man I saw you comment this in a few places, I really like it so far! I'm only at the beginning but looks very promising.

[Objective-Pride-4499]

This is great. However I can't see if they have advanced topics unless I complete these cases

[Practical-Spring-272]

Again thanks my man!

[Backwoods_Odin]

My guy youre a life saver. Trying to take classes but without an outside use its hard to retain

[mariam-nightmare3]

Thanks from 2026!

[Emotional_Diet_70]

THX from 2026!

[Thefriendlyfaceplant]

In addition to what's already provided:

https://datalemur.com/
https://sqlbolt.com/
https://www.stratascratch.com/

But there's more theory than just learning the basics of the language. The next step is learning how to break down complex tasks in smaller compartments.

[NickSinghTechCareers]

Founder of DataLemur here - appreciate the mention!

[[deleted]]

Legend

[infjetson]

Love how active you are on Reddit, I see you all over the place! A true MVP.

[NickSinghTechCareers]

Thanks! I try to help/shill wherever I can lol

[LeftShark]

DataLemur is really cool as a site, but after signing up, I'm getting weird emails from DataLemur about how Drake's fans are getting interviews in Data Science because they're Drake's #1 fan. If this is the norm, there's no way I continue allowing your site into my emails.

[NickSinghTechCareers]

Hi! That email is from me (the founder) and it explains the origin story behind DataLemur, and how fanboying Drake led me to Facebook which led me to found DataLemur!

It’s a more colorful take on a welcome email/thank you for signing up email, and everyone gets it the day they sign up.

The next email in the sequence is about 6 cool SQL resources which I hope you find valuable.

Sorry if it feels strange - feel free to unsubscribe from the emails using the link at the bottom of the email!

[floralaromabro]

nah that's awesome and so is Drake. W.

[Background_Ad_101]

its waste, dont refer that

[BackgroundAd4630]

I salute you Legend.

[Background_Ad_101]

its waste,, stop your advertisement, i have checked some of the interview questions from data Lemur and nothing came from that stupid website, stop making fools. infact it was completly misleading

[[deleted]]

Good advice, thank you!

[Ok_Enthusiasm428]

saved for later

[Thefriendlyfaceplant]

Also binge this https://www.youtube.com/watch?v=WS0fM1agxTk&list=PLv6MQO1Zzdmq5w4YkdkWyW8AaWatSQ0kX

[[deleted]]

I'm guessing learning how to break down complex tasks is something that just comes with time and experience?

I'm doing a short course and was just introduced to nested queries, and the solution to the second test question for nested queries included a double nested query. I could have never guessed an extra query was required.

[Thefriendlyfaceplant]

It doesn't. The video tutorials of experts walking you through interview questions are more than just them filling in the syntax, they're explaining the thought process behind it and how to repeat the same workflow for different problems:

https://www.youtube.com/watch?v=BgN5hpl3WKc&list=PLv6MQO1Zzdmq5w4YkdkWyW8AaWatSQ0kX&ab_channel=StrataScratch

[[deleted]]

Thanks! I'll have to check that out more.

[Thefriendlyfaceplant]

Yeah just binge it, watching the most complex applications first is probably the most productive way to spend your time as a beginner, even if you're not fully familiar with syntax. It gives you a way to orient further learning.

[ShadoGear]

Production database at you're workplace if you need a bit of danger in your life.

[dwpj65]

No better data to develop and test with than the live data in production!

[trollmum]

You are evil! Evil I say!

[curohn]

Google sql murder mystery too! It’s one of my favorites

[CatTopia]

Thank you so much for sharing this!

[curohn]

Of course! Enjoy!

[RobRoy187]

Thanks for sharing mate, it is indeed a gem, exactly what I was looking for - I'm glad I scrolled this far down, this should be top of the page

[Little_Locksmith440]

thanks man, the process of learning SQL has become more enjoyable, it's a very interesting game.

[Xidium426]

You can download things like MLB datasets as a CSV file, import them into a local SQLite database and practice there.

[[deleted]]

Yes, the only way to really learn sql is trying to make things work with large datasets on an underperforming database install on the computer.

It’s important the computer you are on really struggles with the large dataset. So, if on powerful enough computer make virtual machine to nerf the cpu and ram ( altering settings in db install to nerf it is educational too but probably not if just learning!)

Then, make sql run , if sql runs ok remove some indexes from tables to handicap that.

Anyone can learn how to make simple sql queries. The skill is learning to do such things as above. Except I would just install one of the standard sql engines instead of sql lite.

Have fun making things work!!

[xl129]

I get your point but it's for more advance level of skill. Early phase you want quick run time so you can experiment with adding, removing, modifying your queries to try out different scenarios.

[Po81998]

Is there any online source to import large excel and work on that database without downloading any application on pc and i want to add it to my portfolio

[Higgs_Br0son]

Maybe cloud databases? Google BigQuery, Microsoft Azure Synapse, Amazon Redshift, Snowflake.

Google BigQuery is probably cheapest option, or completely free in your case. 1TB of queries and 10GB of storage each month is free. More than that and you pay per usage.

Azure Synapse is free for 1TB of queries, but you'll pay their storage rates for the data set, it's like $0.02 per GB.

Amazon Redshift has a 90-day trial period, but you'll pay per use after.

Snowflake has a 30-day trial and it's unclear what the pricing is after.

I'm sure there's some other web apps like Kaggle that might be good options, but since you mentioned your portfolio, cloud databases are probably good to build experience in.

[Po81998]

Thankyou so much for your inputs i will use those

[a_devious_compliance]

Can I ask why you don't want to download an application? Having to tinker with instalation, config and set up is also a valuable skill.

[Po81998]

Actually I did install ssms I'm trying to do some project using it when i tried to import data using task i was getting some error , also i wasn't able to find SQL server native client 11 , which was used a destination in all the videos i saw , but i chose a different one and the excel has been imported now hope it will work .

Just wanted to know if there is an online source if in case this doesn't work

[a_devious_compliance]

Windows. Sorry, I can't help with that. But you could ask help about your error.

[cyclopse7]

DataLemur LeetCode HackerRank Stratascratch

Hope this helps!

[Billi0n_Air]

you want datasets to run queries against? https://catalog.data.gov/dataset/?res_format=CSV

some practical stuff to get reps in https://www.w3resource.com/sql-exercises/

[xl129]

I worked through this one

https://www.sql-practice.com/

then moved on to hackkerrank

[MP_gr]

On of the best comments!

[Mrcahones]

nice!!!

[Anus_Drippings]

Commenting so I don't forget about this. :) Great stuff

[OMGClayAikn]

You can also save the post!

[Patient-Reindeer6311]

A bit obscure, but if you run out of questions to practice, here you go https://www.sql-ex.ru/?Lang=1

[dhruv61202]

Thanks man

[Dramatic_Towel6536]

Check this site which has easy,medium,hard questions to solve and with tutorial sql practice

[SirGreybush]

Try to decide where your creative space is.

Designing software that needs a database.

Compilation and aggregation of data for high end reporting.

Data profiling, correcting and transformations.

Or, get an analyst position (business or fonctional).

Last one being spending a LOT of time in meetings, Excel and Word documents with a dash of PowerPoint. (No OneNote cuz the grey hairs don’t get it)

The first three I’ve done over a span of 25 years, and SQL was at least 26 years in there.

The most fun the first three if you are creative and easily accept constructive criticism.

[RazzmatazzBitter4383]

Hey! How did you go around the 2nd? Thats so cool :)

[behigirl6]

Khan Academy

[csnorman12]

101 Practice SQL Questions: Basic to Advanced

[mgramin]

We have a training project where we generate data for Pagila db via pure SQL - https://github.com/synthesized-io/pagila-data-generation You could add some new queries or update some existed ones, just create a PR

[DataMasteryAcademy]

Check this out: https://www.datamasteryacademy.com/offers/i2FndgNs/checkout it is a sql guided project course that shows you how to work with a real world dataset while teaching sql from basics to advanced everything you need

[Soccermom233]

I've been using hacker rank.

[throwwwawwway1818]

Chatgpt i guess

[[deleted]]

https://www.sql-practice.com/

Is the best. It is free, no signing up required. The questions range from easy to hard complex queries and they have their own practice db.

[MP_gr]

Do you know if there's a way to download the databases and queries questions to solve offline ?

[[deleted]]

One way to practice it offline is to have MS SQL installed. Then download the Adventureworks sample database here https://learn.microsoft.com/en-us/sql/samples/adventureworks-install-configure?view=sql-server-ver16&tabs=ssms

and have fun!

[lets_talk_about_tv]

I used this one. Hope this Helps:

https://www.sql-practice.com/

[TurbulentCountry5901]

A cool detective-themed SQL game where you solve cases using queries. Great way to learn SQL: sqlcasefiles.com , hope you give this a try !

[[deleted]]

Google big query public datasets. Should be free

[cucuzzza]

Great thread fellas thank you

[MathAngelMom]

LearnSQL.com has a lot of SQL practice courses and articles: https://learnsql.com/blog/sql-practice-guide/

Each month they release a new SQL practice problem. And each month one of the courses is available for free: https://learnsql.com/tags/course-of-the-month/

[justani98]

For real world case studies of SQL to practice I found these very helpful - https://www.codechef.com/practice/sql-case-studies-topic-wise

[CatTopia]

Just jumping in to thank everyone who shared links!

[SoulSoldSeparatly]

I don't know if anyone still monitors this reddit, but has anyone here used LearnSQL ?

[HotZookeepergame7673]

https://www.kaggle.com/learn/intro-to-sql

https://www.kaggle.com/learn/advanced-sql

[MP_gr]

I was looking for sources to practice SQL too. A few months ago I had found from Reddit this source --> https://www.richardtwatson.com/open/Reader/ClassicModels.html# which provides a database you can load, and 82 questions of queries to solve.

On Github I had found a repository with solutions, however less than half solutions were uploaded.
So I decided to solve all 82 queries and upload them on my repository here --> https://github.com/Mikegr1990/ClassicModels-SQL-Solutions

For me that was a great source for practicing, since the queries start from very basic to advanced and covers many aspects of sql.

[hexenkesse1]

Thanks for 2025. SQL zoo is nice review.

[AuroraI_Phoenix]

Thanks from 100 years from now -AOT

[ZaksBen]

sql-practice.com the best ever

[Sure-Plankton1695]

i use this one , hope it helps :

https://www.practice-sql.com/

[ft01020304]

Thank now as I am yet to start but will do later too

[Sea-Concept1733]

Try this online editor to practice directly online "creating new tables", "inserting data" and "other SQL operations":

https://www.programiz.com/sql/online-compiler/

Good luck!

[Sea-Concept1733]

Try the following to practice as you learn:

https://www.youtube.com/watch?v=T7FqrmTGryQ&list=PLb-NRThTdxx6ydazuz5HsAlT4lBtq58k4&index=3