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.

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

Ivan Bayross