SQLZOO:About - Revision history

Peter at 19:58, 21 August 2012

2012-08-21T19:58:38Z

Andr3w at 10:45, 17 August 2012

2012-08-17T10:45:56Z

Andr3w at 10:45, 17 August 2012

2012-08-17T10:45:41Z

Andr3w at 23:00, 8 June 2012

2012-06-08T23:00:11Z

Andr3w at 22:58, 8 June 2012

2012-06-08T22:58:38Z

Andr3w: 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 ..."

2012-06-08T22:57:41Z

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

New page

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>

==Large Countries==
<div class='qu'>
Show the name for the countries that have a population of at least 200 million. (200 million is 200000000, there are eight zeros)
<source lang='sql' class='def'>
SELECT name FROM bbc
WHERE population>250000000
</source>

<source lang='sql' class='ans'>
SELECT name FROM bbc
WHERE population>200000000
</source>
</div>
</source>

← Older revision		Revision as of 19:58, 21 August 2012
Line 30:		Line 30:
	</source>		</source>
	</div>		</div>
		+
		+
		+	{{Languages}}

@@ Line 22: / Line 22: @@
 ==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

@@ Line 14: / Line 14: @@
   SELECT name, region, population FROM bbc
   &lt;/source>
   &lt;source lang='sql' class='ans'>
   SELECT name, region, population FROM bbc
   &lt;/source>
   &lt;/div>

@@ Line 9: / Line 9: @@
   ==Warming up==
-  <div class='qu'>
+  &lt;div class='qu'>
   [[Read the notes about this table.]] Observe the result of running a simple SQL command.
-  <source lang='sql' class='def'>
+  &lt;source lang='sql' class='def'>
   SELECT name, region, population FROM bbc
-  </source>
+  &lt;/source>
-  <source lang='html'>
+  &lt;source lang='html'>
-  <source lang='sql' class='ans'>
+  &lt;source lang='sql' class='ans'>
   SELECT name, region, population FROM bbc
-  </source>
+  &lt;/source>
-  </div>
+  &lt;/div>
-−
- ==Large Countries==
- <div class='qu'>
- Show the name for the countries  that have a population of at least 200 million. (200 million is 200000000, there are eight zeros)
- <source lang='sql' class='def'>
- SELECT name FROM bbc
- WHERE population>250000000
- </source>
-−
- <source lang='sql' class='ans'>
- SELECT name FROM bbc
- WHERE population>200000000
- </source>
- </div>

SQLZOO:About - Revision history

Peter at 19:58, 21 August 2012

Andr3w at 10:45, 17 August 2012

Andr3w at 10:45, 17 August 2012

Andr3w at 23:00, 8 June 2012

Andr3w at 22:58, 8 June 2012

Andr3w: 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 ..."

Andr3w: 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 ..."