Quick Ref.
Functions
date
number
string
Data Types
date
number
string
SQL Server, Oracle, MySQL, DB2, Mimer, PostgreSQL, SQLite Accessについて学習します.

チュートリアル

1) SELECT:
ここでは BBC country テーブルに問い合わせます
2a) More practice with SELECT:
Nobel Prize winners テーブルを使って基本的な特徴を練習します
2b) SELECT in SELECT:
ここではクエリーからクエリーを使います
3) SUM and COUNT:
ここでは集計関数を使います [more the same]
4) The JOIN operation:
ここではttms と countryの２つのテーブルを結合します [previously music tutorial]
5) More JOIN operations:
ここではMovie Database より俳優と映画を結合します
6) Using Null:
ここでは学部内より先生を検索します [previously Scottish Paliament]
7) Self join:
ここではエジンバラのバスルートを検索します
Help wanted
SQLZoo is going wiki - please contribute.
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 ]
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

Answers

Answers to the tutorial questions.

Assessments

These exercises involve larger databases. Answers to these questions are not available to students.

Other information

Diversions
SQLzoo in German

By Andrew Cumming of the School of Computing of Napier University, Edinburgh, UK. 1999-2005