Oracle Advanced PL/SQL Developer Professional Guide – Download Free PDF
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.