Please recommend askDavid.com
   using these social sharing buttons:
David

Books:  

  
   

    

  book details  

  books by asim chowdhury  

  updates  

   

 

Book: ORACLE SQL & PL/SQL Golden Diary - Refactoring, Interoperability of Versions & Integration of related concepts for High Performance by asim chowdhury

Book: ORACLE SQL & PL/SQL Golden Diary - Refactoring, Interoperability of Versions & Integration of related concepts for High Performance by asim chowdhury

star rating  5 stars, 1 review on Amazon
categories: Book, Oracle PL SQL, SQL Diary, Oracle Interoperability, Oracle Refactoring, SQL Refactoring, Oracle Performance, Performance Tuning, Oracle Integration, Data Migration, Data Analyst, Oracle SQL




asim chowdhury

Author asim chowdhuryabout this book: This book covers three aspects

1: Interoperability among database versions
2: Integration of related concepts for performance
3: Creation of Golden Diary in a nutshell by practical examples

These intentions have been arisen based on the burning need of database users I have come across throughout my career with roles like PL/SQL developers , Database Administrators, Designers, Data analysts, Performance tuning analysts, Architects, Students, Professors, Interviewees and any DBMS enthusiast or aspirant for oracle certification. Some of these had extensive experience in what they do and have influenced me writing this book.

This is an example/research oriented book which will let you navigate between different releases of oracle using alternative approaches to derive similar functionality in different versions of database. For example "Truncate table cascade in 12c and approach prior to 12c" and "Sensitive data masking using REDACTION in 12c and prior to 12c" highlight the intention. Also this book will let you integrate related concepts so that you can ponder over different similar concepts and choose the best option to achieve the best response time and throughput. Examples like "nested loop Join or hash join or parallelism or multi-threading" , "Oracle Object CACHE Using Cache or Keep buffer pool or Oracle 12c IN-MEMORY column store " and "Result cache function or deterministic function or PL/SQL collection" highlight the intention.

This book will act as a reference guide for learning some very complicated concepts in a simple but precise way which are discussed through various case studies. This will give food for thought while devising mechanism for best possible approach for a database solution given the circumstances.

You will learn

-Comparative analysis of database features and their usages across Oracle versions
-Learn to derive alternate approach for a functionality in different releases of database
-Learn related concepts associated with specific challenge
-Learn to choose the best approach from the set of related concepts to achieve best result
-Familiarize yourself with all concepts with real life example in a nutshell
-Learn how to be smart with database and surprise your colleague and boss by your solution

The audience of this book would like to cover multiple versions of Oracle and the features it offers. Seeking the best approach for a challenge has not been easy in past as it required a large investment of time and effort to go through the vast amount of documentation. This 270 pages book facilitates that investment, by exploring and churning the vast archives of oracle documentation and producing the output in a nutshell which otherwise readers would need to spend time on.

Click here to read sample chapters from this book



what to read next: if you read and liked this book...



Learn more about this book,  Read reviews  or  Add to wish list

Find the best offer for this book

▾ reviews voted most helpful on amazon.com ▾


 Read more reviews or Submit your own review 







This book on




Comments





Recommendations








Books:  

  
   







More Reviews

   • Book Review: Practical SQL by David Perry
   • Book Review: Two Paths Crossing - Then and Now by John Swisher



  show list of all published reviews | subscribe to the feed


Home | Contact | Legal Notice | Impressum Book Promotion | Do you like askDavid.com? | Boost Your Karma