Difference between revisions of "SQLZOO:About"
From SQLZOO
| (2 intermediate revisions by one user not shown) | |||
| Line 14: | Line 14: | ||
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 | ||
</source> | </source> | ||
</div> | </div> | ||
| + | |||
| + | 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> | ||
| + | |||
| + | |||
| + | {{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 |
|---|