Oracle For Beginners
By Srikanth Pragada
Description
The aim of this free book on Oracle is to teach beginners how to use Oracle to store, retrieve, manipulate and process the data. This book starts with fundamentals of relational database management system and goes upto advanced topics such as native dynamic sql and distributed database.
Contents
- Introduction to RDBMS
- Introduction to Oracle
- Getting started with Oracle8i
- Creating sample tables
- Changing structure and data
- Arithmetic and Date Functions
- String, Conversion,and Miscellaneous functions
- Grouping Data
- Joining Tables
- Views
- Subqueries
- Indexing, clustering, sequence, and pseudo columns
- Security
- Report Generation using SQL*PLUS commands
- Introduction to PL/SQL
- Control structures
- Exception handling
- Cursor Handling
- Procedures,functions and packages
- Database Triggers
- LOBs
- Object Types
- VARRAY and Nested Table
- Native Dynamic SQL
Book Details