• Title Oracle Advanced PL/SQL Developer Professional Guide
• Author(s) Saurabh K. Gupta
• Publisher: Packt Publishing; 1st edition (May 16, 2012)
• Paperback 440 pages
• eBook PDF
• Language: English
• ISBN-10: 9781849687225
• ISBN-13: 978-1849687225
• Share This:  

Book Description

This book is packed with real world examples that cover all the advanced features of PL/SQL. In turn, each major certification topic is covered in a separate chapter that makes understanding concepts easier. At the end of each chapter, you will find plenty of practice questions to strengthen and test your learning.

If you are a PL/SQL developer looking for deeper insight and a move from mid-level programmer to professional database developer, then this is the best guide for you.

This book is also an ideal guide for all the Associate level PL/SQL programmers who are preparing for the Professional 1Z0-146 certification. This book assumes you have prior knowledge of PL/SQL programming.

The book covers the advanced features of PL/SQL which are required to design and optimize the PL/SQL code in database applications. The features like collections, external procedures, server side result caching, enforce row level security using VPD, handling large objects and SecureFiles build up a concrete platform for a PL/SQL professional. Apart from the programming, the book makes instrumental recommendations on the usage of development tool SQL Developer, employing best practices in database environments and safeguarding the vulnerable areas in PL/SQL code to avoid code injection.

• Saurabh K. Gupta is a seasoned database technologist with extensive experience in designing high performance and highly available database applications. His technology focus has been centered around Oracle Database architecture, Oracle Cloud platform, Database In-Memory, Database Consolidation, Multitenant, Exadata, Big Data, and Hadoop.

• Amazon
• Amazon (1st edition)

• Oracle Databases
• SQL - The Structured Query Language
• Database Theory and Systems
• Books by Packt®

• Oracle Advanced PL/SQL Developer Professional Guide (Saurabh K. Gupta)
• The Mirror Site (1) - PDF
• The Mirror Site (2) - PDF

• Oracle Database Notes for Professionals

  This book is the definitive guide to undocumented and partially-documented features of the Oracle Database server. It helps you learn to apply the right solution at the right time, about avoiding risk, about making robust choices related to Oracle databases.

• Oracle for Absolute Beginners: An easy-to-follow introduction

  This book introduces the reader to Oracle programming, from SQL and PL/SQL to the more academic subjects of database design, normalization and the characteristics of an effective developer.

• Oracle Database Concepts (Michele Cyran)

  This book describes all features of the Oracle database server, an object-relational database management system. It describes how the Oracle database server functions, and it lays a conceptual foundation for much of the practical information.

• The Underground PHP and Oracle Manual (Christopher Jones, et al)

  This book is designed to bridge the gap between the many PHP and the many Oracle texts available. It shows how to use the PHP scripting language with the Oracle database, from installation to using them efficiently.

• The Oracle PHP Cookbook (John Alphonse, Justin Kestelyn)

  This book is designed to bridge the gap between the many PHP and the many Oracle texts available: web or enterprise developer looking to combine the robustness of the Oracle engine with the simplicity, performance, and ease-of-use of PHP.

• Database Design and Implementation using Oracle SQL

  This book uses a simple step by step approach to explain the essential relational database design modelling techniques, and shows how Oracle SQL can be used to implement a database. There are numerous practical exercises with feedback.

• O'Reilly® Oracle Essentials: 4th Edition, Oracle Database 11g

  This book distills an enormous amount of information about Oracle into a compact, easy-to-read volume filled with focused text, illustrations, and helpful hints.

• Oracle Performance Tuning with Solid State Disk (Mike Ault, et al)

  This book delivers up-to-the-minute practical guidance that empowers DBAs to target SSD technology to those database areas that will benefit most.

• Oracle Data Warehousing Guide

  Provides an overview of the components needed to produce an Oracle data warehouse: project planning; data scrubbing; metadata; data modelling; star schema; spatial challenges; security; backup and recovery; tuning loads; data mining; and data marts.

• High Performance Oracle Database Automation: SQL and PL/SQL

  This book emphasizes application development skills-not Oracle product internals or syntax. Covers strong use of Oracle's PL/SQL extensions.

• O'Reilly® Oracle PL/SQL Programming, 5th Edition (S. Feuerstein)

  This book is the definitive reference on PL/SQL, considered throughout the database community to be the best Oracle programming book available.

• O'Reilly® The Oracle PL/SQL CD Bookshelf, 7 Bestselling Books

  The Oracle PL/SQL CD Bookshelf contains a powerhouse of Animal books for the Oracle PL/SQL developer - all readable with your web browser on a convenient CD-ROM.

• OCA: Oracle 10g Administration I Study Guide (1Z0-042)

  Here's the book you need to prepare for the Oracle Database 10g Administration I exam, 1Z0-042. This Study Guide was developed to meet the exacting requirements of today's Oracle certification candidates.