The Oracle Advanced PL/SQL Developer Professional Guide book review

July 1st, 2012 | Posted in Reviews | 3 Comments


The author Saurabh K. Gupta has successfully managed to write an excellent book about Oracle PL/SQL. The book name is: Oracle Advanced PL/SQL Developer Professional Guide.

From the concept to the syntax, this book covers what is needed to know to prepare the 1Z0-146 certification exam. It focuses on concepts, and lot of examples. If you want to learn or improve your PL/SQL knowledge, this book is for you.

The first two chapters focus on the PL/SQL concepts and design. Chapter 3 talks about Collections ; Nested tables, VARRAY with exercises.

The book also talks about external routines ; executing C and Java programs. In this book, Saurabh demonstrates how to implement VPD (Virtual Private Database).

Chapter 6 and 7 explain the use of Large objects; LOB; CLOB, BLOB and BFILE also, the 11g SecureFile LOBs.

The chapter 8 and 9 talk about Tuning methods and techniques to improve Performance; the 11g Result Cache, Tuning PL/SQL code and compilation techniques.

The book also explain tracing methods and Profiling.

The book contains a lot of tips , techniques and exercises to help you to achieve the 1Z0-146 certification exam.

In summary, the author Saurabh K. Gupta has produced a work of great quality and value. I recommend this book to all PL/SQL developers; beginners and advanced programmers.

Find the Oracle Advanced PL/SQL Developer Professional Guide book on: Packtpub | Amazon



3 Comments to “The Oracle Advanced PL/SQL Developer Professional Guide book review”

  1. Hi Wissem,

    Thanks a lot for the positive feedback. I am happy that my contributions are recognized from community experts…

  2. I genuinely apрreciated your site! You shoulԁ update it wiϳth new info!


Leave a Comment





Polls

which oracle topic interests you most?

View Results

Loading ... Loading ...


Oracle Class Tweets


Recent Posts


Recent Comments

  • T Robinson: In regard to the comment “In our case, RMAN didn’t found anything corrupted.” Please notice...
  • iftikhar: if we backup in multiple backupsets and will be command for restoring for more than one backupsets ,
  • Abey: Very helpful article.Thanks a lot. Can we follow this on oracle DG enabled deployment also?
  • Mauricio Daher: Need help configuring SBT for cloud backups. Does not seem to work for 12c. Thanks! RMAN>...
  • Leszek K: *.db_create_file_dest=’+ DATA’ create database command – why do you use full datafile...
  • Prabhakar Kumar: Thanks buddy!!! It really helps to DBAs who are novice to 12c ASM feature.
  • Wubeshet: I am getting the ORA-07445 This morning on the trace file. The following is the symptom of the problem. It...
  • Lakshmi N: Hi Thanks for the post. Just curious, is there a way to restore to a point wher my db is in no archive...
  • Shivakkumar P: This is really very good article. Iam learning Oracle 12c I used this to replicate testing from...
  • Uday: Hi Wissem, Once we apply the level 1 incremental backup to datafile copy it is no longed required. My question...
  • avnish: Can I set up active duplicate database in 11g standard edition (11.2.0.1)
  • Jaya V: hi, am having rman backup. i need to restore on it, from test instance. But the test instance name not same...
  • Jaya: hi, am having rman backup. i need to restore on it, from test instance. But the test instance name not same...
  • wissem: SQL Developer 4.0
  • oracleman consulting: great info thanks for sharing
  • Mike: Very nice article!! Thanks for sharing!!
  • yathish: I really appreciate if you can send me, if you have tutorial for 11g (11.2.0.1) RAC & ASM (prefer to be...
  • Farrukh Kamal: Fahad, I’m interesting in pursuing remote employment with Pythian. What tips would you suggest...
  • pavankumar: for the error it need to set env correctly http://orcl11gdba.blogspot.in/ 2014/08/asmcmd-08102-no-con...
  • wissem: Post result off; crsctl check has crsctl check crs

Oracle-Class Forums Latest Activity