|
Practical PostgreSQL, an online PostgreSQL book
http://www.faqs.org/docs/ppbook/book1.htm
University of California, Berkeley
CS 186: Introduction to Database Systems
Fall 2006
http://inst.eecs.berkeley.edu/~cs186
EECS Dept., Computer Science Division
University of California, Berkeley
CS 286: Avdvanced Database Systems
(a.k.a. Networked Information Systems)
Spring 2001
http://www.cs.berkeley.edu/~franklin/CS286S01/index.html
Department of Science
Stanford University
A First Course in Database Systems
http://www.stanford.edu/class/cs145
Department of Science
Cornell University
CS 432 Fall 2006
Introduction to Database Systems
http://www.cs.cornell.edu/courses/cs432/2006fa/
Department of Electrical and Computer Engineerig
University of Waterloo
ECE 456
Database Systems
http://www.ece.uwaterloo.ca/~ece456
DataBase Design
Introduction to Database Design, Entity-Relationship Diagrams
http://www.cit.cornell.edu/atc/materials/old/dbdesign/erd.shtml
SmartDraw cool examples:
Banking Transaction, Hospital Billing System, Testing Software and Database,
E-Commerce Model and other examples.
http://www.smartdraw.com/exp/ste/examples/
Interactive/On-line SQL Tutorial with SQL Interpreter & live practice
database.
SQLcourese -
http://www.sqlcourse.com/
Online SQL tutorial featuring a live interpreter to test SQL commands.
SQLcourese2 -
http://www.sqlcourse2.com/
SQL for Web Nerds -
http://www.arsdigita.com/books/sql/
A nicely structured manuscript on SQL by Philip Greenspun, based on the
Oracle database. Queries, transactions, triggers, and RDBMS concepts are
covered.
SQL Tutorial -
http://www.1keydata.com/sql/sql.html
This site aims to teach beginners the building blocks of SQL.
Steve Litt's SQL Troubleshooting Page -
http://www.troubleshooters.com/codecorn/lsql.htm
Tips on how to troubleshoot SQL queries.
Tutorial covering basics of SQL Language
Fluffycat SQL -
http://fluffycat.com/sql/
Examples of how to use SQL commands
Cars Tutorial by Mark Sutton -
http://www.baymediax.com/portfolio/msutton/cars/sqltutor/
|