Return to home page
Searching: Otterbein library catalog
  Previous Record Previous Item Next Item Next Record
  Reviews, Summaries, etc...
BOOK
Author Nanda, Arup, author.
Title Real-world SQL and PL/SQL : advice from the experts / Arup Nanda, Brendan Tierney, Heli Helskyaho, Martin Widlake, Alex Nuijten.
Imprint New York : McGraw-Hill Education, [2017]
©2017.

LOCATION CALL # STATUS MESSAGE
 OTTERBEIN MAIN COLLECTION  QA76.73.S67 N36 2017    AVAILABLE  
LOCATION CALL # STATUS MESSAGE
 OTTERBEIN MAIN COLLECTION  QA76.73.S67 N36 2017    AVAILABLE  
Author Nanda, Arup, author.
Subject Oracle (Computer file)
PL/SQL (Computer program language)
Relational databases.
Alt Name Tierney, Brendan, 1970- author.
Helskyaho, Heli, author.
Description xxvii, 700 pages ; 24 cm
Note Includes index.
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.
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.
ISBN 9781259640971 (paperback)
1259640973 (paperback)
OCLC # 957223335
Additional Format Online version: Nanda, Arup. Real-world SQL and PLSQL. 1. New York : McGraw-Hill Education, [2017] 9781259640988 (DLC) 2016038939.