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

by Arup Nanda, Brendan Tierney, Heli Helskyaho

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 features―and how to effectively use both languages together. Written by a team of Oracle ACE Directors, Real-World SQL and PL/ 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

- 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.

For a complete list of Oracle Press titles, visit www.OraclePressBooks.com

1040 pages, Kindle Edition

Published August 22, 2016

Reviews

[Mike · Rating 4 out of 5]

Some of the early advice is not particularly real-world, and even dangerous to apply in the real world, with toy examples that don't resemble reality at all closely. The section on cursors, in particular, is focused on outlining the functionality rather than talking about when you would actually use them - which, from what I've read elsewhere, is in a limited set of circumstances, since there are usually better alternatives that are not discussed here.

I did get some value out of the chapters towards the middle. Most of the end part is more related to database admin than development, so it wasn't that relevant to me.

However, the book was worth it just for the chapter on PLSQL logging and instrumentation. I've implemented a version of its recommendations at work, and it's proving to be very useful. So that wins it four stars.