Difference between revisions of "SQLZOO:About"

From SQLZOO
Jump to: navigation, search
Line 1: Line 1:
SQLZoo includes tutorials and reference to support people learning SQL.
+
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.
 +
 
 
It features:
 
It features:
 
*Interactive access to several SQL engines
 
*Interactive access to several SQL engines
Line 6: Line 8:
 
*Instant feedback on the success of the student's attempts
 
*Instant feedback on the success of the student's attempts
 
==Format==
 
==Format==
 +
SQLZoo includes a number of extensions to normal Wiki text:
 +
*class='qu'
 +
**A div with class <code>qu</code> is interpreted as an interactive question.
 +
**A <code>div.qu</code> element should include a <code>source.def</code> element
 +
**A <code>div.qu</code> element may include a <code>source.ans</code> element
 +
 
Here is an example of a question:
 
Here is an example of a question:
 
<pre><nowiki>
 
<pre><nowiki>

Revision as of 12:30, 31 August 2013

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.

It 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
    • A div.qu element may include a source.ans element

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


Language: English  • Deutsch
Personal tools

Variants
Actions
Reference
Toolbox
Google AdSense