Modern Oracle Database Programming : Level Up Your Skill Set to Oracle's Latest and Most Powerful Features in SQL, Pl/sql, and Json

Name: Modern Oracle Database Programming : Level Up Your Skill Set to Oracle's Latest and Most Powerful Features in SQL, Pl/sql, and Json
Author: Nuijten, Alex; Barel, Patrick
ISBN: 9781484291658

Nuijten, Alex; Barel, Patrick

Language: English

Published by Apress, 2023

1484291654 / 9781484291658

Softcover
New

See all details

Seller: GreatBookPrices, Columbia, MD, U.S.A.GreatBookPrices

5-star seller

AbeBooks seller since April 6, 2009

View this seller's items

Softcover

Condition: New

US$ 45.79

US$ 2.64 shipping

Ships within U.S.A.

Quantity: 1 available

Add to basket

Free 30-day returns

Save for laterCreate a Want for similar items

Seller Inventory # 45290740-n

Contact seller about this item

Report this item

Title: Modern Oracle Database Programming : Level Up Your Skill Set to Oracle's Latest and Most Powerful Features in SQL, Pl/sql, and Json
Author: Nuijten, Alex; Barel, Patrick
Publisher: Apress
Publication year: 2023
Condition: New
Binding: Soft cover
Language: English
ISBN 10: 1484291654
ISBN 13: 9781484291658

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. These features are just a taste of what the book provides. Soon you’ll be improving your skillsand wondering why you ever worked so hard to solve problems that Oracle Database already solves for you.

What You Will Learn

Write more powerful code by incorporating underused features in SQL and PL/SQL
Optimize your integration between SQL and PL/SQL for best performance
Take advantage of enhanced set operators, lateral joins, row-based pattern matching, and other advanced features in SQL
Make your code easier to understand through your use of newer PL/SQL features, such as qualified expressions and iterator enhancements
Integrate with web services and external data sources directly from the database
Create and parse JSON documents for easy data exchange and flexible schema design

Who This Book Is For

Any developer who is writing SQL or PL/SQL, PL/SQL experts who want to level up their knowledgeand skills to the latest features that Oracle Database provides, and developers who don’t want to write their own solutions only to find out later that they’ve wasted their time by building something that Oracle Database provides out of the box

"Synopsis" may belong to another edition of this title.

GreatBookPrices

Columbia, MD, U.S.A.

5-star seller

AbeBooks seller since April 6, 2009

Shipping rates within U.S.A.

Item	5 to 14 business days	8 to 14 business days
First item	US$ 2.64	US$ 2.64

Delivery times are set by sellers and vary by carrier and location. Orders passing through Customs may face delays and buyers are responsible for any associated duties or fees. Sellers may contact you regarding additional charges to cover any increased costs to ship your items.

Payment methods

Store description

SuperBookDeals.com is your top source for finding new books at the absolute lowest prices, guaranteed ! We offer big discounts - everyday - on millions of titles in virtually any category, from Architecture to Zoology -- and everything in between. Discover great deals and super-savings, on professional books, text book titles, the newest computer guides, or your favorite fiction authors. You'll find it all - at HUGE SAVINGS - at SuperBookDeals. Browse through our complete online product catalog today. Serving customers around the world for years, we help thousands find just the books they're looking for -- at incredibly low, bargain prices.…

Seller's business information

Expert Trading Limited

9220 Rumsey Road, Suite 101
Columbia, MD U.S.A. 21045

Contact sellerView this seller's itemsView seller's storefront

Modern Oracle Database Programming : Level Up Your Skill Set to Oracle's Latest and Most Powerful Features in SQL, Pl/sql, and Json

Bibliographic details

Synopsis

About the title

About the Author

GreatBookPrices

Shipping rates within U.S.A.

Payment methods

Store description

Seller's business information

Terms of sale

Shipping terms