Difference between revisions of "SQLZOO:About"

From SQLZOO
Jump to: navigation, search
(10 intermediate revisions by 4 users not shown)
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 features:
+
 
 +
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.
 +
 
 +
SQLZoo features:
 
*Interactive access to several SQL engines
 
*Interactive access to several SQL engines
 
*Sample databases
 
*Sample databases
Line 6: Line 10:
 
*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
 +
***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 <code>div.qu</code> element may include a <code>source.ans</code> 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:
 
Here is an example of a question:
 +
<pre><nowiki>
 +
==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>
 +
</nowiki></pre>
 +
And here is how that looks when rendered...
 +
 +
==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>
 +
 +
==StartAt==
 +
You can include a ***startAt*** span at the top of the page. This will ensure that question numbering starts at the specified value.
 +
<pre>
 +
<nowiki>
 +
<span id=startAt class=params>6</span>
 +
</nowiki>
 +
</pre>
 +
 +
==Hints==
 +
You can include a hint. The title will be shown, if the user clicks on the text the body will be revealed:
 +
<div class='hint' title='Clicik here to see the hint'>Now the hint has been revealed</div>
 +
<pre>
 +
<nowiki>
 +
<div class='hint' title='Click here to see the hint'>Now the hint has been revealed</div>
 +
</nowiki>
 +
</pre>
  
==Warming up==
+
{{Languages}}
<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='html'>
+
<source lang='sql' class='ans'>
+
SELECT name, region, population FROM bbc
+
</source>
+
</div>
+
+
==Large Countries==
+
<div class='qu'>
+
Show the name for the countries  that have a population of at least 200 million. (200 million is 200000000, there are eight zeros)
+
<source lang='sql' class='def'>
+
SELECT name FROM bbc
+
WHERE population>250000000
+
</source>
+
+
<source lang='sql' class='ans'>
+
SELECT name FROM bbc
+
WHERE population>200000000
+
</source>
+
</div>
+

Revision as of 15:58, 1 September 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.

SQLZoo features:

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

Contents

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>

Language: English  • Deutsch
Personal tools

Variants
Actions
Reference
Toolbox
Google AdSense