Description:

This book was written to try and provide an excellent grounding to those who wish to learn SQL and PL/SQL using Oracle. A through grounding in both is absolutely necessary to become a competent Oracle application programmer or DBA. The examples and hands on exercises help build your skills until a strong programming foundation using the natural language of Oracle has been established. The complementary CD-ROM accompanying this book provides the book codes as well as the solutions to the hands on exercises covered.

Table Of Contents:

  1. Database Concept
  2. Installation Of Oracle
  3. Post Installation Steps
  4. Setting Up Interactive SQL Plus Tools
  5. A Business Model For Retail Banking
  6. Project Planning For The Retail Banking Model
  7. Interactive SQL Part -1
  8. Interactive SQL Part -2
  9. Interactive SQL Part -3
  10. Interactive SQL Part -4
  11. SQL Performance Tuning
  12. Security Management Using SQL
  13. OOPS in Oracle
  14. Advance Features in Sql Plus
  15. Introduction To PL/SQL
  16. Pl/SQL Transactions
  17. PL/SQL Security
  18. PL/SQL Database Objects