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

Contributor(s):

Material type: Text

TextPublisher: New York : McGraw-Hill Education, [2017]Description: xxvii, 700 pages ; 24 cmContent type:

text

Media type:

unmediated

Carrier type:

volume

ISBN:

9781259640971 (paperback)

Subject(s):

LOC classification:

GS QA 76.73 S67 R43 2017

Contents:

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

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

Tags from this library: No tags from this library for this title. Log in to add tags.

Average rating: 0.0 (0 votes)

Holdings
Item type	Current library	Shelving location	Call number	Copy number	Status	Date due	Barcode
Book	TUP Manila Library	Graduate Program Section-2F	GS QA 76.73 S67 R43 2017 (Browse shelf(Opens below))	c.1	Available		P00032022

Includes index.

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

There are no comments on this title.

to post a comment.