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 webthe comments are mine, as is the rating system:excellent *****sites with fewer than three stars are not listed here ;o)
good ****
fair ***
from basic concepts to foreign keys, aggregates,
outer joins, subselects and more, everything you need is herelinks to additional web resources are in item 6 of the
target="_new">Common SQL Questions & Advanced Topics section, and alsoin the target="_new">Important Computing & SQL/Database Links sectionall the major sql tutorial sites are listed in this section,
which is only a small portion of target="_new">Database Central, a humungous (4000+) collection of database links and resourceswhat a great concept for the sql beginner --
as you learn, you can try out some basic sql sentences right there on the sitewell-written tutorial on why normalization is important --
good explanation of primary and foreign keyscomprehensive, intro level, programming-oriented
tutorial (although somewhat disorganized, and withmany fifty-cent words which won't mean much if you're notalready familiar with database systems) -- includes chapterson Perl CGI and JDBCintermediate to advanced level,
with loads of good tips, many of which can be applied in databases other than sql/serverthis is chapter 12 of an online book --
not exactly intro level,not really a how-to, yet it's a delightful read and itcovers database administration conceptslike indexing and backups(which you'll need if you're buildingthe database yourself)