Useful Web Links -- Databases

Relational Database Model

Sample Data Models for Relational Database Design

SQL

• Oracle10g Database SQL Reference
• SQL SELECT statement syntax, from the above reference
• Querying by date
• Oracle 11g Database SQL Language Reference

SQL*Plus

• SQL*Plus Documentation

PL/SQL

PL/SQL tutorial, Dr. J. Ullman, Stanford University.

Miscellaneous

• How to ... instructions for running JSPs, servlets, DataArchitect; setting up web pages, SQL*Plus, JDBC, etc.
• Relational Algebra Symbols in MS Word fonts by Professor Holowczak, City University of New York
• Lecture notes on Relational Algebra by Professor Holowczak, City University of New York
• Notes on the Oracle DBMS on standford.edu: a set of useful links to the use of Oracle DBMS.
• Web site for Oracle Programming, A Primer, by R. Sunderraman - code samples download available.

Design tools

• ERwin Data Modeler
• PowerDesigner Data Architect: