| Contents |
Part I. The Importance of SQL, PL/SQL and a Good Data Model: 1. SQL, PL/SQL; 2. Expert Data Modeling and Implementing Business Logic -- Part II Underutilized Advanced SQL Functionality: 30 Handling Advanced and Complex Data Sets; 4. Regular Expressions; 5. Edition Based Redefinition -- Part III. Essential Everyday Advanced PL/SQL: 6. Running PL/SQL from SQL; 7. Instrumenting, Profiling and Debugging PL/SQL; 8. Dynamic SQL; 9. PL/SQL for Automation and Administration -- Part IV. Advanced Analytics: 10. In-Database Data Mining Using Oracle Data Mining; 11. Oracle R Enterprise; 12. Predictive Queries in Oracle 12c -- Part V. Database Security: 13. Redaction and Masking; 14. Encryption and Hashing; 15. SQL Injection and Code Security; 16. Fine Grained Control and Application Contexts. |
| Abstract |
"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, 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"-- Provided by publisher. |
| General note | Includes index. |
| Issued in other form | Online version: Nanda, Arup, author. Real-world SQL and PLSQL 1 New York : McGraw-Hill Education, [2017] 9781259640988 |
| LCCN | 2016027910 |
| ISBN | 9781259640971 (paperback) |
| ISBN | 1259640973 (paperback) |
