Items related to Modern Oracle Database Programming: Level Up Your Skill...

Modern Oracle Database Programming: Level Up Your Skill Set to Oracle's Latest and Most Powerful Features in SQL, PL/SQL, and JSON - Softcover

 
9781484291658: Modern Oracle Database Programming: Level Up Your Skill Set to Oracle's Latest and Most Powerful Features in SQL, PL/SQL, and JSON

Synopsis

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.

About the Author

​Alex Nuijten is an independent consultant specializing in Oracle database development with PL/SQL and Oracle Application Express (APEX). Besides his consultancy work, he conducts training classes in APEX, SQL, and PL/SQL. He is a speaker at numerous international conferences, such as ODTUG, Oracle Open World, HrOUG, UKOUG, IOUG, OUGF, BGOUG, NLOUG APEX World, OBUG, and many more. He has received several Best Speaker awards and writes at regular intervals about Oracle Application Express and Oracle database development on his blog "Notes on Oracle." He is co-author of Oracle APEX Best Practices and Real World SQL and PL/SQL. Because of his contributions to the Oracle community, Alex was awarded the Oracle ACE Director membership in August 2010.


Patrick Barel is a PL/SQL developer for Qualogy in The Netherlands. Besides working with SQL and PL/SQL Developer, he has written different plug-ins for PL/SQL. He publishes articles on his own blog and on the Qualogy blog. He is a speaker at international conferences, such as ODTUG, UKOUG, AUSOUG, NZOUG, IOUG, OUGN, NLOUG, DOUG, HrOUG, and many more. Patrick was awarded the Oracle ACE membership. In 2015, he received the Oracle Developer Choice Award in the PL/SQL Category. In 2019, he was promoted to Oracle ACE Director.

From the Back Cover

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



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

Buy Used

Condition: Good
The book is in good condition with...
View this item

FREE shipping within U.S.A.

Destination, rates & speeds

Other Popular Editions of the Same Title

9781484291672: Modern Oracle Database Programming: Level Up Your Skill Set to Oracle's Latest and Most Powerful Features in SQL, PL/SQL, and JSON

Featured Edition

ISBN 10:  1484291670 ISBN 13:  9781484291672
Publisher: Apress, 2023
Softcover

Search results for Modern Oracle Database Programming: Level Up Your Skill...

Seller Image

Nuijten, Alex; Barel, Patrick
Published by Apress, 2023
ISBN 10: 1484291654 ISBN 13: 9781484291658
Used Softcover

Seller: Bay State Book Company, North Smithfield, RI, U.S.A.

Seller rating 5 out of 5 stars 5-star rating, Learn more about seller ratings

Condition: good. The book is in good condition with all pages and cover intact, including the dust jacket if originally issued. The spine may show light wear. Pages may contain some notes or highlighting, and there might be a "From the library of" label. Boxed set packaging, shrink wrap, or included media like CDs may be missing. Seller Inventory # BSM.K5K7

Contact seller

Buy Used

US$ 26.05
Convert currency
Shipping: FREE
Within U.S.A.
Destination, rates & speeds

Quantity: 1 available

Add to basket

Seller Image

Nuijten, Alex; Barel, Patrick
Published by Apress, 2023
ISBN 10: 1484291654 ISBN 13: 9781484291658
New Softcover

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

Seller rating 5 out of 5 stars 5-star rating, Learn more about seller ratings

Condition: New. Seller Inventory # 45290740-n

Contact seller

Buy New

US$ 45.67
Convert currency
Shipping: US$ 2.64
Within U.S.A.
Destination, rates & speeds

Quantity: 1 available

Add to basket

Stock Image

Barel, Patrick, Nuijten, Alex
Published by 0, 2023
ISBN 10: 1484291654 ISBN 13: 9781484291658
New Softcover

Seller: Lakeside Books, Benton Harbor, MI, U.S.A.

Seller rating 5 out of 5 stars 5-star rating, Learn more about seller ratings

Condition: New. Brand New! Not Overstocks or Low Quality Book Club Editions! Direct From the Publisher! We're not a giant, faceless warehouse organization! We're a small town bookstore that loves books and loves it's customers! Buy from Lakeside Books! Seller Inventory # OTF-S-9781484291658

Contact seller

Buy New

US$ 44.33
Convert currency
Shipping: US$ 3.99
Within U.S.A.
Destination, rates & speeds

Quantity: Over 20 available

