Introduction To Structured Query Language (SQL) Part 1
Topics
Data
definition language (DDL)
Data
manipulation language (DML)
Basic
SELECT queries
Queries
using DDL and DML commands
References:
A Gentle Introduction to SQL: http://sqlzoo.net
(Interactive tutorials,
across-database comparisons)
SQL Tutorial: http://www.w3schools.com/sql/default.asp
(No
exercises but includes a quiz; quite a few ads and animated text.)
Interactive Online SQL Training: http://www.sqlcourse.com
(Interactive tutorials,
Includes standalone SQL interpreter for trying out statements; some pictures,
ads, scrolling text.)
Learning Guide: SQL:
http://searchdatabase.techtarget.com/orginalContent/0,289142,sid13_gci950920,00.html
(Eight
chapters, from basic to advanced;
may have to register (free) to use - and receive e-mail newsletters :( )
The Practical SQL Handbook, 4th Ed., Judith Bowman, Sandra
Emerson, and Marcy Darnovsky; Addison Wesley
SQL in a Nutshell, Kevin Kline; OReilly
SQL for Smarties, 2nd Ed., Joe Celko; Morgan Kaufmann
Oracle: http://otn.oracle.com
MySQL: http://www.mysql.com/documentation/mysql/bychapter/
Tutorial: http://www.mysql.com/documentation/mysql/bychapter/manual_Tutorial.html#Tutorial
SQL
Server: http://msdn.microsoft.com/library/default.asp?URL=/library/psdk/sql/portal_7ap1.htm
MS Access:
Help (Contents) / MS Jet SQL