Real World SQL and PL/SQL: Advice from the Experts

Develop, debug, and deploy secure data-centric programs using SQL and PL/SQL

this comprehensive oracle press guide shows how to exploit the little known but extremely useful sql and pl/sql features to develop powerful applicationsand how to effectively use both the languages together. readers will learn to compare and contrast the standards and determine whichor a blend of the twois optimal under any set of circumstances.

real world sql and pl/sql: advice from the experts focuses on practical, day-to-day operations and tasks taken up in complex projects. the authors provide best practices, real-world examples, and insider tips that clearly demonstrate, step-by-step, how to best implement code for a wide variety of applications that need to be both performant and secure. the book fully explains advanced sql techniques, essential advanced pl/sql development and tools, data modeling, advanced analytics using both oracle-supplied tools and embedded r, and secure coding.

• Offers unique, highly-integrated coverage of both SQL and PL/SQL
• All code in the book is available for download and ready to implement
• Written by a team of Oracle ACE Directors some of whom are members of the Oak Table Network