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; O’Reilly

– SQL for Smarties, 2nd Ed., Joe Celko; Morgan Kaufmann

 

     

–         Oracle:  http://otn.oracle.com (May have to register (free) for some options)

 

               –         MySQL, general:  http://dev.mysql.com/doc/mysql/en/index.html
 
                           SQL reference: http://dev.mysql.com/doc/mysql/en/sql-syntax.html

 

–         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