Description:

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 Retail Banking System.The skill thus developed are strengthened and grown via hands on exercises based on the construction of Sales Order System.

Table Of Contents:

  1. Introduction To Database
  2. Data Models and Data Integrity
  3. Normalization
  4. Oracle 9I Architecture
  5. Tablespace In Oracle
  6. Users, Roles and Privileges
  7. Creating Database
  8. A Business Model for Retail Banking
  9. Project Planning for the Retail Banking Model
  10. Interactive SQL Part-1
  11. Interactive SQL Part-2
  12. Interactive SQL Part-3
  13. Interactive SQL Part-4
  14. SQL Performance Tuning
  15. Oracle Object Oriented Features
  16. Introduction to PL/SQL
  17. Cursors and Exceptions
  18. PL/SQL Database Objects
  19. Import and Export of Data