SQLZOO:About

SQLZoo includes tutorials and reference to support people learning SQL.

It is based on MediaWiki and it allows users to change the content. http://www.mediawiki.org/wiki/Help:Editing_pages shows how to edit pages in "standard" media wiki.

• Only users with the teacher role can edit pages.
  • Any teachers who can help with fixing errors or creating content are most welcome
  • Send an email (ideally from an educational address) to qa-sqlzoo@gmail.com and tell us your user name - we can add that role so that you can edit.

SQLZoo features:

• Interactive access to several SQL engines
• Sample databases
• Practical exercise
• Instant feedback on the success of the student's attempts

Format

SQLZoo includes a number of extensions to normal Wiki text:

• class='qu'
  • A div with class qu is interpreted as an interactive question.
  • A div.qu element should include a source.def element
    • This contains the default text that the user sees.
    • Sometime this is a useful hint and is close to the correct answer.
    • It may be empty - but users often click without changing the text before even looking at it
  • A div.qu element may include a source.ans element
    • This contains the correct SQL.
    • This is hidden from the user (but not well hidden)
    • The user's result is compared with the answers result and a score is calculated

Here is an example of a question:

==Warming up==
<div class='qu'>
[[Read the notes about this table.]] Observe the result of running a simple SQL command.
<source lang='sql' class='def'>
SELECT name, region, population FROM bbc
</source>
<source lang='sql' class='ans'>
SELECT name, region, population FROM bbc
</source>
</div>

And here is how that looks when rendered...

Warming up

Read the notes about this table. Observe the result of running a simple SQL command.

SELECT name, region, population FROM bbc

SELECT name, region, population FROM bbc

StartAt

You can include a ***startAt*** span at the top of the page. This will ensure that question numbering starts at the specified value.

<span id=startAt class=params>6</span>

Hints

You can include a hint. The title will be shown, if the user clicks on the text the body will be revealed:

Now the hint has been revealed

<div class='hint' title='Click here to see the hint'>Now the hint has been revealed</div>

Clear Results

<div class="lsclear">Clear your results</div>

Clear your results

Language:Project:Language policy	English  • Deutsch