Pro Oracle SQL development : best practices for writing advanced queries / Jon Heller.
Heller, Jon, author.
2023
QA76.9.D3 H45 2023
Available Online

Linked e-resources

Linked Resource
Online Access
Concurrent users
Unlimited
Authorized users
Authorized users
Document Delivery Supplied
Can lend chapters, not whole ebooks

Details

Title
Pro Oracle SQL development : best practices for writing advanced queries / Jon Heller.
Author
Heller, Jon, author.
Edition
Second edition.
ISBN
9781484288672 electronic book
148428867X electronic book
9781484288665
1484288661
DOI
https://doi.org/10.1007/978-1-4842-8867-2
Published
[Berkeley, CA] : Apress L. P., [2023]
Language
English
Description
1 online resource (632 pages)
Item Number
10.1007/978-1-4842-8867-2 doi
Call Number
QA76.9.D3 H45 2023
Dewey Decimal Classification
005.75/65
Summary
Write SQL statements that are more powerful, simpler, and faster using the advanced features of Oracle SQL. This updated second edition includes the newest advanced features: improved data structures (such as more JSON support and more table options), improved automated processes (such as automatic indexing), and improved SQL language extensions (such as polymorphic table functions, SQL macros, and the multilingual engine). Pro Oracle SQL Development is for anyone who already knows Oracle SQL and is ready to take their skills to the next level. This book provides a clearer way of thinking about SQL by building sets, and it provides practical advice for using complex features while avoiding anti-patterns that lead to poor performance and wrong results. Relevant theories, real-world best practices, and style guidelines help you get the most out of Oracle SQL. Many developers, testers, analysts, and administrators use Oracle databases frequently, but their queries are limited because they do not take advantage of Oracle's advanced features. This book inspires you to achieve more with your Oracle SQL statements by creating your own style for writing simple, yet powerful, SQL. It teaches you how to think about and solve performance problems in Oracle SQL, and it covers enough advanced topics to put you on the path to becoming an Oracle expert. What You'll Learn Solve challenging problems with declarative SQL instead of procedural languages Write SQL statements that are large and powerful, but also elegant and fast Create development environments that are simple, scalable, and conducive to learning Visualize and understand SQL more intuitively Apply advanced syntax, objects, and architecture Avoid SQL anti-patterns that accumulate technical debt Tune SQL statements with multiple strategies that can significantly improve performance Who This Book Is For Developers, testers, analysts, and administrators who want to harness the full power of Oracle SQL to solve their problems as simply and as quickly as possible; traditional database professionals looking for new ways of thinking about the language they have used for so long; and modern full stack developers who need an explanation of how a database can be much more than simply a place to store data.
Note
Learn an IDE
Access Note
Access limited to authorized users.
Source of Description
Description based on online resource; title from digital title page (viewed on January 17, 2023).
Available in Other Form
Pro Oracle SQL Development
Linked Resources
Online Access
Record Appears in
Online Resources > Ebooks
All Resources
Intro
Table of Contents
About the Author
About the Technical Reviewer
Acknowledgments
Introduction
Part I: Learn How to Learn
Chapter 1: Understand Relational Databases
History of Relational Databases
Relational Model and Why It Matters
History
Terminology
Simplicity
Sets and Tables
Problems Implementing a Relational Model
Relational Model and Why It Doesn't Matter
The NULL Problem Isn't a Problem
Column Order Is Important
Denormalization
All Rows Are Distinct
SQL Programming Language
History and Terminology
SQL Alternatives

Is SQL a Programming Language?
Different Database Types
Alternative Database Models
Different Oracle Databases (OLTP vs. DW)
Key Concepts
NULL
JOIN
Join Visualizations
Inner Join
Left and Right Outer Joins
Full Outer Join
Cross Join
Summary
Chapter 2: Create an Efficient Database Development Process
Shared Database vs. Private Database
Create an Infinite Number of Databases
Advantages of Private Databases
Create Private Databases: Local Installation
Create Private Databases: Other Options
Rapidly Drop and Recreate Schemas

Why Deploy Often?
How to Deploy Often?
SQL*Plus Installation Scripts
Comments
SQL*Plus Settings and Messages
Check Prerequisites
Drop Old Schemas
Scripts for Object Types
Grant to Roles
Validate the Schemas
SQL*Plus Patch Scripts
Control Schemas with Version-Controlled Text Files
Single Source of Truth
Load Objects from the Repository and File System
Create and Save Changes Manually
Empower Everyone
Power Imbalance
Transparency
Lower Barriers to Entry
Summary
Chapter 3: Increase Confidence and Knowledge with Testing

Build Confidence with Automated Tests
Fix Bugs Faster
Gain Confidence and Avoid Biases
Test-Driven Development
Create Useful Test Data
Create Large Test Data
Remove Test Data
How to Build Automated Tests
Build Knowledge with Minimal, Complete, and Verifiable Examples
Why Spend So Much Time Building Reproducible Test Cases?
Minimal
Complete
Verifiable
Sharing Tests
Avoiding the XY Problem
Oracle Performance Testing
Oracle Detective Kit
Data Dictionary Views
Dynamic Performance Views
Relational Tools for Inspecting Databases

Non-relational Tools for Inspecting Databases
Summary
Chapter 4: Find Reliable Sources
Places to Go
The Problems with Forums
The Problems with Static Websites
Read the Manual
The Manual Is Not Perfect
My Oracle Support
People to See
Summary
Chapter 5: Master the Entire Stack
Not Just Faster
Typing
Operating Systems and Supporting Programs
Operating Systems
Text Editors
Comparison Tools
Reporting Tools and Excel
SQL and PL/SQL
SQL*Plus
When We Should Use SQL*Plus
When We Should Not Use SQL*Plus
Integrated Development Environment

Browse Subjects

Show more subjects...

Statistics

from
to
Export