Add to basket

Seller Image

Nuijten, Alex
Published by Apress 2/18/2023, 2023
ISBN 10: 1484291654 ISBN 13: 9781484291658
New Paperback or Softback

Seller: BargainBookStores, Grand Rapids, MI, U.S.A.

Seller rating 5 out of 5 stars 5-star rating, Learn more about seller ratings

Paperback or Softback. Condition: New. Modern Oracle Database Programming: Level Up Your Skill Set to Oracle's Latest and Most Powerful Features in Sql, Pl/Sql, and Json 2.28. Book. Seller Inventory # BBS-9781484291658

Contact seller

Buy New

US$ 48.56
Convert currency
Shipping: FREE
Within U.S.A.
Destination, rates & speeds

Quantity: 5 available

Add to basket

Stock Image

Nuijten, Alex; Barel, Patrick
Published by Apress, 2023
ISBN 10: 1484291654 ISBN 13: 9781484291658
New Softcover

Seller: California Books, Miami, FL, U.S.A.

Seller rating 5 out of 5 stars 5-star rating, Learn more about seller ratings

Condition: New. Seller Inventory # I-9781484291658

Contact seller

Buy New

US$ 54.00
Convert currency
Shipping: FREE
Within U.S.A.
Destination, rates & speeds

Quantity: Over 20 available

Add to basket

Seller Image

Nuijten, Alex; Barel, Patrick
Published by Apress, 2023
ISBN 10: 1484291654 ISBN 13: 9781484291658
Used Softcover

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

Seller rating 5 out of 5 stars 5-star rating, Learn more about seller ratings

Condition: As New. Unread book in perfect condition. Seller Inventory # 45290740

Contact seller

Buy Used

US$ 51.53
Convert currency
Shipping: US$ 2.64
Within U.S.A.
Destination, rates & speeds

Quantity: 1 available

Add to basket

Seller Image

Nuijten, Alex; Barel, Patrick
Published by Apress, 2023
ISBN 10: 1484291654 ISBN 13: 9781484291658
Used Softcover

Seller: GreatBookPricesUK, Woodford Green, United Kingdom

Seller rating 5 out of 5 stars 5-star rating, Learn more about seller ratings

Condition: As New. Unread book in perfect condition. Seller Inventory # 45290740

Contact seller

Buy Used

US$ 63.13
Convert currency
Shipping: US$ 20.18
From United Kingdom to U.S.A.
Destination, rates & speeds

Quantity: Over 20 available

Add to basket

Seller Image

Nuijten, Alex; Barel, Patrick
Published by Apress, 2023
ISBN 10: 1484291654 ISBN 13: 9781484291658
New Softcover

Seller: GreatBookPricesUK, Woodford Green, United Kingdom

Seller rating 5 out of 5 stars 5-star rating, Learn more about seller ratings

Condition: New. Seller Inventory # 45290740-n

Contact seller

Buy New

US$ 63.36
Convert currency
Shipping: US$ 20.18
From United Kingdom to U.S.A.
Destination, rates & speeds

Quantity: Over 20 available

Add to basket

Stock Image

Nuijten, Alex; Barel, Patrick
Published by Apress, 2023
ISBN 10: 1484291654 ISBN 13: 9781484291658
New Softcover

Seller: Ria Christie Collections, Uxbridge, United Kingdom

Seller rating 5 out of 5 stars 5-star rating, Learn more about seller ratings

Condition: New. In. Seller Inventory # ria9781484291658_new

Contact seller

Buy New

US$ 68.61
Convert currency
Shipping: US$ 16.11
From United Kingdom to U.S.A.
Destination, rates & speeds

Quantity: Over 20 available

Add to basket

Stock Image

Alex Nuijten
Published by APress, 2023
ISBN 10: 1484291654 ISBN 13: 9781484291658
New Paperback / softback
Print on Demand

Seller: THE SAINT BOOKSTORE, Southport, United Kingdom

Seller rating 5 out of 5 stars 5-star rating, Learn more about seller ratings

Paperback / softback. Condition: New. This item is printed on demand. New copy - Usually dispatched within 5-9 working days 209. Seller Inventory # C9781484291658

Contact seller

Buy New

US$ 76.67
Convert currency
Shipping: US$ 11.89
From United Kingdom to U.S.A.
Destination, rates & speeds

Quantity: Over 20 available

Add to basket

There are 8 more copies of this book

View all search results for this book