Oracle For Beginners By Srikanth Pragada

By Admin On Oct 9, 2017

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

Author(s): Srikanth Pragada
Format(s): PDF
File size: 2.65 MB
Link: Download.