The Library of Congress > Linked Data Service > BIBFRAME Works

Bibframe Work

Title
Real-world SQL and PL/SQL
Type
Text
Monograph
Multimedia
Contribution
Nanda, Arup (Author)
Subject
Oracle (Computer file)
PL/SQL (Computer program language) (LCSH)
Relational databases (LCSH)
COMPUTERS / Database Management / General (BISACSH)
Language
English
Classification
LCC: QA76.73.S67
DDC: 005.75/65 full
COM021000
Could not render: bf:status
Content
text
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.
Table Of 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).
Authorized Access Point
Nanda, Arup Real-world SQL and PL/SQL
Admin Metadata
Generation Process: DLC marc2bibframe2 v2.5.0
Status: changed
Encoding Level: full
Identified By: bf:Local, 19240975
Change Date: 2021-10-06T18:34:52
Creation Date: 2016-08-23
Description Language: English
Description Modifier: United States, Library of Congress
Description Authentication:
Non-rendered Predicates: bf:assigner