Mastering Database Technologies

The book has been written to provide an excellent grounding to those who wish to learn database technologies using Oracle. This book has several illustrative examples.which have a logical link between them. Each set of examples helps build skills that will take the reader to the next set of examples, which in turn leads upwards until a strong programming foundation using the natural language of Oracle has been established. The learning of database technologies is done through the construction of the Retail Banking System. The skill thus developed are strengthened and grown via hands-on exercises based on the construction of the Sales Order System.

Introduction To Database

Data Models and Data Integrity

Normalization

Oracle 9I Architecture

Tablespace In Oracle

Users, Roles, and Privileges

Creating Database

A Business Model for Retail Banking

Project Planning for the Retail Banking Model

Interactive SQL Part-1

Interactive SQL Part-2

Interactive SQL Part-3

Interactive SQL Part-4

SQL Performance Tuning

Oracle Object-Oriented Features

Introduction to PL/SQL

Cursors and Exceptions

PL/SQL Database Objects

Import and Export of Data

Ivan Bayross