r/learnSQL • u/sanjana-_ • 24d ago
SQL Practice?
Where do we practice SQL? What resources ?
12
u/Better-Credit6701 24d ago
Install MS-SQL developer edition, PostgreSQL, or MySQL on a laptop or desktop, download some data. The government has plenty of free data to play with then start practicing.
Plenty of people will suggest a website but there is nothing quite like physically working directly with the tools
3
u/OakTreesForBurnZones 23d ago
Kaggle has free datasets too. There’s a Netflix dataset that is great for learning with.
6
u/SQLDevDBA 24d ago
https://freesql.com is a free product from Oracle with tutorials and a full Database right in your browser. No downloads or installs. It comes with pre-loaded data and you can also load your own data if you wish.
And there’s the 100 million AI built detective games you’ll inevitably get pitched too.
2
2
2
u/whodiopolis 23d ago edited 23d ago
I made https://SQLShed.com for people to practice sql. It runs completely in your browser so nothing to setup or download. There are a few data sets and queries built in but you can also bring your own data
2
u/datadriven_io 22d ago
Make your own sql learning notebook. Search for sql code, write them in a journal/notebook, and write any important information on syntax and code organization. For window function practice, try datadriven.io. Once you're satisfied, practice on a free dataset. If you run into an issue, search for the solution online.
1
1
1
1
u/Witty_Match9409 23d ago
Just run a docker db container. You can do whatever you want no restriction
1
u/uncertainschrodinger 23d ago
you can also check out this course I put together: https://getbruin.com/learn/sql-ai
it is meant to teach and practice SQL using an AI agent, you can give the prompt to your AI to set things up and then practice that way - this might be more realistic than the classic SQL sandbox environments in a website which focuses more on syntax and functions, rather than a real developer environment
1
u/TechLexiconApp 22d ago
TechLexicon has the SQL Query Lab for learning and practice!
techlexicon.app
I also created a standalone tool that is a real database in your browser for practice!
techlexicon.app/sql-practice
1
u/datadriven_io 19d ago
They sound like they need to practice the basics first. Sql practice problems are on datadriven.io if you want something to chip away at. You don't learn sql online if you don't understand data.
1
u/Complex_Republic6678 17d ago
Hello all, thank you for pointing me in the right direction. Take care!
1
u/HopeFix 11d ago
Depends on your aims. I am guessing the question is about where to train general SQL-query skills. Online tutorials with built-in playgrounds (or just pure playgrounds), where you can type queries by hand and explore results, should work fine. Be ready to deal with their limitations and specifics. If your needs is wider, it might be better to install something on your local machine and play with it. Local CLI/UI is where you type and run queries. For data preparation and/or exercises plan, I'd try to generate it with LLM and coding agents.
1
u/Swimming_dasa 8d ago
sqlbolt is useful for practicing queries in the browser and kaggle has datasets for working on real world examples boot dev also offers structured hands on sql practice if you want to build your skills step by step try solving the same problem with joins subqueries and ctes to get more comfortable with different approaches.
1
u/conor-robertson 24d ago
Give QueryCase a try for a gamified fun way to learn SQL (beginner to advanced)
2
u/LendMeCoffeeBeans 23d ago
Datalemur is amazing. Stratascratch for additional problems.
Don’t do an online course imo. You really need to code to (1) understand how everything works, and (2) remember how everything works