SQL, PL/SQL - The Programming Language of Oracle

This book was written to try and provide an excellent grounding to those who wish to learn SQL and PL/SQL using Oracle. A thorough 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.

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

Ivan Bayross