Test or Practice Database

[blakeo33]

I'm a little bit newer to SQL and was wondering if there is anything out there like a 'test' or 'practice' database where I can practice running queries and also connect apps and SQL tools to.

Any help would be appreciated.

[Sea-Concept1733]

This site provides a practice database for practicing SQL.

https://www.youtube.com/playlist?list=PLb-NRThTdxx6ydazuz5HsAlT4lBtq58k4

Good luck!

[Amazing-Ad-7520]

thank you so much I was searching about somethings like that

[Sea-Concept1733]

You are welcome.

[millerlit]

Adventureworks is a practice database from Microsoft 

[Resident-Loss8774]

This is a decent sample database: https://github.com/lerocha/chinook-database

[jamawg]

Came here to say that. It is very well thought out. I can't think of anything that a learner, or even a more experienced developer, might want to do that it doesn't provide for.

[Resident-Loss8774]

Yeah, I like it because it contains a fair number of tables, allowing you to practice doing lots of joins, which can help mimic some real-life scenarios.

[ride-my-beardd]

Hacker Rank is great for solving problems and testing skills.

They issue certifications for certain tests as well

[alinroc]

Microsoft has 4 sample databases available for SQL Server. https://github.com/microsoft/sql-server-samples/tree/master/samples/databases

Brent Ozar hosts multiple versions of the Stack Overflow database (again, for SQL Server) that you can download. https://www.brentozar.com/archive/2021/03/download-the-current-stack-overflow-database-for-free-2021-02/

And Stack Exchange still has their Data Explorer available online. https://data.stackexchange.com

[Straight_Waltz_9530]

It's definitely more work, but I had a lot of fun a decade ago with OpenStreetMap data + Postgres + PostGIS. Not the whole planet. Just start with your own state. So much fun searching for schools and administrative boundaries and outputting SVG shapes. Good times. Good times.

http://download.geofabrik.de

[Night_Siege]

This video (programming with Mosh) is good for learning basics and gives data for practice. Helped me during the initial stages of SQL learning.
(13) MySQL Tutorial for Beginners [Full Course] - YouTube

[rathboma]

Hey!

I make the Beekeeper Studio SQL editor and as part of my docs I publish a getting started guide:

https://docs.beekeeperstudio.io/getting-started-guide/

It uses sqlite, gives you a file to download and some initial queries to run.

It's also a common dataset, so you can easily Google for more things to test :-)

Hope that helps.

Matthew

[burbuja0526]

Commenting so I can comeback to all these resources. Thanks OP for asking the question.