开发者

Additional SQL Server sample databases to practice with [closed]

Closed. This question does not meet Stack Overflow guidelines. It is not currently accepting answer开发者_如何学JAVAs.

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.


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.


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.


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.

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