Difference between revisions of "MySQL Basics: Select Exercises"
|Line 8:||Line 8:|
Download the [[MySQL]] handouts! (8 pages) [http://pzwart2.wdka.hro.nl/~techday/handouts/
Download the [[MySQL]] handouts! (8 pages) [http://pzwart2.wdka.hro.nl/~techday/handouts/MySQL.pdf]
Latest revision as of 23:44, 22 May 2008
The US Government organizes and publishes online a publically accessible database of various information and statistics organized by country. Each year, a new version of the "CIA Worldfactbook" is made available. Via the website (https://www.cia.gov/cia/publications/factbook/index.html) it's possible to download the lot as a big zip of HTML files. Handy for planning your next coup when out of range of an Internet connection, but much more interesting would be to do retrieval / summarizing with SQL...
A sample resulting database (based on 2004 data):