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


which oracle topic interests you most?

View Results

Loading ... Loading ...

Oracle Class Tweets

Recent Posts

Recent Comments

  • wissem: Post result off; crsctl check has crsctl check crs
  • ron: unable to connect to Cluster Synchronization Service
  • KevinB: Please post or attach the response file
  • nnarimanov: I’d like to clarify the reason why rman restores all datafiles into +DATA. It’s because of...
  • Sergio: Hi, Where is declared the function agent_clean() ? I dont see agent_clean() definition !! regards, Sergio
  • Sikandar: I do salute you brother, This is very………..nti mes helpful and correct documents. I...
  • Karthik Singh: Thanks for sharing a useful article. Looks like you have installed weblogic 10.3.4. Then shall I...
  • Joseph: Paul, Here target is from which database we are taking cloning. and auxilary is the cloning database. Wissem,...
  • sundar: In Doc ID 1472171.1 it says that the snapshot control file should be in a shared location for RAC databases....
  • Taoqir: Hello, This is a wonderfull and very helping I am going to configure Data Guard. Thanks
  • Adrian Iriarte: Saludos, Que buen articulo, casi siempre al momento de querer implementar soluciones para el...
  • Patricia: Hi Wissem, is there a workaround for this? I mean I want to use the sqlnet.authentication_services =none,...
  • Brian: I created the cdb manually using the instruction, but then I tried to create pdb within in, it failed. have...
  • Farmer Johnson: Hi Wissem. How did you avoid the error you had previsouly encountered: “sudo opatch auto...
  • Héctor Moro: Querido Nelson; Después de entrevistar a mas de 50 profesionales de primer nivel en Uruguay, al fin te...
  • What is NO2 Maximus: I genuinely apрreciated your site! You shoulԁ update it wiϳth new info!
  • Nav: Indeed helpful, to the point article..
  • Koti: Can you please explain all the sections of AWR report in RAC. I mean to ask output produced by awrgrpt.sql...
  • Himanshu: Nice post.can you please comment on this Why RMAN restored the DATA_REORTING datafie to +DATA diskgroup?
  • gabriel: what version of sqldeveloper support plugable database?