Real-world SQL and PL/SQL

Real-world SQL and PL/SQL

Advice From the Experts

Book - 2017
Rate this:

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

TAG: For a complete list of Oracle Press titles, visit

Publisher: New York : McGraw-Hill Education, [2017]
Copyright Date: ©2017
ISBN: 9781259640971
Branch Call Number: 005.7565 Nan
Characteristics: xxv, 700 pages : illustrations ; 23 cm


From the critics

Community Activity


Add a Comment

There are no comments for this title yet.

Age Suitability

Add Age Suitability

There are no age suitabilities for this title yet.


Add a Summary

There are no summaries for this title yet.


Add Notices

There are no notices for this title yet.


Add a Quote

There are no quotes for this title yet.

Explore Further

Browse by Call Number


Subject Headings


Find it at VPL

To Top