Difference between revisions of "SQLZOO:About"

From SQLZOO
Jump to: navigation, search
Line 14: Line 14:
 
  SELECT name, region, population FROM bbc
 
  SELECT name, region, population FROM bbc
 
  </source>
 
  </source>
<source lang='html'>
 
 
  <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>

Revision as of 10:45, 17 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

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...

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
Personal tools

Variants
Actions
Reference
Toolbox
Google AdSense