Loading

Learning Oracle 11g: A PL/SQL Approach

Learning Oracle 11g: A PL/SQL Approach

Learning Oracle 11g: A PL/SQL Approach is an example-based textbook written to cater the needs of the students and the professional developers who want to develop database management applications using Oracle SQL and PL/SQL. The chapters in this textbook are structured in a pedagogical sequence, which makes the learning process very simple and effective for both the novice as well as the advanced users of Oracle. In addition, the book follows the PL/SQL approach that will help you develop database applications with improved performance. A wide range of features of SQL and PL/SQL such as data manipulation and transaction, built-in functions, exception handling in PL/SQL, cursors and triggers, subprograms have been covered in the textbook that will enable the readers to take full advantage of this cutting-edge technology.

Authors
CADCIM Technologies, USA
Prof. Sham Tickoo, Purdue University Calumet, USA
ISBN
978-1-932709-62-9
Pages
512
Binding
eBook

Table of Contents

  • Chapter 1: Introduction to Oracle Database
  • Chapter 2: Introduction to SQL *Plus
  • Chapter 3: Retrieving Data in SQL
  • Chapter 4: Data Manipulation and Transaction
  • Chapter 5: Built-in Functions in Oracle
  • Chapter 6: Introduction to PL/SQL
  • Chapter 7: Exception Handling in PL/SQL
  • Chapter 8: Cursors and Triggers
  • Chapter 9: PL/SQL Subprograms
  • Chapter 10: PL/SQL Packages
  • Chapter 11: Oracle Database Security
  • Index

Salient Features

  • Each concept discussed in the book is exemplified by an application to clarify and facilitate better understanding.
  • This textbook introduces the key ideas to create database applications in an innovative way. The concepts are illustrated through best examples, covering the basic as well as advance aspects of Oracle.
  • Additional information is provided to the users in the form of notes.
  • There is an extensive use of examples, schematic representation, screen captures, tables, and programming exercises.

Reviews

Add a review

Your Rating


Subscribe to our Press Release

Subscribe