Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Where can I find sample databases with common formatted data that I can use in multiple database engines? [closed]

Does anybody know of any sample databases I could download, preferably in CSV or some similar easy to import format so that I could get more practice in working with different types of data sets?

I know that the Canadian Department of Environment has historical weather data that you can download. However, it's not in a common format I can import into any other database. Moreover, you can only run queries based on the included program, which is actually quite limited in what kind of data it can provide.

Does anybody know of any interesting data sets that are freely available in a common format that I could use with mySql, Sql Server, and other types of database engines?

like image 485
Kibbee Avatar asked Sep 11 '08 16:09

Kibbee


People also ask

What are the 4 types of database?

Four types of database management systemshierarchical database systems. network database systems. object-oriented database systems.

Which of the following statements is used to select one database among multiple databases?

When you have multiple databases in your SQL Schema, then before starting your operation, you would need to select a database where all the operations would be performed. The SQL USE statement is used to select any existing database in the SQL schema.


3 Answers

The datawrangling blog posted a nice list a while back:

http://www.datawrangling.com/some-datasets-available-on-the-web

Includes financial, government data (labor, housing, etc.), and too many more to list here.

like image 93
Adam Hollidge Avatar answered Oct 12 '22 04:10

Adam Hollidge


A lot of the data in Stack Overflow is licensed under the create commons. Every 3 months they release a data dump with all the questions, answers, comments, and votes.

like image 21
Kibbee Avatar answered Oct 12 '22 04:10

Kibbee


For Microsoft SQL Server, there is the Northwind Sample DB and AdventureWorks.

like image 22
Corey Avatar answered Oct 12 '22 02:10

Corey