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

by Heli Helskyaho, Arup Nanda, Alex Nuijten, Brendan Tierney, Martin Widlake

Overview

Publisher's Note: Products purchased from Third Party sellers are not guaranteed by the publisher for quality, authenticity, or access to any online entitlements included with the product.

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 www.MHProfessional.com.

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

Product Details

ISBN-13:	9781259640971
Publisher:	McGraw Hill LLC
Publication date:	08/22/2016
Pages:	736
Product dimensions:	7.30(w) x 9.10(h) x 1.50(d)

About the Author

Heli Helskyaho has a master’s degree in computer science from Helsinki University and specializes in databases. Heli is also an Oracle ACE director and has been a frequent speaker at many conferences. She has worked in IT since 1990 and with Oracle products since 1993. She has been in several positions, but each role has always included database design. Heli has been an Oracle Designer user since 1996 and a Oracle SQL Developer Data Modeler user since 2010. Heli is an active member in Oracle user groups community, including Oracle User Group Finland as well as EMEA Oracle user groups community (EOUC) where she has served as their spokesperson/ambassador since 2007. Heli is also the CEO for Miracle Finland Oy. Heli believes that creating good database design and documentation reduces performance problems and makes solving them easier. You can follow her on Twitter @helifromfinland or read her blog on helifromfinland.wordpress.com.

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

Martin Widlake is an independent Oracle consultant, specialising in database performance, PL/SQL development and VLDBs. He has been working with Oracle technologies for over two decades and shares his experience & knowledge when presenting at conferences and user groups several times a year, both across the UK and internationally. Martin is an Oracle ACE and also a proud member of the Oak Table Network.

Brendan Tierney, Oracle ACE Director, is an independent consultant and lectures on Data Mining and Advanced Databases in the Dublin Institute of Technology in Ireland. He is an Oracle ACE Director and has extensive experience working in the areas of Data Mining, Data Warehousing, Data Architecture and Database Design. Brendan has worked on projects in Ireland, UK, Belgium and USA and has been working with the Oracle database and tools since 1992. Brendan is the editor of the UKOUG Oracle Scene magazine and deputy chair of the OUG Ireland BI SIG. Brendan is a regular speaker at conferences across Europe and the USA, including Oracle Open World. In addition to his presentations Brendan has written technical articles for OTN, Oracle Scene, IOUG SELECT Journal and ODTUG Technical Journal. He is author of the Oracle Press book titled, Predictive Analytics using Oracle Data Miner.

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)