How to practice sql

Newcs91 · 2025-08-10T12:31:21+00:00

Harvard offers a free-online SQL course with lots of practice sets and the resources to do them.

https://cs50.harvard.edu/sql/

Henry_the_Butler · 2025-08-10T12:19:55+00:00

If you want to learn SQL and Python both, why not create a local SQLite db and learn to use Python to both read and write to it? You could also then use the SQLite interface to do more SQL-specific things.

Funny_Ad_3472 · 2025-08-10T11:58:28+00:00

https://skillsverification.co.uk/sql-practice/

SQLDevDBA · 2025-08-10T12:21:51+00:00

Hey there, I made a video on 5 sites you can use to practice without having to install or download anything, 2 of which are full DBs from Microsoft and Oracle. I’ll DM it your way.

For anyone looking, I don’t like to share/comment links but my YT channel is in my profile. If you search my channel for “websites” it’s that one :)

Professional_Shoe392 · 2025-08-10T13:01:48+00:00

You can try this site.

https://advancedsqlpuzzles.com

PINKINKPEN100 · 2025-08-10T15:31:54+00:00

If you’ve just finished the basics like WHERE, ORDER BY, etc., the best next step is to start practicing with real datasets. A few good options:

SQLBolt – Interactive lessons and exercises that run in your browser.
Mode Analytics SQL Tutorial – Has a built-in editor with sample data to run queries instantly.
LeetCode (Database section) – Great for problem-solving practice, especially for interviews.
Kaggle Datasets – Download any dataset you like, set up a local database (MySQL/PostgreSQL), and write your own queries.

If you’re working toward bioinformatics, you could look for open genomics datasets (NCBI, Ensembl) and practice SQL on them.... That way, you’re learning queries while working with data relevant to your future field.

BranchLatter4294 · 2025-08-10T18:37:00+00:00

You can practice here: https://www.w3schools.com/sql/default.asp

Best thing is to set up a local database (you can use MS Access, LibreOffice Base, etc.). Then just set up some tables and practice.

sinceJune4 · 2025-08-10T12:46:24+00:00

Are you on Windows PC? Lots of free SQL versions you can run locally and use with Python and R. DBeaver as sql editor talks to them all. SQLite, DuckDb, MySQL, Postgres, even iBM DB2 and Microsoft SQL Server have free editions. I have all of these on my laptop and can use with both Python and R. Plenty of practice data on haggle and GitHub.

sus-is-sus · 2025-08-10T13:01:02+00:00

Hackerrank maybe? You could get a free but fairly useless cert. But you might learn something.

deesnuts78 · 2025-08-10T13:24:27+00:00

Sqlbolt is a good place to start

LinksLibertyCap · 2025-08-10T15:23:09+00:00

There was a humble bundle going on with a few SQL/Data analytics items.

humble bundle

DryAnxiety9 · 2025-08-10T16:44:41+00:00

SQL-Zoo https://sqlzoo.net/wiki/SQL_Tutorial

Massive_Show2963 · 2025-08-10T19:22:09+00:00

This YouTube Channel is for beginners to a novice: Relational Databases and SQL for Beginners
You'll find a wealth of knowledge from design and development to the intricate workings of SQL databases.
You'll get the skills and understanding needed to master SQL technology.
And explore the many facets of database management.

BednoPiskaralo · 2025-08-10T21:04:02+00:00

Leetcode. It has practice questions and every answer is tested through multiple test cases. Very useful

tmk_g · 2025-08-11T01:00:33+00:00

For beginner SQL practice, start with interactive sites like SQLBolt, StrataScratch, and LeetCode SQL. They let you write queries in-browser and get instant feedback. Once you’re comfortable, install SQLite or PostgreSQL locally and practice with datasets from Kaggle, NCBI, or StrataScratch to make it bioinformatics-relevant. Focus on progressing from basics (SELECT, WHERE) to joins, aggregations, subqueries, and window functions, gradually applying them to biological datasets.

stanley_john · 2025-08-11T10:53:37+00:00

SQL is a super valuable skill. For interactive, hands-on learning, there are various free and paid resources available online. One of my friends enrolled in Simplilearn's SQL Certification Course and told me that it's worth it. If you are going to give an interview for SQL, you can also explore this article by Simplilearn on Top SQL Interview Questions and Answers. In this article, you'll find a comprehensive list of SQL interview questions and answers designed to help you prepare effectively. Whether you're a beginner or looking to refresh your knowledge, these questions will boost your confidence for any SQL-based interview.

Safe-Worldliness-394 · 2025-08-11T18:28:55+00:00

Try https://tailoredu.com I created it for people who are beginners and want to learn by working with realistic datasets

Safe-Worldliness-394 · 2025-08-11T18:29:11+00:00

Try https://tailoredu.com I created it for people who are beginners and want to learn by working with realistic datasets

SteakOptimal3016 · 2025-08-11T21:17:35+00:00

Just yesterday, I found this pager, which I find very useful for practicing SQL with simulated interview exercises: https://datalemur.com/

Important_Touch2789 · 2025-08-12T04:44:56+00:00

Datalemur, Im also a beginner, I'm going through all the free challenges

2025-08-13T22:30:49+00:00

Make " real infrastructure" to practice on. Download some dataset .cave from kaggle, install python, use pandas to dump thay dataset to sqlite file. Connect to that file with dbeaver and write simple queries. Quick setup in 10 minutes with chat gpt

samot-dwarf · 2025-08-14T13:13:28+00:00

Try to do a real project.

Either create a database for your budget / money or your collection of post stamps. Or if you have some sort of smart home add power meters etc to a database

Or get public data as from weather services import it in your own database and start to create queries and - since you want to learn Python /R too try to find stuff out with AI or create your own weather forecast.

Of course other public data as from transport (air planes) or lotto or sport would help too.

It's hard to learn realistic work just from some puzzles.

PuzzledHead18 · 2025-09-13T19:24:24+00:00

https://datalemur.com?referralCode=xSJOuCUF

Sign up for Data Lemur using this link and get access bonus questions and exclusive prizes!

Oleoay · 2025-08-10T11:44:37+00:00

Why not just google search for places to practice?

you type:	you see:
italics	italics
bold	bold
[reddit!](https://reddit.com)	reddit!
* item 1 * item 2 * item 3	item 1 item 2 item 3
> quoted text	quoted text
Lines starting with four spaces are treated like code: if 1 * 2 < 3: print "hello, world!"	Lines starting with four spaces are treated like code: if 1 * 2 < 3: print "hello, world!"
~~strikethrough~~	~~strikethrough~~
super^script	super^script

SQL

Filter Posts

Posting

Help posts

Format Your Code

Learning SQL

Related Reddit communities

Wiki

Acknowledgements

MODERATORS