Real-world SQL and PL/SQL : advice from the experts Cover Image

E-book

Real-world SQL and PL/SQL : advice from the experts / Arup Nanda, Brendan Tierney, Heli Helskyaho, Martin Widlake, Alex Nuijten.

Summary:

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

Record details

ISBN: 9781259640988
ISBN: 1259640981
ISBN: 1259640973
ISBN: 9781259640971
Physical Description: 1 online resource
Edition: 1.
Publisher: New York : McGraw-Hill Education, [2017]

Content descriptions

Formatted Contents Note:

Machine generated contents note: 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).

Source of Description Note:

Description based on print version record and CIP data provided by publisher; resource not viewed.