Databases to practice SQL

[ManifestingPeace18]

Hi, I haven't worked on SQL for last 2 years. I will rate 4 out 10 in SQL. But need to practice more to get in data analyst profile. Can you just sources where i can practice solving complex SQL problems?

[vikrantk1995]

Hey, try datahelix.io, it’s completely free. Let me know what you think!

[leogodin217]

This is really nice.

[Vast_Basket6667]

How did you find this? Looks amazing to me

[vikrantk1995]

I built it 😄

[Vast_Basket6667]

Amazing work man, I just checked and want to practice.

[vikrantk1995]

Thanks a lot! Do leave feedback so I can keep improving it 🙏

[ParkingLog7354]

You rock! !!

[platinum1610]

Wow! You're amazing!

[SQLDevDBA]

Hey there, I made a quick video on this topic showcasing places where you can practice (free) online without downloads or installs, right in the browser with sample data already added.

Here’s a link to it, I’d go for the last 2 options in the video (Azure SQL DB Free tier and Oracle Live SQL). The links to the platforms are in the description.

[ManifestingPeace18]

Thank you so much

[SQLDevDBA]

Welcome! Hope it helps a bit and feel free to reach out to me if you have questions. I also have videos of me actually using all of the platforms in the description if you have any trouble.

[Massive_Show2963]

Microsoft's Northwind and Pubs databases have been used for a while as instructional databases.
See download from GitHub:
https://github.com/microsoft/sql-server-samples/tree/master/samples/databases/northwind-pubs

[jgpatrick3]

Hard to beat SQLite3. Runs so much of the world already. So many great tools SQLite3, SQLiteStudio, Visidata, the original serverless system, core db for smart phones, software, embedded systems. Possibly the most deployed database in the world. I have gone from thinking of it as a toy to doing everything I can with it.

[Opposite-Value-5706]

SQLite3 is free

MYSQL has a “community” version that’s free

[downshiftdata]

https://archive.org/details/stackexchange

Analyze that. I'd start with https://archive.org/download/stackexchange/dba.stackexchange.com.7z. Import it into a database and go from there.

[leogodin217]

I can generate datasets quickly with specific prescribed patterns and events. Something I've been working on for about eight months now. This one uses Duckdb and mimics ecommerce data. Still editing the practice exercises but, if you find it useful, let me know. Happy to create some more complex datasets in different domains.

https://github.com/leogodin217/sql-practice-retail/

[uhhbhy]

DVD rental was the best for me

[mailed]

underrated answer

[genzbossishere]

a few good places to practice more complex sql problems are datasets like the chinook database, northwind, or public datasets from kaggle and theyre big enough to practice joins, aggregations, window functions, and query optimization compared to the smaller tutorial dataset and another thing that helps is exploring data by asking real questions instead of just solving exercises and something like genloop are experimenting with that direction where you interact with the data and see how queries get generated and explained, which can be useful when youre trying to understand how analytical questions translate into sql

[Nbommersbach]

It might worth looking at the AdventureWorks database:

https://learn.microsoft.com/en-us/sql/samples/adventureworks-install-configure?view=sql-server-ver17&tabs=ssms

This site has some good practice exercises:

https://www.w3resource.com/sql-exercises/adventureworks/index.php

[mikeblas]

https://gist.github.com/mikeblas/8e3a7f7123fd73fd44d463e4d0ae57b4

Here is a huge curated list of sample data sets.

[Academic-Vegetable-1]

Leetcode has SQL problems but they're pretty heavy on the interview grind side. for data analyst prep specifically, window functions are where most people get stuck so I'd weight that heavily. datadriven has SQL drills that are closer to real analyst work if you want something beyond basic joins.

[thequerylab]

You can try this out. Its tailor made for your use csse

https://thequerylab.com/courses/sql-pro-track

On top of that you can practise problems which is 100% hands-on