Oracle Advanced PL/SQL Developer Professional Guide - Softcover

Gupta, Saurabh K.

Softcover

ISBN 10: 1849687226 ISBN 13: 9781849687225

Publisher: Packt Pub Ltd, 2012

Synopsis

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 "1Z0-146: Oracle Database 11g: 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.

About this title

From the Author

It has been a great experience to author first book on "1Z0-146: Oracle Database 11g: Advanced PL/SQL" certification. Thanks to Packt for giving me this opportunity and many thanks to my ACE reviewers for sharing their feedback on my work. Try the Advanced PL/SQL OCP Mock Assessment test here - sbhoracle.wordpress.com/my-book-on-advanced-plsql-concepts/advanced_plsql_mockassessment/ 

About the Author

Saurabh K. Gupta works as Principal Technologist, Database Product Management at Oracle Corporation. He is the author of Packt's "Oracle Advanced PL/SQL Developer Professional Guide" [ISBN 1849687226]. He has been synchronizing his on job and off job interests with Oracle databases since last six years. His areas of expertise are Database architecture, PL/SQL development, Performance Tuning, and High Availability. 

He has the OCP 11g Advanced PL/SQL certification to his belt. He has been an active Oracle blogger and OTN forum member. He has published more than 70 articles on online forums and journals. His work can be seen in RMOUG journal, PSOUG, dbanotes, and Exforsys. He shares his technical experience through his blog sbhoracle.wordpress.com/. Reach out to him through his blog to get in touch with him.

Edition details

• Publisher: Packt Pub Ltd
• Publication date: 2012
• ISBN 10: 1849687226
• ISBN 13: 9781849687225
• Binding: Paperback
• Language: English
• Edition number: 1
• Number of pages: 416