(Ebook PDF) Modern Oracle Database Programming Level Up Your Skill Set to Oracles Latest and Most Powerful Features in SQL PLSQL and JSON 1st Edition by Alex Nuijten 1484291662 9781484291665 full chapters

Modern Oracle Database Programming: Level Up Your Skill Set to Oracle’s Latest and Most Powerful Features in SQL, PL/SQL, and JSON 1st Edition by Alex Nuijten – Ebook PDF Instant Download/DeliveryISBN:  1484291662, 9781484291665 

Full dowload Modern Oracle Database Programming: Level Up Your Skill Set to Oracle’s Latest and Most Powerful Features in SQL, PL/SQL, and JSON 1st Edition after payment.

Product details:

ISBN-10 :  1484291662 

ISBN-13 :  9781484291665

Author: Alex Nuijten

Level up your skill set to the latest that Oracle Database can offer. This book introduces features that are not well known that can transform your development efforts. You’ll discover built-in functionality that can save you massive amounts of time that otherwise would be spent reinventing the wheel. You’ll find that what used to take a lot of programming some years ago can be done with less code in a more reliable way today. Anyone using Oracle Database without the knowledge in this book is leaving valuable functionality–that their company has paid for–on the table, and this book opens the door to that functionality so that you can deliver reliable and performant solutions faster and more easily than ever. Part I looks at features in SQL and PL/SQL that are underused and not well known. You’ll learn about new join types, pattern matching across rows, Top N pagination (useful in reporting!), qualified expressions, and enhancements to iterators that reduce code complexity and make your logic easier to understand. Part II covers how and when to invoke PL/SQL from SQL while maintaining performance. You’ll learn about SQL macro functions for creating reusable SQL fragments, polymorphic table functions with return types determined by incoming argument types, and constructing and parsing JSON documents for data interchange with other systems. Part III introduces a vast array of built-in functionality that Oracle provides that is just waiting to be used. Edition-based redefinition enables zero-downtime application and schema upgrades. Data redaction enables easier compliance with privacy laws and similar regulations by protecting sensitive data from those who have no need to see it. Virtual private databases provide the appearance of giving each user their own database, again helping to secure sensitive data. 

 Modern Oracle Database Programming: Level Up Your Skill Set to Oracle’s Latest and Most Powerful Features in SQL, PL/SQL, and JSON 1st Table of contents:

Part I. Advanced Basics
1. Underutilized Functionality and Enhancements
2. Analytic Functions and (un)Pivoting
3. Joins
4. Finding Patterns
5. Pagination and Set Operators
6. Conditional Compilation
7. Iterations and Qualified Expressions
Part II. Multiple Techniques and Languages
8. Polymorphic Table Functions and SQL Macros
9. Subquery Factoring, the WITH Clause, Explained
10. Calling PL/SQL from SQL
11. Storing JSON in the Database
12. Path Expressions in JSON
13. SQL/JSON and Conditions
14. Generate, Compare, and Manipulate JSON
Part III. Oracle-Provided Functionality
15. Useful APEX Packages
16. Processing Data in the Background
17. Introspecting PL/SQL
18. See What You Need to See
19. Upgrade Your Application with Zero Downtime
20. Choosing the Right Table Type

People also search for  Modern Oracle Database Programming: Level Up Your Skill Set to Oracle’s Latest and Most Powerful Features in SQL, PL/SQL, and JSON 1st:

    
is oracle database easy to learn
    
why oracle database is the best
    
oracle get database time
    
modern data platform oracle
    
oracle modern best practices