Relational Database Systems and Oracle

Introduction to SQL, AQL*Plus, and SQL Developer

Data Definition, Part I

Retrieval: The Basics

Retrieval: Functions

Data Manipulation

Data Definition, Part II

Retrieval: Multiple Tables and Aggregation

Retrieval: Some Advanced Features

Views

Writing and Automating SQL*Plus Scripts

Object-Relational Features

About the Author

Lex de Haan studied applied mathematics at the University of Technology in Delft, the Netherlands. His experience with Oracle goes back to the mid-1980s, version 4. He worked for Oracle Corporation from 1990 to 2004 in various education-related roles, ending up in Server Technologies (product development) as senior curriculum manager for the advanced database administration curriculum. In that role, he was involved in the development of Oracle9i and Oracle Database 10g. In March 2004, he decided to go independent and founded Natural Join B.V. (http://www.naturaljoin.nl). From 1999 until his passing in 2006, he was involved in the ISO SQL language standardization process, as a member of the Dutch national body. He was also one of the founding members of the OakTable network (http://www.oaktable.net).

Table of Contents

About the Author