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

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

Paperback

$54.00 $60.00 Save 10% Current price is $54, Original price is $60. You Save 10%.
View All Available Formats & Editions
Choose Expedited Shipping at checkout for guaranteed delivery by Wednesday, March 27

Product Details

ISBN-13: 9781259640971
Publisher: McGraw-Hill Professional Publishing
Publication date: 08/22/2016
Pages: 736
Sales rank: 1,284,750
Product dimensions: 7.30(w) x 9.10(h) x 1.50(d)

About the Author

Arup Nanda, Oracle ACE Director (New York, United States), has been working with Oracle database and PL/SQL for 20 years and counting. He has written 6 books, published 500+ articles, presented 300+ sessions, and delivered training seminars in 22 countries.

Brendan Tierney, Oracle ACE Director (Dublin, Ireland), has been working with the Oracle Database and development tools since 1992. He is principal consultant with Oralytics. He is the author of 2 books by Oracle Press, Predictive Analytics using Oracle Data Miner and Oracle R Enterprise: Harnessing the Power of R in the Oracle Database.

Heli Helskyaho, Oracle ACE Director (Helsinki, Finland), has been working in IT since 1990 and Oracle products since 1993. She is the spokesperson/ambassador of the EMEA Oracle User Group and a frequent speaker in many conferences. She is the author of Oracle SQL Developer Data Modeler for Database Design Mastery (Oracle Press 2015) and one of the first winners of Oracle Database Developer Choice Award in Database Design category in 2015.

Alex Nuijten, Oracle ACE Director (Oosterhout, Netherlands), is a consultant at Ordina Oracle Solutions. He is a frequent contributor to Oracle-related publications and is co-author of Oracle APEX Best Practices.

Martin Widlake, Oracle ACE Director (London, United Kingdom), is an independent Oracle consultant who specializes in database performance, PL/SQL development, and VLDBs. He has been working with Oracle technologies for 23 years and counting

Table of Contents

Part 1: The Importance of SQL, PL/SQL and a Good Data Model
Chapter 1: SQL, PL/SQL and When to Use Which
Chapter 2: Expert Data Modeling and Implementing Business Logic

Part 2: Underutilized Advanced SQL Functionality
Chapter 3: Handling Advanced and Complex Datasets
Chapter 4: Regular Expressions
Chapter 5: Edition Based Redefinition

Part 3: Essential Everyday Advanced PL/SQL
Chapter 6: Running PL/SQL in SQL
Chapter 7: Instrumenting, Profiling and Debugging PL/SQL
Chapter 8: Dynamic SQL
Chapter 9: PL/SQL for Database Management

Part 4: Advanced Analytics
Chapter 10: In-Database Data Mining Using Oracle Data Mining
Chapter 11: Oracle R Enterprise
Chapter 12: Predictive Queries

Part 5: Database Security
Chapter 13: Redaction and masking
Chapter 14: Encryption and hashing
Chapter 15: SQL Injection & Code Security
Chapter 16: Virtual Private Databases (VPD)

Customer Reviews

Most Helpful Customer Reviews

See All Customer Reviews