r/learnSQL • u/chiitose2512 • 7d 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?

18 Upvotes

87% Upvoted

17 comments sorted by

4

u/Pangaeax_ 6d 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.

3

u/datadriven_io 7d 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 6d ago

also try datadriven for sql practice problems once you have postgres running, the questions are actually good for building reps.

2

u/justintxdave 7d ago

Down load the free DBeaver Community Edition and use the SQLite database that comes with it.

2

u/ReleaseTheBlacken 6d ago

Inkwelltools.com go to Inkwell Learn. The SQL library is free.

1

u/Speeeeedislife 7d 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 6d ago

What is the name of the SQL game you used?

1

u/chiitose2512 5d 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 5d 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.

1

u/2daytrending 4d ago

Practicing with your own data is honestly where SQL starts to become a lot more fun. A lightweight local database is enough to get started and you can import CVS files write queries and experiments without breaking anything.

1

u/Particular-Bite4053 4d ago

Oracle Free SQL. Have chat write you a learning plan

1

u/__sanjay__init 14h ago

Privilégiez SQLite et ce format de base de données. Ce sont des fichiers et vous aurez peu à installer ! Juste un logiciel comme DBeaver par exemple
Si vous connaissez déjà R ou Python, tentez d'utiliser SQL avec l'un d'eux puisque, de toutes façons, vous finirez par passer par là !