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
(Seven
chapters, 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
(May have to register (free) for some options)
SQL
Server: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/startsql/getstart_4fht.asp
MS Access:
Help / MS Access Help / Table of Contents / MS Jet SQL Reference