ORACLE SQL & PL/SQL Golden Diary: Refactoring, Interoperability of Versions & Integration of related concepts for High Performance
Imported Edition - Ships in 18-21 Days
Free Shipping in India on orders above Rs. 500
Imported Edition - Ships in 18-21 Days
Free Shipping in India on orders above Rs. 500
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.
Asim Chowdhury has 15 years of experience in architecting and designing data modelling of complex applications, leading database development, support & consultancy for payment solutions, smart metering solutions for Financial and Energy & Utility business domain. Prior to joining Logica (Currently CGI UK), he was with Oracle Corporation as a Senior Analyst and was leading the Language Division of Oracle Worldwide Support. He was responsible for design and development of new features of Oracle 11g beta release. He was leading the team responsible for Severity 1 High value issues for some of Oracle's high profile potential customers like Fidelity, NASA, HP, Cisco, Sun, Boeing, Citibank, HSBC, Dell, Lucent, Qantas, and Sun Microsystems. He has published many technical articles and papers, which are available in Oracle support website www.metalink.oracle.com. He has also written a Technical Guide Reference Book - "Oracle SQL and PL/SQL Guide Till 10gR2" on Oracle concepts and provided guidance on SQL & PL/SQL. He has been interviewed by internal magazine of Logica for his extraordinary performance which led to the launch of the Citibank product in Europe, Amsterdam. The product was highlighted in Business wire Magazine, London.
• Author(s): Clear | James • Publisher: Penguin • Publisher Imprint: Penguin Random House • Subject: General Books
• Author(s): Jeff Kinney • Publisher: Penguin Random House Children's UK • Publisher Imprint: Penguin Random House Children's UK • BISAC: Comics & Graphic Novels - Humorous
• Author(s): Ichiro Kishimi • Publisher: GROVE ATLANTIC • Publisher Imprint: Allen & Unwin • BISAC: Personal Growth - SuccessIchiro Kishimi lives in Kyoto. He writes, lectures and teaches in psychiatric clinics as a certified counsellor and c...
View full details• Author(s): Chetan Bhagat • Publisher: HarperCollins Publishers India • Publisher Imprint: HarperCollins Publishers India • BISAC: GeneralFrom India's top-selling writer Chetan Bhagat comes a powerful new love story that will make you laugh, cry...
View full details• Author(s): Brianna Wiest • Publisher: Manjul Publishing • Publisher Imprint: Amaryllis • BISAC: Body Mind And SpiritThis is a book about self-sabotage. Why we do it, when we do it, and how to stop doing it—for good. Coexisting but conflicting n...
View full details• Author(s): Morgan Housel • Publisher: Pan Macmillan • Publisher Imprint: Pan Macmillan • BISAC: Finance - Wealth ManagementA third book from the International bestselling author of The Psychology of Money and Same as Ever, lessons on harnessing...
View full details• Author(s): Arundhati Roy• Publisher: PRH INDIA LOCAL PRINT• Publisher Imprint: Penguin Hamish Hamilton• BISAC: Literary FiguresArundhati Roy’s first work of memoir, this is a soaring account, both intimate and inspiring, of how the author became...
View full details• Author(s): Acharya Prashant • Publisher: HarperCollins Publishers India • Publisher Imprint: HarperCollins Publishers India • BISAC: GeneralIn a world where vagueness is mistaken for depth and obscurity passes for wisdom, Truth without Apology ...
View full details• Author(s): Sudha Murthy • Publisher: India Puffin • Publisher Imprint: India Puffin • BISAC: Short StoriesWho can resist a good story, especially when it's being told by Grandma? From her bag emerges tales of kings and cheats, monkeys and mic...
View full details• Author(s): Satoshi Yagisawa • Publisher: Bonnier Books Ltd • Publisher Imprint: Bonnier Books Ltd
• Author(s): Newport, Cal • Publisher: Little, Brown Book Group • Publisher Imprint: Piatkus
• Author(s): Shrijeet Shandilya • Publisher: Ebury Press • Publisher Imprint: Ebury Press • BISAC: Romance - GeneralIn the electric haze of college life, three friends are bound by laughter, late-night talks and unspoken promises. But when two of...
View full details• Author(s): Dan Brown • Publisher: Transworld Publishers Ltd • Publisher Imprint: Transworld Publishers Ltd • BISAC: Thrillers - EspionageDan Brown is the bestselling author of Digital Fortress, Deception Point, Angels and Demons, The Da Vinci C...
View full details• Author(s): Sudha Murty • Publisher: India Puffin • Publisher Imprint: India Puffin • BISAC: Action & Adventure - General
Rich Dad Poor Dad: What the Rich Teach Their Kids about Money That the Poor and Middle Class Do Not!
• Publisher: Penguin • Publisher Imprint: Penguin Random House • Subject: General Books • BISAC: Personal Finance - GeneralApril of 2022 marks a 25-year milestone for the personal finance classic Rich Dad Poor Dad that still ranks as the #1 Pers...
View full details• Author(s): Dale Carnegie | Napoleon Hill • Publisher: Fingerprint • Publisher Imprint: Fingerprint • Subject: General Books
• Author(s): Freida Mcfadden • Publisher: Penguin Select Print • Publisher Imprint: Penguin Select Publishing"Multi-Million Copy Bestselling Series •Now Being Made Into a Major Motion Picture Starring Sydney Sweeney and Amanda Seyfried #1 New Yor...
View full details• Author(s): Wonder House Books • Publisher: Wonder House Books • Publisher Imprint: Wonder House Books • BISAC: Comics & Graphic Novels - Fairy Tales, Folklore, Legends & MTimeless Wisdom, Talking Animals & Life Lessons for Young Min...
View full details• Author(s): Viktor E. Frankl • Publisher: Random House • Publisher Imprint: Random Hou • Subject: Medical, Nursing and Health Sciences
• Author(s): Madhavi Bharadwaj • Publisher: PRH India • Publisher Imprint: Penguin Ebury Press • BISAC: Parenting - MotherhoodWelcome to the wild, messy, wonderful world of parenting--where the nights are long, the diapers are explosive, and unso...
View full details• Author(s): Vir Das • Publisher: HarperCollins Publishers India • Publisher Imprint: HarperCollins Publishers India • BISAC: Entertainment & Performing ArtsComedian and actor Vir Das is beloved (by some, tolerated by others, blocked by a few...
View full details• Author(s): Eric Carle • Publisher: Penguin Books, Limited (UK) • Publisher Imprint: Penguin Books, Limited (UK) • BISAC: Animals - Butterflies, Moths & CaterpillarsEric Carle's The Very Hungry Caterpillar is a perennial favourite with child...
View full details• Author(s): Prajakta Koli • Publisher: Harper Fiction India • Publisher Imprint: Harper Fiction India • BISAC: Romance - ContemporaryWinner of the Amazon India Popular Choice Debut Book 2025 Award. From one of India's most-loved creators comes s...
View full details