Skip to content

Mastering Oracle SQL Putting Oracle SQL to Work

Best in textbook rentals since 2012!

ISBN-10: 0596006322

ISBN-13: 9780596006327

Edition: 2nd 2004

Authors: Sanjay Mishra, Alan Beaulieu

List price: $49.99
Blue ribbon 30 day, 100% satisfaction guarantee!
what's this?
Rush Rewards U
Members Receive:
Carrot Coin icon
XP icon
You have reached 400 XP and carrot coins. That is the daily max!

The vast majority of Oracle SQL books discuss some syntax, provide the barest rudiments of using Oracle SQL, and perhaps include a few simple examples. It might be enough to pass a survey course, or give you some buzz words to drop in conversation with real Oracle DBAs. But if you use Oracle SQL on a regular basis, you want much more. You want to access the full power of SQL to write queries in an Oracle environment. You want a solid understanding of what's possible with Oracle SQL, creative techniques for writing effective and accurate queries, and the practical, hands-on information that leads to true mastery of the language. Simply put, you want useful, expert best practices that can be…    
Customers also bought

Book details

List price: $49.99
Edition: 2nd
Copyright year: 2004
Publisher: O'Reilly Media, Incorporated
Publication date: 7/13/2004
Binding: Paperback
Pages: 496
Size: 7.00" wide x 9.19" long x 1.10" tall
Weight: 1.738
Language: English

Sanjay Mishra has more than 12 years of experience working with Oracle systems. His key areas of interest include database architecture, database administration, performance management, scalability, software development and data modelling for mission-critical and decision support applications. He holds a Bachelor of Science degree in Electrical Engineering, and a Master of Engineering degree in Systems Science and Automation. He is the co-author of the books Oracle Parallel Processing and Oracle SQL Loader: The Definitive Guide (both published by O'Reilly Media, Inc.). Sanjay has published several technical papers in Oracle Magazine and SELECT Journal, and has presented many technical…    

Alan Beaulieu has been designing, building, and implementing custom database applications for over 13 years. He currently runs his own consulting company that specializes in designing Oracle databases and supporting services in the fields of Financial Services and Telecommunications. In building large databases for both OLTP and OLAP environments, Alan utilizes such Oracle features as Parallel Query, Partitioning, and Parallel Server. Alan has a Bachelor of Science degree in Operations Research from the Cornell University School of Engineering. He lives in Massachusetts with his wife and two daughters and can be reached at albeau_mosql@yahoo.com.

Preface
Introduction to SQL
What Is SQL?
A Brief History of SQL
A Simple Database
DML Statements
So Why Are There 17 More Chapters?
The Where Clause
Life Without Where
Where to the Rescue
Where Clause Evaluation
Conditions and Expressions
Where to Go from Here
Joins
What Is a Join Query?
Join Conditions
Types of Joins
Joins and Subqueries
DML Statements on a Join View
Group Operations
Aggregate Functions
The Group By Clause
The Having Clause
Nested Group Operations
Subqueries
What Is a Subquery?
Noncorrelated Subqueries
Correlated Subqueries
Inline Views
Subquery Case Study: The Top N Performers
Handling Temporal Data
Time Zones
Temporal Data Types in Oracle
Literals of Temporal Types
Getting Temporal Data In and Out of a Database
Date and Time Formats
Manipulating Temporal Data
Set Operations
Set Operators
Precedence of Set Operators
Comparing Two Tables
Using NULLs in Compound Queries
Rules and Restrictions on Set Operations
Hierarchical Queries
Representing Hierarchical Information
Simple Hierarchy Operations
Oracle SQL Extensions
Complex Hierarchy Operations
Restrictions on Hierarchical Queries
Enhancements in Oracle Database 10g
Decode and Case
Decode, Nullif, NVL, and NVL2
The Case for Case
Decode and Case Examples
Partitioning
Partitioning Concepts
Partitioning Tables
Partitioning Indexes
Partitioning Methods
Specifying Partitions
Partition Pruning
PL/SQL
What Is PL/SQL?
Procedures, Functions, and Packages
Calling Stored Functions from Queries
Restrictions on Calling PL/SQL from SQL
Stored Functions in DML Statements
The SQL Inside Your PL/SQL
Objects and Collections
Object Types
Collection Types
Collection Instantiation
Querying Collections
Collection Unnesting
Collection Functions
Comparing Collections
Manipulating Collections
Multilevel Collections
Advanced Group Operations
Multiple Summary Levels
Pushing the Grouping Envelope
The Grouping_ID and Group_ID Functions
Advanced Analytic SQL
Analytic SQL Overview
Ranking Functions
Windowing Functions
Reporting Functions
Summary
SQL Best Practices
Know When to Use Specific Constructs
Avoid Unnecessary Parsing
Consider Literal SQL for Decision-Support Systems
XML
What Is XML?
Storing XML Data
Generating XML Documents
Summary
Regular Expressions
Elementary Regular Expression Syntax
Advanced Function Options
Advanced Regular Expression Syntax
Model Queries
Basic Elements of a Model Query
Cell References
Rules
Iterative Models
Reference Models
Oracle's Old Join Syntax
Index