39. Appendix B - SQL Tutorial for beginners

39.1 Tutorial for PostgreSQL

SQL tutorial is also distributed with PostgreSQL. The SQL tutorial scripts is in the directory src/tutorial

39.2 Internet URL pointers

The SQL tutorial for beginners can be found at

• Jim Hoffman's tutorial http://w3.one.net/~jhoffman/sqltut.htm
• Carnegie Mellon Univ http://www.heinz.cmu.edu/project/dbms Go here and click on 'technical'->'SQL_examples.html' and others.
• Concord Univ http://www.cs.concordia.ca/Course_Notes/oracle/browser/node1.html

Comments or suggestions? Mail to

• Jim Hoffman jhoffman@one.net

• SQL Reference http://www.contrib.andrew.cmu.edu/~shadow/sql.html
• Ask the SQL Pro http://www.inquiry.com/techtips/thesqlpro/
• SQL Pro's Relational DB Useful Sites http://www.inquiry.com/techtips/thesqlpro/usefulsites.html
• Programmer's Source http://infoweb.magi.com/~steve/develop.html
• DBMS Sites http://info.itu.ch/special/wwwfiles Go here and see file comp_db.html
• DB Ingredients http://www.compapp.dcu.ie/databases/f017.html
• Web Authoring http://www.stars.com/Tutorial/CGI/
• Computing Dictionary http://wfn-shop.princeton.edu/cgi-bin/foldoc
• DBMS Lab/Links http://www-ccs.cs.umass.edu/db.html
• SQL FAQ http://epoch.CS.Berkeley.EDU:8000/sequoia/dba/montage/FAQ Go here and see file SQL_TOC.html
• SQL Databases http://chaos.mur.csu.edu.au/itc125/cgi/sqldb.html
• RIT Database Design Page http://www.it.rit.edu/~wjs/IT/199602/icsa720/icsa720postings.html
• Database Jump Site http://www.pcslink.com/~ej/dbweb.html
• Programming Tutorials on the Web http://www.eng.uc.edu/~jtilley/tutorial.html
• Development Resources http://www.ndev.com/ndc2/support/resources.htp
• Query List http://ashok.pair.com/sql.htm
• IMAGE SQL Miscellaneous http://jazz.external.hp.com/training/sqltables/main.html
• Internet Resource List http://www.eit.com/web/netservices.html

39.3 On-line SQL tutorials

Visit the following sites for on-line SQL tutorials

• SQL beginner course http://sqlcourse.com
• SQL advanced course http://sqlcourse2.com