Real World SQL and PL/SQL

<p><b>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.</b></p><p><strong>Master the Underutilized Advanced Features of SQL and PL/SQL</strong></p><p>This hands-on guide from Oracle Press shows how to fully exploit lesser known but extremely useful SQL and PL/SQL features―and how to effectively use both languages together. Written by a team of Oracle ACE Directors <em>Real-World SQL and PL/SQL: Advice from the Experts</em> 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.</p><p>Learn how to:</p><p>• Apply advanced SQL and PL/SQL tools and techniques<br/>• Understand SQL and PL/SQL functionality and determine when to use which language<br/>• Develop accurate data models and implement business logic<br/>• Run PL/SQL in SQL and integrate complex datasets<br/>• Handle PL/SQL instrumenting and profiling<br/>• Use Oracle Advanced Analytics and Oracle R Enterprise<br/>• Build and execute predictive queries<br/>• Secure your data using encryption hashing redaction and masking<br/>• Defend against SQL injection and other code-based attacks<br/>• Work with Oracle Virtual Private Database</p><p>Code examples in the book are available for download at www.MHProfessional.com.</p><p>TAG: For a complete list of Oracle Press titles visit www.OraclePressBooks.com</p>