• Help documents on Oracle: Over the years we've developed a number of popular documents that contain much of the information you will need for using Oracle. Some of the information is specific to our installation of Oracle and some of it is more general. These documents may be updated during the course, and we will let you know whenever that happens.

• Oracle Technology Network: Very useful comprehensive technical information on Oracle. You need to register, but it's free to do so.

• Students have found that an effective way of finding information about Oracle error codes (and how to fix them!) is to go to your preferred search engine -- or better yet try Google Groups -- and search for "oracle" together with your error code.

• SQL for Web Nerds: This somewhat aging but still useful online manuscript by Philip Greenspun of MIT has many examples, anecdotes, and suggestions specific to Oracle. Particularly useful may be the section on Dates (somewhat more coverage than our local help document on the topic) and the section on Limits.

• JSP and JDBC:
  • JSP Tutorial
  • JavaServer Pages (JSP)
  • JDBC Tutorial

• XML DOM interfaces:
  • For Java users, see package org.w3c.dom
  • For C++ users

• PHP Manual. Please remember that PHP is not supported by the course staff.

Other Support Materials

• Details on interfacing with Stanford's Solaris machines

• A Word document with relational algebra symbols, handy for copy-and-pasting into your assignment.

• Help document on mySQL. mySQL is the SQL variant and underlying system used in the Gradiance SQL Labs

• Data from Gradiance SQL labs, in csv format, in case you want to load it in a DB and play around with queries outside of Gradiance.