Some frequently asked questions about SQLzoo
Sorry about that. The point of this site is to teach, not to make money. It's no excuse, but I do use the income for good works, mostly sending me to conferences in hot countries.
The advert-free version is http://sqlzoo.net/noads/
The engines run a variety of SQL implementations on a number of different machines. You can see from the table below which of the engines is working right now.
Please report any broken or slow engines to firstname.lastname@example.org
Next time you are visiting Edinburgh, UK you can shake his hand at the Tollcross State Circus which meets on Monday, 7pm to 9pm in Tollcross primary school.
You can buy him a drink afterwards, in the Blue Blazer, Spittal Street; a pint of 80 Shilling please.
The source of the main tutorial section is stored in xml files such as:
. These files contain an xml format that is close to html but has a handful
of additional tags (such as
Additionally the xml files are translated into various languages and stored in language directories such as http://sqlzoo.net/de/home.xml. The translations are initially provided by Google - but can be edited by human translators.
I maintain a "zoo" of SQL engines that process users SQL attempts.
The animals of this zoo are SQL engines - one of each species. They have been caged and tamed. The public can poke, prod and gawp - the exhibits and the public are protected from each other. Andrew is the zoo keeper, he feeds them and shovels away the waste.
Yes please do - link from as many places as possible. Link from your page, link from bulletin boards, ask for a link from any directories.
If at all possible include the word
Since you're asking - there's two kinds of link that bother me -
Neither of these do me any harm - but they don't do me any good either. Universities (including my own, Napier) should not use gated systems like this.
Getting hold of SQL for free
Many vendors have a free downloadable version available:
Sample data used in SQL zoo has been collected from a variety of sources. While I'm happy for you to publicise sqlzoo as widely as possible you should not attribute the data to me. Some was collected from agencies without their consent some was adapted from the work of colleagues (or their colleagues). My only contribution has been to present it in a convenient format.
The zip file gisq.sql.zip contains all of the tutorial material in MySQL format.
SQL commands to create and populate the tables are available.
The individual tables are available in tab delimited format. This can be imported into pretty well anything.
This material was designed to be used in supervised tutorials at Napier University. Teachers from other institutions are welcome to use it in any way they see fit, however I have a few requests/suggestions:
I use country data from the BBC web site. Their country profile pages include details of just under 200 countries. It makes fascinating reading.
Readers should assume that errors or omissions in the data are mine and not the fault of following sources.
Thanks are due to the following fine organisations: