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
