SQL and Database Resources on the Web

many web developers are now faced with the daunting task of learning sql and interfacing a web page with a relational database

yes, you could order some treeware from youronlinebookstoredujour.com, but while you're waiting for the shipment to arrive, have a look at these sql and database resources on the web

the comments are mine, as is the rating system:

excellent *****
good ****
fair ***

sites with fewer than three stars are not listed here ;o)

Introduction to Structured Query Language *****
Jim Hoffman

from basic concepts to foreign keys, aggregates, outer joins, subselects and more, everything you need is here

links to additional web resources are in item 6 of the Common SQL Questions & Advanced Topics section, and also in the Important Computing & SQL/Database Links section

SQL : Tips and Tutorials ****
Database Central

all the major sql tutorial sites are listed in this section, which is only a small portion of Database Central, a humungous (4000+) collection of database links and resources

Celko ****
Intelligent Enterprise

these are Joe Celko's latest columns; earlier columns are in the DBMS Magazine archives

The Datawarehousing Information Center ****
Larry Greenfield

data warehousing, OLAP, data mining, database vendors... see the introductory page called Getting Started with Data Warehousing

SQL Interpreter and Tutorial ***
with live practice database

what a great concept for the sql beginner -- as you learn, you can try out some basic sql sentences right there on the site

Database Normalization *****
by Ian Gilfillan

well-written tutorial on why normalization is important -- good explanation of primary and foreign keys

Introduction to Databases for the Web ***
Selena Sol

comprehensive, intro level, programming-oriented tutorial (although somewhat disorganized, and with many fifty-cent words which won't mean much if you're not already familiar with database systems) -- includes chapters on Perl CGI and JDBC

Ask the SQL Server Pro *****
inquiry.com's DevX

intermediate to advanced level, with loads of good tips, many of which can be applied in databases other than sql/server

Database Management Systems ****
by Philip Greenspun

this is chapter 12 of an online book -- not exactly intro level, not really a how-to, yet it's a delightful read and it covers database administration concepts like indexing and backups (which you'll need if you're building the database yourself)