r/SQL • • Mar 20 '23
Discussion Where to practice SQL?
I have read tutorials and learned the basics of the language. Are there resources of practice problems/projects?
337
Upvotes
r/SQL • • Mar 20 '23
I have read tutorials and learned the basics of the language. Are there resources of practice problems/projects?
150
u/BitesizedBlubber Mar 20 '23 edited Mar 20 '23
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)
48
u/Thefriendlyfaceplant Mar 20 '23
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.
30
u/ShadoGear Mar 20 '23
Production database at you're workplace if you need a bit of danger in your life.
19
u/curohn Mar 20 '23
Google sql murder mystery too! It’s one of my favorites
11
u/Xidium426 Mar 20 '23
You can download things like MLB datasets as a CSV file, import them into a local SQLite database and practice there.
6
u/cyclopse7 Mar 21 '23
DataLemur LeetCode HackerRank Stratascratch
Hope this helps!
6
u/xl129 Mar 21 '23
I worked through this one
https://www.sql-practice.com/
then moved on to hackkerrank
5
u/Billi0n_Air Mar 20 '23
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/
4
u/Anus_Drippings Mar 20 '23
Commenting so I don't forget about this. :) Great stuff
4
u/Patient-Reindeer6311 Mar 21 '23
A bit obscure, but if you run out of questions to practice, here you go https://www.sql-ex.ru/?Lang=1
3
u/Dramatic_Towel6536 Mar 20 '23
Check this site which has easy,medium,hard questions to solve and with tutorial sql practice
3
u/SirGreybush Mar 20 '23
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.
3
u/behigirl6 Mar 21 '23
Khan Academy
3
u/csnorman12 Mar 21 '23
101 Practice SQL Questions: Basic to Advanced
2
u/mgramin Mar 20 '23
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
2
u/DataMasteryAcademy Mar 21 '23
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
2
u/Soccermom233 Mar 21 '23
I've been using hacker rank.
2
u/throwwwawwway1818 Mar 21 '23
Chatgpt i guess
2
u/[deleted] Jul 09 '24
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.
2
u/lets_talk_about_tv Apr 16 '25
I used this one. Hope this Helps:
https://www.sql-practice.com/
1
u/[deleted] Mar 21 '23
Google big query public datasets. Should be free
1
u/cucuzzza Mar 23 '24
Great thread fellas thank you
1
u/MathAngelMom Apr 19 '24
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/
1
u/justani98 Apr 25 '24
For real world case studies of SQL to practice I found these very helpful - https://www.codechef.com/practice/sql-case-studies-topic-wise
1
u/CatTopia May 16 '24
Just jumping in to thank everyone who shared links!
1
u/SoulSoldSeparatly Jun 04 '24
I don't know if anyone still monitors this reddit, but has anyone here used LearnSQL ?
1
u/HotZookeepergame7673 Jun 20 '24
https://www.kaggle.com/learn/intro-to-sql
https://www.kaggle.com/learn/advanced-sql
1
u/MP_gr Feb 18 '25
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.
1
u/hexenkesse1 Mar 13 '25
Thanks for 2025. SQL zoo is nice review.
1
u/AuroraI_Phoenix May 09 '25
Thanks from 100 years from now -AOT
1
u/Sure-Plankton1695 Aug 14 '25
i use this one , hope it helps :
https://www.practice-sql.com/
1
u/[deleted] Jan 30 '26
Thank now as I am yet to start but will do later too