Interactive SQL tutorial, learn about:
SQL Server, Oracle, MySQL, DB2, Mimer, PostgreSQL, SQLite and Access.Tutorial Section
- 1) SELECT:
- In which we query the BBC country profile table.
- 2a) More practice with
SELECT: - Additional practice of the basic features using a table of Nobel Prize winners.
- 2b)
SELECTinSELECT: - In which we form queries using other queries.
- 3) SUM and COUNT:
- In which we apply aggregate functions.
- 4) The JOIN operation:
- In which we join two tables; albums and tracks in a music database.
- 5) More JOIN operations:
- In which we join actors to movies in the Movie Database.
- 6) The OUTER JOIN:
- In which we include the parties without people and the people outwith parties in the Scottish Parliament.
- 7) 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] - 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]
