SQL Notes

Please refer to the pages linked below for help with the SQL labs and assignments:

• SQL setup (Lab 1 exercise for running SQL queries from CRON and WinAthena PCs)
• SQL help
• PARCELS database
• Outer Join help
• ZONING database
• Zoning Variances
• 1980 Census data (by Boston NSA)
• Schema of Decision, Use, NSA, Neighbrhd Lookup Tables
• Sub-Neighborhood lookup table
• SQL examples using zoning variances
• Grouping zoning applicants via 'lookup' tables
• Zoning Variance Database Evolution Chart
• SQL*Plus Formatting and Documentation Notes
• URISA Proceedings database and sample SQL queries
• Oracle 8i Documentation
  Available online at http://download-west.oracle.com/docs/cd/A87860_01/doc/server.817/index.htm
  The documentation is generally available both in HTML format (good for viewing online in a browser) and PDF format (better for printing). You will be prompted to set up a (free) account* before you can access these documents on the Oracle site.
  
  Particularly useful references:
  • Oracle 8i SQL Reference. This is the authoritative reference for Oracle's flavor of SQL.
  • SQL*Plus Quick Reference. A concise guide to SQL*Plus commands.
  • SQL*Plus Reference. The full SQL*Plus manual.
  • Oracle 8i Designing and Tuning for Performance. Suggests ways to tune queries and database designs to improve performance. Offers insights into how Oracle operates.
  • Oracle 8i Error Messages. Provides extra information about Oracle's sometimes cryptic error messages.

  
  * Note: To access this documentation you will need to register for a free membership to the Oracle Technology Network. To register, click the 'My Profile' button in the upper right portion of the page and then complete and submit the registration form.

For more information about this page, please contact the 11.521 Staff Mailing List <11.521staff@MIT.EDU>.
Last modified: 4February 2003 [jf]