Book review: “Oracle Advanced PL/SQL Developer Professional Guide” by Saurabh K. Gupta (Packt Publishing)Posted by: Andrei in Database, Oracle, Programming
I’ve been asked by Packt to review one of their last books on Oracle, “Oracle Advanced PL/SQL Developer Professional Guide“.
Like many of the Packt books, it’s highly recommended to read the subtitle as well, in this case “Master advanced PL/SQL concepts along with plenty of example questions for 1Z0-146 examination”.
So in case you’re preparing for this Oracle University exam and ready to become “Oracle Advanced PL/SQL Developer Certified Professional“, this book is a good start.
The structure of the book if following in detail the 1Z0-146 exam topics and the user will find a separated chapter for each topic, exactly in the same order, which makes the book a very good companion when preparing for exam. The examples used trough the book are clear and easy to understand. Starting chapter 7 onwards there are topics with high applicability like SecureFiles, tuning, caching, profiling and tracing and SQL Injection prevention techniques that should be read by every Oracle PL/SQL developer but are not very well understood and unfortuntely underused by the community.
If the reader is not necessarily keen to take the exam, he can then switch to Oracle documentation available on tahiti.oracle.com, where he can read more about each of the topics in the book and many other advanced PL/SQL topics that Oracle University didn’t include in the exam curriculum.