r/learnSQL • u/chiitose2512 • 2d ago
Where to practice SQL
Hi everyone, I recently learned SQL through websites and games online. Now that I feel more confident to practice on my own, I wanted to practice with datas I already have. Got a bit confused with where to practice them. Does SQL has its own 'tool' to use? Like how you use python in Jupyter, and R in Rstudio. Will Visual Studio Code works for it?
2
u/justintxdave 2d ago
Down load the free DBeaver Community Edition and use the SQLite database that comes with it.
2
1
u/datadriven_io 2d ago
I recommend actually just running your own Postgres database on your computer - it's very lightweight and performant. Practice ingesting your data to a new database+table, then querying the table
3
u/Tareng_Saller 1d ago
also try datadriven for sql practice problems once you have postgres running, the questions are actually good for building reps.
1
u/Speeeeedislife 1d ago
Lots of options, install postgresql locally or run from docker, if you're already using Python you can use duckdb to load CSV, parquet, etc and query with SQL. Just depends on your ultimate goals.
1
u/Available_Car_5222 1d ago
What is the name of the SQL game you used?
2
u/conor-robertson 1d ago
You should try QueryCase if you are interested in a gamified SQL learning experience!
1
u/chiitose2512 4h ago
sorry for the late replies but here's a few of them! not the most 'beginner' beginner friendly, but once you have some basics this can be fun!
1
u/pitifulchaity 19h ago
Agreed. SQLite is a great starting point. Later I moved to dbForge Studio because I wanted to practice against PostgreSQL and SQL Server as well without changing my workflow every time.
3
u/Pangaeax_ 1d ago
VS Code can work, but I’d probably start simpler.
For your own data, use SQLite with DB Browser or DBeaver first. If you want online practice, SQLBolt, HackerRank, DataLemur, StrataScratch, LeetCode SQL, and CompeteX are worth checking.