Question

Closed. This question is seeking recommendations for books, tools, software libraries, and more. It does not meet Stack Overflow guidelines. It is not currently accepting answers.

We don’t allow questions seeking recommendations for books, tools, software libraries, and more. You can edit the question so it can be answered with facts and citations.

Closed 7 years ago.

Improve this question

I m helping a friend learn SQL, and need more databases to help him get more practice. We have of course AdventureWorks, Northwind, and Pubs.
Does anybody know of any other SQL databases samples that might be available to download? I know some sites have some databases where you can practice queries on the site, but I was looking for something he can run locally.

Answer 1

Here s one called the Chinook Database. It has scripts for SQLServer, Oracle, MySQL, SQLServer Compact.

http://chinookdatabase.codeplex.com/Release/ProjectReleases.aspx?ReleaseId=21111

As I find more, I ll post here.

Answer 2

Try downloading and importing some of the free data sets the Census bureau, US Geological Survey, National Oceanic and Atmospheric Administration, or other large data gathering agencies provide for free on the web.

Why not work with a billion record table of all the elevation points in the US? Not only do you get the practice your DB skills, you can get real world types of indexing and performance issues.

Answer 3

I think it is much better Idea to create a database from scratch ,Taking sample project say a simple inventory management system and then building tables finally creating then in db ,It would be much practical way to learn then to directly play with a ready made database.

友情链接