Difference between revisions of "SQLZOO:About"
From SQLZOO
| (3 intermediate revisions by one user not shown) | |||
| Line 9: | Line 9: | ||
==Warming up== | ==Warming up== | ||
| − | + | <div class='qu'> | |
[[Read the notes about this table.]] Observe the result of running a simple SQL command. | [[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 | SELECT name, region, population FROM bbc | ||
| − | + | </source> | |
| − | + | <source lang='sql' class='ans'> | |
| − | + | ||
SELECT name, region, population FROM bbc | SELECT name, region, population FROM bbc | ||
| − | + | </source> | |
| − | + | </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 |
|---|
