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

publisher's note: products purchased from third party sellers are not guaranteed by the publisher for quality, authenticity, or access to any online entitlements included with the product.

Master the Underutilized Advanced Features of SQL and PL/SQL

this hands-on guide from oracle press shows how to fully exploit lesser known but extremely useful sql and pl/sql featuresand how to effectively use both languages together. written by a team of oracle ace directors, Real-World SQL and PL/SQL: Advice from the Experts features best practices, detailed examples, and insider tips that clearly demonstrate how to write, troubleshoot, and implement code for a wide variety of practical applications. The book thoroughly explains underutilized SQL and PL/SQL functions and lays out essential development strategies. Data modeling, advanced analytics, database security, secure coding, and administration are covered in complete detail.

learn how to:

 apply advanced sql and pl/sql tools and techniques
 Understand SQL and PL/SQL functionality and determine when to use which language
 Develop accurate data models and implement business logic
 Run PL/SQL in SQL and integrate complex datasets
 Handle PL/SQL instrumenting and profiling
 Use Oracle Advanced Analytics and Oracle R Enterprise
 Build and execute predictive queries
 Secure your data using encryption, hashing, redaction, and masking
 Defend against SQL injection and other code-based attacks
 Work with Oracle Virtual Private Database

code examples in the book are available for download at www.MHProfessional.com.

tag: for a complete list of oracle press titles, visit www.OraclePressBooks.com