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 applications—and how to effectively use both the languages together. Readers will learn to compare and contrast the standards and determine which—or a blend of the two—is 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