Tutorials

1) SELECT:

In which we query the CIA World Factbook.

2) SELECT in SELECT:

In which we form queries using other queries.

3) SUM & COUNT:

In which we summarise and aggregate and order.

4) JOINS:

In which we join actors to movies in the Movie Database.

5) OUTER JOINS:

In which we include the parties without people and the people outwith parties in the Scottish Parliament.

6) SELF JOINS:

In which we join Edinburgh bus routes to Edinburgh bus routes.

Quick reference: how to...

1) CREATE and DROP:

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

2) INSERT and DELETE

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

3) GRANT and REVOKE

How to specify who can do what to your tables.

4) Functions

String functions, logical functions and mathematical functions that may be used. (see Tutorial 3 for aggregate functions).

5) How to use schema/databases.

Getting at other peoples tables.

6) How to monitor/limit resource usage

Assessments

• Neeps: A timetable database
• Musicians

Answers

• SELECT
• SELECT in SELECT
• SUM & COUNT
• JOINS
• OUTER JOINS
• ACME
• OUTER JOINS
• Top of the Pops

Other information

• What is SQL?
• How to use these tutorials.
• Links to SQL manuals.
• Comments from readers.
• Jobs in Scotland requiring SQL

Diversions

• Top of the Pops: using dates
• ACME products: dealing with money.
• GISQLOG: users attempts at this material