Oracle Advanced PL/SQL Developer Professional Guide

by Saurabh Gupta

The OCP certification is the second milestone for the experienced associate level Oracle professionals which enhances one's credibility in work environment, and catalyzes your employment opportunities. The Packt's book Oracle Advanced PL/SQL Developer Professional Guide helps you to master the advanced PL/SQL concepts in Oracle 11g. The book aims to be a sure selection for the experienced Oracle professionals aspiring for Professional level by writing Oracle certification exam "1 Oracle Database 11 Advanced PL/SQL" . The topics covered in the book are in line with the Oracle University prescription for 1Z0-146 certification, which justify the version updates to be advanced and not complex. The book has been reviewed by Oracle ACEs Kamran Agayev, Ronald Rood, Mohan Dutta, and Marcel Hoefs.  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.

440 pages, Paperback

First published May 16, 2012

About the author

Saurabh K. Gupta is a technology leader, published author, and data enthusiast with more than a decade of experience in data architecture, engineering, development, and administration. Working as Data & Analytics Manager at GE, he focusses on data lake analytical programs to build digital solutions for business stakeholders. In the past, he has worked extensively with Oracle database design and development, PaaS and IaaS cloud service models, consolidation, and in-memory technologies. Prior to authoring "Practical Enterprise Data Lake Insights" with Apress in 2018, he worked with Packt publishing for "Advanced Oracle PL/SQL Developer's Guide" in 2016, and "Oracle Advanced PL/SQL Developer Professional Guide" in 2012. He is a frequent speaker a conferences organized by the data and analytics user community and technical institutions. He tweets at @saurabhkg and blogs at sbhoracle.wordpress.com.

Reviews

[Ivo Stoykov · Rating 5 out of 5]

Very good book. Well organized, up to the point without exceeding common sense volume. Short and clear examples, easy to reproduce the same result. Good for developers and DBA.

[Pankaj Kumar]

comment

[Delhi Irc]

Location: ND5 IRC
Accession no: DL027010

[Saurabh Gupta · Rating 5 out of 5]

The book has been reviewed by Oracle ACEs Kamran Agayev, Ronald Rood and Mohan Dutta.