Table of Contents

• Chapter 1: The Relational Model
  • Relational Database
  • Integrity Constraints
  • Tabular View of a Relation
  • Sample Databases
  • Relational Algebra
• Chapter 2: Oracle SQL
  • Oracle SQL*Plus
  • Creating, Dropping and Altering Tables
  • Inserting Rows
  • Querying the Database
  • Views
  • Modifying the Database
  • Sequences
  • Oracle Data Dictionary
  • Oracle8 Object Features
• Chapter 3: Embedded SQL
  • Host Variables
  • Indicator Variables
  • SQL Communications Area (sqlca)
  • Connecting to Oracle
  • Cursors
  • Mail Order Database Application
  • Recursive Queries
  • Error Handling
  • Transaction Control
  • Dynamic SQL
  • Pro*C++
• Chapter 4: PL/SQL
  • What is PL/SQL?
  • Datatypes and Variables
  • Program Control Statements
  • Program Structure
  • Triggers
  • Database Access using Cursors
  • Records
  • PL/SQL Tables
  • Built-In Packages
  • Error Handling
  • PL/SQL Access to Oracle8 Objects
• Chapter 5: Oracle JDBC
  • What is JDBC?
  • A Simple JDBC Program
  • Developing JDBC Applications
  • Nonquery SQL Statements
  • Executing SQL Queries
  • Grade Book Application
  • Database Metadata
  • Errors and Warnings
• Chapter 6: SQLJ: Embedded SQL in Java
  • What is SQLJ?
  • Simple Example
  • Compiling SQLJ Programs
  • Multiple Connections
  • Host Variables and Expressions
  • SQLJ Iterators
  • Dynamic SQL using JDBC
  • Calling PL/SQL within SQLJ
  • Investment Portfolio Database Application
• Chapter 7: Projects
  • Airline Flight Information Systems
  • Library Database Application
  • University Student Database
  • Video Chain Database
  • Banking Database
  • BibTeX Database
  • Music Store Database
  • Online Auctions Database
  • Oracle Data Dictionary Browser