Modern Oracle Database Programming: Level Up Your Skill Set to Oracle's Latest a

Description: Modern Oracle Database Programming by Alex Nuijten, Patrick Barel Estimated delivery 3-12 business days Format Paperback Condition Brand New Description Intermediate user level Publisher Description 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. Youll discover built-in functionality that can save you massive amounts of time that otherwise would be spent reinventing the wheel. Youll 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. Youll 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. Youll 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 youll be improving your skillsand wondering why you ever worked so hard to solve problems that Oracle Database already solves for you.What You Will LearnWrite more powerful code by incorporating underused features in SQL and PL/SQLOptimize your integration between SQL and PL/SQL for best performanceTake advantage of enhanced set operators, lateral joins, row-based pattern matching, and other advanced features in SQLMake your code easier to understand through your use of newer PL/SQL features, such as qualified expressions and iterator enhancementsIntegrate with web services and external data sources directly from the databaseCreate and parse JSON documents for easy data exchange and flexible schema designWho This Book Is ForAny 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 dont want to write their own solutions only to find out later that theyve wasted their time by building something that Oracle Database provides out of the box Author Biography 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. Details ISBN 1484291654 ISBN-13 9781484291658 Title Modern Oracle Database Programming Author Alex Nuijten, Patrick Barel Format Paperback Year 2023 Pages 576 Edition 1st Publisher APress GE_Item_ID:140659060; About Us Grand Eagle Retail is the ideal place for all your shopping needs! With fast shipping, low prices, friendly service and over 1,000,000 in stock items - you're bound to find what you want, at a price you'll love! Shipping & Delivery Times Shipping is FREE to any address in USA. Please view eBay estimated delivery times at the top of the listing. Deliveries are made by either USPS or Courier. We are unable to deliver faster than stated. International deliveries will take 1-6 weeks. NOTE: We are unable to offer combined shipping for multiple items purchased. This is because our items are shipped from different locations. Returns If you wish to return an item, please consult our Returns Policy as below: Please contact Customer Services and request "Return Authorisation" before you send your item back to us. Unauthorised returns will not be accepted. Returns must be postmarked within 4 business days of authorisation and must be in resellable condition. Returns are shipped at the customer's risk. We cannot take responsibility for items which are lost or damaged in transit. For purchases where a shipping charge was paid, there will be no refund of the original shipping charge. Additional Questions If you have any questions please feel free to Contact Us. Categories Baby Books Electronics Fashion Games Health & Beauty Home, Garden & Pets Movies Music Sports & Outdoors Toys

Price: 54.58 USD

Location: Fairfield, Ohio

End Time: 2024-10-25T03:09:08.000Z

Shipping Cost: 0 USD

Product Images

Item Specifics

Restocking Fee: No

Return shipping will be paid by: Buyer

All returns accepted: Returns Accepted

Item must be returned within: 30 Days

Refund will be given as: Money Back

ISBN-13: 9781484291658

Book Title: Modern Oracle Database Programming

Number of Pages: Xxviii, 576 Pages

Publication Name: Modern Oracle Database Programming : Level up Your Skill Set to Oracle's Latest and Most Powerful Features in PL/SQL, APEX, and JSON

Language: English

Publisher: Apress L. P.

Subject: General, Online Services, Databases / General

Publication Year: 2023

Item Weight: 40 Oz

Type: Textbook

Author: Alex Nuijten, Patrick Barel

Subject Area: Mathematics, Computers

Item Length: 10 in

Item Width: 7 in

Format: Trade Paperback