SQL, PL/SQL – The Programming Language of Oracle

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:

Database Concept
Installation Of Oracle
Post Installation Steps
Setting Up Interactive SQL Plus Tools
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
Security Management Using SQL
OOPS in Oracle
Advance Features in Sql Plus
Introduction To PL/SQL
Pl/SQL Transactions
PL/SQL Security
PL/SQL Database Objects