I would like to play with a larger database to test my knowledge on SQL.
Is there a huge .sql out there that I can use to play with SQL queries?
SQL-EX- seems to provide SQL exercises, but requires an account. Some sample databases can be downloaded here: SQL Server 2008/2012/2014 -> AdventureWorkssample databases; Share
Here are a few nice ones that offer (online) practice: SQLZOO- lets you practice interactively with SQL queries for different database management systems; SQLCourse.com- also an interactive tutorial that lets you practice SQL queries; Introduction to Databases- a Stanford online course with a lot of explanatory video lectures.
Check this site sql-ex.ruIt has a lot of sql exercises from beginner level to incredibly complex. – Igor Borisenko Jul 16 '14 at 8:37 1 use-the-index-luke.com/welcomethis is pretty good read on indexes – DrCopyPaste
The following illustrates the BikeStores database diagram: As you can see from the diagram, the BikeStores sample database has two schemas sales and production, and these schemas have nine tables. Database Tables Table sales.stores The sales.storestable includes the store’s information.
You could try the classic MySQL world database.
The world.sql file is available for download here:
http://dev.mysql.com/doc/index-other.html
Just scroll down to Example Databases and you will find it.
This is an online database but you can try with the stackoverflow database: https://data.stackexchange.com/stackoverflow/query/new
You also can download its dumps here:
https://archive.org/download/stackexchange
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With