Home Page Icon
Home Page
Table of Contents for
cover
Close
cover
by Jared Still, Riyaj Shamsudeen, Ron Sands, Kerry Osborne, Karen Morton
Pro Oracle SQL, Second Edition
Title Page
Contents at a Glance
Contents
About the Authors
About the Technical Reviewer
Acknowledgments
CHAPTER 1: Core SQL
The SQL Language
Interfacing to the Database
Review of SQL*Plus
The Five Core SQL Statements
The SELECT Statement
The INSERT Statement
The UPDATE Statement
The DELETE Statement
The MERGE Statement
Summary
CHAPTER 2: SQL Execution
Oracle Architecture Basics
SGA: The Shared Pool
The Library Cache
Identical Statements
SGA: The Buffer Cache
Query Transformation
Determining the Execution Plan
Executing the Plan and Fetching Rows
SQL Execution: Putting It All Together
Summary
CHAPTER 3: Access and Join Methods
Full Scan Access Methods
Index Scan Access Methods
Join Methods
Summary
CHAPTER 4: SQL Is about Sets
Thinking in Sets
Set Operations
Sets and Nulls
Summary
CHAPTER 5: It’s about the Question
Asking Good Questions
The Purpose of Questions
Categories of Questions
Questions about the Question
Questions about Data
Building Logical Expressions
Summary
CHAPTER 6: SQL Execution Plans
Explain Plan
Execution Plans
Summary
CHAPTER 7: Advanced Grouping
Basic GROUP BY Usage
HAVING Clause
“New” GROUP BY Functionality
CUBE Extension to GROUP BY
Putting CUBE to Work
Eliminate NULLs with the GROUPING( ) Function
Extending Reports with GROUPING( )
Extending Reports with GROUPING_ID( )
GROUPING SETS ( ) and ROLLUP( )
GROUP BY Restrictions
Summary
CHAPTER 8: Analytic Functions
Overview
Example Data
Anatomy of Analytic Functions
List of Functions
Aggregation Functions
lead and lag
first_value and last_value
Other Analytic Functions
Performance Tuning
Advanced Topics
Organizational Behavior
Summary
CHAPTER 9: The MODEL Clause
Spreadsheets
Interrow Referencing Via the MODEL Clause
Positional and Symbolic References
Returning Updated Rows
Evaluation Order
Aggregation
Iteration
Lookup Tables
NULLs
Performance Tuning with the MODEL Clause
Subquery Factoring
Summary
CHAPTER 10: Subquery Factoring
Standard Usage
WITH Using a PL/SQL Function
Optimizing SQL
Recursive Subqueries
Duplicating CONNECT BY Functionality
Summary
CHAPTER 11: Semijoins and Antijoins
Semijoins
Semijoin Plans
Controlling Semijoin Plans
Semijoin Restrictions
Semijoin Requirements
Antijoins
Antijoin Plans
Controlling Antijoin Plans
Antijoin Restrictions
Antijoin Requirements
Summary
CHAPTER 12: Indexes
Understanding Indexes
Index Structural Types
Partitioned Indexes
Solutions to Match Application Characteristics
Solutions to Management Problems
Summary
CHAPTER 13: Beyond the SELECT
INSERT
UPDATE
DELETE
MERGE
Summary
CHAPTER 14: Transaction Processing
What Is a Transaction?
ACID Properties of a Transaction
Transaction Isolation Levels
Multiversion Read Consistency
Transaction Control Statements
Grouping Operations into Transactions
The Order Entry Schema
The Active Transaction
Using Savepoints
Serializing Transactions
Isolating Transactions
Autonomous Transactions
Summary
CHAPTER 15: Testing and Quality Assurance
Test Cases
Testing Methods
Execution Plan Comparison
Instrumentation
Testing to Destruction
Troubleshooting through Instrumentation
Summary
CHAPTER 16: Plan Stability
Plan Instability: Understanding the Problem
Statistics Feedback
Identifying Plan Instability
Summary
CHAPTER 17: Plan Control
Plan Control: Solving the Problem
Plan Control: Without Access to the Code
Summary
CHAPTER 18: Miscellaneous SQL Constructs
Conditional Logic Constructs
PIVOT/UNPIVOT Queries
SQL to Generate Test Data
Summary
Index
Search in book...
Toggle Font Controls
Playlists
Add To
Create new playlist
Name your new playlist
Playlist description (optional)
Cancel
Create playlist
Sign In
Email address
Password
Forgot Password?
Create account
Login
or
Continue with Facebook
Continue with Google
Sign Up
Full Name
Email address
Confirm Email Address
Password
Login
Create account
or
Continue with Facebook
Continue with Google
Next
Next Chapter
Title Page
Add Highlight
No Comment
..................Content has been hidden....................
You can't read the all page of ebook, please click
here
login for view all page.
Day Mode
Cloud Mode
Night Mode
Reset