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

– 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