Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Sample database for exercise [closed]

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?

like image 501
n00ki3 Avatar asked Apr 05 '09 16:04

n00ki3


People also ask

Where can I find sample databases for learning SQL?

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

What are the best resources to practice SQL?

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.

Where can I find good SQL exercises for beginners?

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

How many tables are in the bikestores sample database?

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.


2 Answers

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.

like image 158
karim79 Avatar answered Oct 04 '22 05:10

karim79


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

like image 6
iberck Avatar answered Oct 04 '22 04:10

iberck