Difference between revisions of "SQLZOO:About"
From SQLZOO
(Created page with "SQLZoo includes tutorials and reference to support people learning SQL. It features: *Interactive access to several SQL engines *Sample databases *Practical exercise *Instant ...") |
|||
| (4 intermediate revisions by one user not shown) | |||
| Line 8: | Line 8: | ||
Here is an example of a question: | 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== | ==Warming up== | ||
<div class='qu'> | <div class='qu'> | ||
| Line 14: | Line 26: | ||
SELECT name, region, population FROM bbc | SELECT name, region, population FROM bbc | ||
</source> | </source> | ||
| − | |||
<source lang='sql' class='ans'> | <source lang='sql' class='ans'> | ||
SELECT name, region, population FROM bbc | SELECT name, region, population FROM bbc | ||
| Line 20: | Line 31: | ||
</div> | </div> | ||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | + | {{Languages}} | |
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
Latest revision as of 19:58, 21 August 2012
SQLZoo includes tutorials and reference to support people learning SQL. It features:
- Interactive access to several SQL engines
- Sample databases
- Practical exercise
- Instant feedback on the success of the student's attempts
[edit] Format
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...
[edit] 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 |
|---|
