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?
Is there a type of report or cross-tab that would display this data elegantly?
Database Engine Independent Data Modelling
Best Practice for seeing live data on the dev server?
How do you do calculations in Access?
Includes financial, government data (labor, housing, etc.), and too many more to list here..
Preventing Duplicate Inserts Into SQL With PHP
Have you tinkered with Rel?
Is there an exchange format for ERD?
Every 3 months they release a data dump with all the questions, answers, comments, and votes..
- world (world countries and cities)
- sakila(video rental)
They're all ultimately stored as Google Documents, so you can export them into csv & Excel..
I needed some sample data to practice what I was learning with MySQL at the time and just downloaded PHPBB and used their provided database.
If you need to add users etc, just use the program to do it.. Think generic.
You can get weather data from common sources for free, thetvdb.com has a pretty nifty set of data for TV show episodes for free, sites like last.fm have a tonne of data available for music listening habits.
If you just want sample data, the easiest way to get it is not thinking in terms of "I want a database".
Think "what freely available data is out there"..