ORACLE SQL & PL/SQL Golden Diary: Refactoring, Interoperability of Versions & Integration of related concepts for High Performance
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.