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

Develop, debug, and deploy secure data-centric programs using SQL and PL/SQLThis 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/SQLAll code in the book is available for download and ready to implementWritten by a team of Oracle ACE Directors some of whom are members of the Oak Table Network