[Main Page]      [INFSCI 2711]      [Grades DB]      [Literature]      [Software]      [People]      [Conferences]      [Courses]      [Web-DB]

Course Homepages

• INFSCI 2710 "Database Management" (Spring 2000)
• INFSCI 2711 "Database Analysis and Design" (Fall 1999)
• INFSCI 2710 "Database Management" (Summer 1999)
• INFSCI 2710 "Database Management" (Spring 1999)

Course Materials

Transparencies:

• Transparencies of the Summer 1999 Course (current)
• Transparencies of the Spring 1999 Course (old)

Homeworks:

• Homeworks of the Summer 1999 Course
• Homeworks of the Spring 1999 Course

Example Databases:

• Presidental Database
• Grading Database
• The UCI KDD Archive

Examples for Application Programs with Embedded SQL:

• C-Program with Embedded SQL: demo.pc   [makefile]
  Tabulator characters in makefiles are important. If you get the error 'Incorrect macro assignment', they probably were replaced by spaces. The warnings by the compiler are normal, Pro*C doesn't generate very nice C (but it works).

Examples for CGI-Programs:

• Simple GCI Program in Pro*C   [makefile]   [demo]
• The same application in sh/SQL*Plus   [SQL*Plus Script]   [demo]
• CGI-Program with Form Input in Pro*C   [makefile]   [demo]
• Sources of the Grading Database

Examples for ODBC-Programs:

• Simple ODBC Program

Tools:

• Aladdin Ghostscript can be used for printing Postscript files.
• GNU Ghostscript older Version, with more liberal license.

Documentation:

• Oracle Documentation (only local)
• Oracle Developer/2000 Quick Tour (only local)

Oracle Certified Professional Program

• Oracle Education
• OCP Homepage
• Test Registration
• OTN Discount (until May 31, 2000)
• Download Free Assessment Tests
• Self Test Software (Oracle Page)
• Self Test Software
• Jason S. Couchman:
  Oracle 8i Certified Professional: DBA Certification Exam Guide With CDROM.
  Osborne / ORACLE Press, August 1999, ISBN 0072120878, 1200 pages, $99.99.
  [Best Book Buys Price Comparison] [Buybooks.Com Page]
• My Impressions about the First Exam (SQL and PL/SQL)
• My Impressions about the Second Exam (DB Administration)
• My Impressions about the Third Exam (Backup and Recovery)
• My Impressions about the Forth Exam (Tuning)
• Oracle eLearning FastTrack (expensive)
• Animated Learning.Com
• DBA Jobs.Com

Information Sources in the Web

• Information about the DBS Course of my former collegue Michael Gertz
• DBWORLD Email List
• Database Systems and Logic Programming (Bibliography Server)
  • Database research Groups
• Transaction Processing Performance Council (TPC)
• ACM Digital Library
• Bibliographies about Database Research (Karlsruhe)
• Database Systems Laboratory, Univ of Massachusetts (Collection of Links)
• SQL Standards
• Object Database Management Group (ODMG)
• ACM SIGMOD (Special Interest Group on Mangament of Data)
  Join ACM SIGMOD or Find your Membership Number
• Bibliography on Data Warehousing and OLAP
• WWW-Links collected by Michael Gertz (Universität Hannover)
• Yahoo! Page about Databases
• Bibliographie about Data Warehousing (Alberto Mendelzon)
• Database Resources (G. Falquet, University of Geneva)
• Wiederhold Database Query [Bibliography by Gio Wiederhold]
• Database Group of my Former Collegue Michael Gertz
• CoRR -- A Computing Research Repository (More Information)
• Online Database Seminars
• A.B. Chaudhri: Object Technology 97 Tutorial
• System R Page
• NSF sponsored Workshop on Industrial/Academic Cooperation in Database Systems
• LAMP-Project (Uni Passau): Tutoring System for DB-Desig

Stefan Brass (sbrass@sis.pitt.edu), May 28, 1999

Original URL: http://www2.sis.pitt.edu/~sbrass/db/   [HTML 3.2 Checked]