$16.95 / £11.95
Written by a graduate of West
Point, John Garmany leverages his 20+ years of experience into an
indispensable guide for any Oracle professional who must quickly
implement Oracle reporting. A noted instructor, author and lecturer,
John Garmany leverages his ability to explain complex issues in Plain
English into a one-of-a-kind book. John Garmany targets his decades of
SQL*Plus experience into this must-have book. Intended for anyone who
needs to extract Oracle data and format reports, John reveals the
secrets of quickly and easily producing stunning reports from Oracle.
Unknown to most Oracle professionals, special SQL extraction techniques
and SQL*Plus commands can be used to quickly create complex reports,
without buying expensive third-party reporting tools. Best of all, John
Garmany shares dozens of working samples in his online code depot. Your
time savings from a single script is worth the price of this great book.
Easy Oracle SQL is your introduction to using SQL and SQL*Plus with an
Oracle database. Whether you are just learning SQL or just need a handy
reference, this book will provide you with proven methods to building
queries and reports using SQL.
Each concept is explained in
detail with multiple examples and exercises at the end of each section.
Also included is a section detailing how to effectively use SQL*Plus to
not only create and run queries but also to create quality reports and
scripts. This book will have you up and using SQL quickly and
* Get detailed explanations of
using Oracles SQL*Plus and SQL Worksheet.
* Comes with an online code depot with working examples of Oracle
* Understand the Oracle database including tables, rows and columns.
* Learn all basic SQL Clauses, SELECTs, JOINs, WHEREs, and Grouping.
* Learn to modify data using INSERTs, UPDATEs and DELETEs.
* Create and manage Tables, Views and Materialized Views.
* Use Oracles Data Dictionary to find information.
* Learn to increase SQL performance using Indexes.
* Use SQL*Plus to create detailed reports.
* Learn by example as each section contains exercises to test your
* Shows how to incorporate Oracle8i analytic functions in Oracle
* Contains working SQL*Plus scripts to get you started fast.
* Presents tricks for writing complex SQL in incremental stages.
About the Author:
Table of Contents:
1 Introduction and
overview of Oracle
This is an introduction to Oracle relational database and the Oracle
architecture. We discuss Oracle data storage architecture, Oracle table
and indexes, and how to
1-1: The Oracle Relational Database
The relational model
Recursive many-to-many relationships
1-2: Inside the Oracle Architecture
1-3: Data storage
Solid state disks
Flat-file data storage (BFILE, external tables)
Spreadsheet file access
1-4: Introduction to Oracle Tables
Index organized tables
1-5: Introduction to Oracle Indexes
Bitmap join indexes
1-6: Database access methods
Introduction to Oracle Data Access
This is an introduction to Oracle SQL and SQL*Plus.
2-1: SQL Processing
Creating the executable
Inside the library cache
2-2: Oracle data dictionary
The X$ fixed tables
The DBA Views
The v$ views
Running dictionary scripts
Using the desc command
Using the spool command
2-4: Syntax of SQL
Select, project and join
ORDER BY clause
GROUP BY clause
SQL in SELECT clause (Oracle9i new feature)
2-5: Report generation with SQL*Plus
Running an SQL command
Building and formatting an SQL command
Formatting a SQL report
Spooling a report
Logical encapsulation of complex queries
Using the DBA_VIEWS view
Problems combining views
Introduction to DDL and DML
This is an introduction to Oracle schema definition and data updating.
3-1: SQL schema navigation
Schema entity types
Relationships between schema entities
Oracle objects (tables, indexes, IOT, etc.)
3-3: Referential Integrity
Implementing Data Integrity
Types of RI not null, unique check, foreign key
Rules for using RI
System-named constraints (SYSnnn)
Viewing Constraint Information with dba_constraints
3-4: DDL Introduction
Create a database
Create a table
Create an index
Altering schema objects
3-5: DML Introduction
RI constraints (restrict, cascade)
Snapshot too old
3-6: Read consistency, locking & DML
Why read consistency?
UNDO segments and read consistency
4-1: Introduction to the PL/SQL Language
Procedures, packages and functions
4-2: PL/SQL Language structures
Looping within PL/SQL
If testing (if then else syntax)
4-3: SQL with PL/SQL
Using a cursor
Fetching from a cursor
4-4: PL/SQL Packages and Procedures
4-5: Extending SQL with a user-defined PL/SQL function
4-6: Oracle supplied DBMS packages
This is an introduction to Oracle reporting tools and techniques. Your
will learn how to use the SQL*Plus formatting commands to create easy
reports from Oracle, how to join multiple tables together and how to
easily aggregate, summarize and analyze Oracle table data. You also
learn how Oracle access the tables and indexes and see how to ensure
that your SQL uses the fastest methods for accessing your data.
5-1: Formatting commands in SQL*Plus
5-2: Analytical functions in SQL
5-3: Table joins
Hiding joins by creating views
Using IN, NOT IN, EXISTS and NOT EXISTS
Exercise write a subquery
5-4: Subqueries in SQL
IN and NOT In operators
5-5: Aggregation in SQL
Using wildcards in queries (LIKE operator)
Min and max
Using the group by clause
5-6: Materialized Views for reports
To people that are new to SQL, John Garmany proves
that SQL does NOT stand for Scary Query Language. It is an excellent
step-by-step primer to take the uninitiated from clueless to competent.
What I think is most impressive, is Mr. Garmany's ability to quickly
take the student from creating very simple queries to very complex
queries without causing the user severe mental and emotional stress. In
fact, the examples included in the book, while challenging, are
interesting, and even fun. There are lots of SQL books on the market,
but this one doesn't require you to be the office geek to get a LOT out
of it. Get this book, work through the examples, and pretty soon you to
can impress your co-workers, as well as your boss. Highly recommended!
SAN: 2 5 5 - 1 3 1 4