Main Page Content
SQL and Database Resources on the Web
Rated 4.25 (Ratings: 9) (Add your rating)
Log in to add a comment
(2 comments so far)
rudy limeback
User since: December 13, 1998
Last login: November 26, 2008
Articles written: 12
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)
