Difference between revisions of "SQLZOO:About"
From SQLZOO
| 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='html'> | |
| − | + | <source lang='sql' class='ans'> | |
SELECT name, region, population FROM bbc | SELECT name, region, population FROM bbc | ||
| − | + | </source> | |
| − | + | </div> | |
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
Revision as of 23:00, 8 June 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
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='html'> <source lang='sql' class='ans'> SELECT name, region, population FROM bbc </source> </div>
