This title includes: Section - I: Setting Up Oracle 9i, Database Concepts, Installation Of Oracle 9i, Post Installation Steps, Setting Up Interactive Sql Plus, Section - Ii: Setting Up The Business Model, A Business Model For Retail Banking, Project Planning For The Retail Banking Model, Section - Iii: Structured Query Language (Sql), Interactive Sql Part-I, Interactive Sql Part - Ii, Interactive Sql Part - Iii, Interactive Sql Part - Iv, Section - Iv: Advance Sql, Sql Performance Tuning, Security Management Using Sql, Oops In Oracle, Advance Features In Sql Plus, Section - V: Pl / Sql, Introduction To Pl/Sql, Pl / Sql Transactions, Pl/Sql Security, and, Pl/Sql Database Objects.
Table of Contents:
SECTION – I: SETTING UP ORACLE 9i
1. DATABASE CONCEPTS
2. INSTALLATION OF ORACLE 9i
3. POST INSTALLATION STEPS
4. SETTING UP INTERACTIVE SQL *PLUS
SECTION – II: SETTING UP THE BUSINESS MODEL
5. A BUSINESS MODEL FOR RETAIL BANKING
6. PROJECT PLANNING FOR THE RETAIL BANKING MODEL
SECTION – III: STRUCTURED QUERY LANGUAGE (SQL)
7. INTERACTIVE SQL PART – I
8. INTERACTIVE SQL PART –II
9. INTERACTIVE SQL PART – III
10. INTERACTIVE SQL PART – IV
SECTION – IV: ADVANCE SQL
11. SQL PERFORMANCE TUNING
12. SECURITY MANAGEMENT USING SQL
13. OOPS IN ORACLE
14. ADVANCE FEATURES IN SQL *PLUS
SECTION – V: PL / SQL
15. INTRODUCTION TO PL/SQL
16. PL / SQL TRANSACTIONS
17. PL/SQL SECURITY
18. PL/SQL DATABASE OBJECTS
APPENDIX