Difference between revisions of "SQL Zoo"

From SQLZOO
Jump to: navigation, search
(Tutorial Section)
(Tutorial Section)
Line 1: Line 1:
 
Interactive SQL tutorial, learn about: SQL Server, Oracle, MySQL, DB2, Mimer, PostgreSQL, SQLite and Access.
 
Interactive SQL tutorial, learn about: SQL Server, Oracle, MySQL, DB2, Mimer, PostgreSQL, SQLite and Access.
 
==Tutorial Section==
 
==Tutorial Section==
;SELECT::Some simple queries to get you started
+
;SELECT:Some simple queries to get you started
 
;SELECT:In which we query the BBC country profile table.
 
;SELECT:In which we query the BBC country profile table.
 
;More practice with SELECT:Additional practice of the basic features using a table of Nobel Prize winners.
 
;More practice with SELECT:Additional practice of the basic features using a table of Nobel Prize winners.

Revision as of 13:45, 7 February 2012

Interactive SQL tutorial, learn about: SQL Server, Oracle, MySQL, DB2, Mimer, PostgreSQL, SQLite and Access.

Tutorial Section

SELECT
Some simple queries to get you started
SELECT
In which we query the BBC country profile table.
More practice with SELECT
Additional practice of the basic features using a table of Nobel Prize winners.
SELECT in SELECT
In which we form queries using other queries.
SUM and COUNT
In which we apply aggregate functions. [more the same]
The JOIN operation
In which we join two tables; ttms and country. [previously music tutorial]
More JOIN operations
In which we join actors to movies in the Movie Database.
Using Null
In which we look at teachers in departments. [previously Scottish Paliament]
Self join
In which we join Edinburgh bus routes to Edinburgh bus routes.
SQL User Manuals
[ Mimer | MySQL | Oracle | SQL Server | Access | DB2 | Sybase | Postgres | SQLite ]
Online copies of implementation specific user manuals.
Starting SQL
[ MySQL | Oracle | SQL Server | DB2 | Postgres | Ingres ]
How to connect to the server and execute SQL statements.
Programming with SQL
[ SQL in perl on the Web | SQL from Java ]
SQL standard
[ SQL92 BNF ]


Reference Section: how to...

1) SELECT:

   How to read the data from a database. 

2) CREATE and DROP:

   How to create tables, indexes, views and other things. How to get rid of them.

3) INSERT and DELETE

   How to put records into a table, change them and how to take them out again.

4) DATE and TIME

   How to work with dates; adding, subtracting and formatting.

5) Functions

   How to use string functions, logical functions and mathematical functions.

6) Users

   How to create users, GRANT and DENY access, get at other peoples tables. How to find processes and kill them.

7) Meta Data

   How to find out what tables and columns exist. How to count and limit the rows return.

Error Messages

   Some error messages from SQL engines