Oracle SQL by Example (3rd Edition) (Prentice Hall Professional Oracle Series) (Paperback)

by Alice Rischert (Author)

Editorial Reviews

Product Description
Oracle SQL by Example, Third Edition is a convenient, quick way to master Oracle SQL. This unique integrated book-and-Web learning solution teaches all the SQL skills you will need to succeed in an Oracle environment. Through hands-on, real-world labs, exercises, projects, and a superb Web-based training site, the book teaches administrators and programemrs alike the core skills required for their jobs. Coverage includes every key Oracle SQL concept, including: entity-relationship diagrams, the SQL*Plus environment, SELECT and other statements, Boolean operations, joins, aggregate and not-aggregate functions. Each chapter contains review exercises that help the reader master the important skills before they move on.

From the Back Cover

The book ... has enough depth for even a seasoned professional to pick up enough tips to pay back the price of the book many times over.—Dr. Paul Dorsey, President Dulcian, Inc., and President, New York Oracle Users Group.

Students find Oracle SQL by Example to be extremely helpful not only to their coursework but also in preparing them for future careers as Oracle DBAs and developers. The layout of the text is conducive to the learning process. It introduces a concept and then reinforces that concept with an exercise.—Betsy Jenaway, Coordinator, Malcomb Operations, and Senior Lecturer College of Management, Lawrence Technological University, Southfield, MI.

The world's #1 hands-on Oracle SQL workbook ... fully updated for Oracle 10g

Crafted for hands-on learning and tested in classrooms worldwide this book illuminates in-depth every Oracle SQL technique you'll need. From the simplest query fundamentals through the newest regular expression database enhancements, you will focus on the tasks that matter most. Hundreds of guided lab exercises will systematically strengthen your expertise in writing effective, high-performance SQL. Along the way, you will acquire an arsenal of useful Oracle SQL knowledge and techniques: an extraordinary library of solutions for your real-world challenges with Oracle SQL.

• Creating and using tables, views, indexes, and sequences
• Working in SQL*Plus and iSQL*Plus environments
• Oracle functions in depth—especially number, character, date, timestamp, interval, time zone, aggregate, and analytical functions
• All types of joins, including equijoins, outer joins, self joins and ANSI join syntax options
• Every type of subquery, including correlated and scalar subqueries, set operators, hierarchical queries, flashback queries, data dictionary, object-relational features, regular expressions, and more
• Common pitfalls to avoid, and solutions for common mistakes
• Practical performance, security, and architectural solutions
• Insights, tips, and tricks-of-the-trade from an experienced Oracle professional
• For every database developer, administrator, designer or architect, regardless of experience!

See all Editorial Reviews

Product Details

• Paperback: 960 pages
• Publisher: Prentice Hall PTR; 3 edition (June 27, 2004)
• Language: English
• ISBN-10: 0131451316
• ISBN-13: 978-0131451315
• Product Dimensions: 9.1 x 7 x 1.4 inches
• Shipping Weight: 3 pounds (View shipping rates and policies)
• Average Customer Review: 4.7 out of 5 stars See all reviews (6 customer reviews)
• Amazon.com Sales Rank: #135,606 in Books (See Bestsellers in Books)

  Popular in these categories: (What's this?)

  #10 in	Books > Computers & Internet > Databases > Oracle > SQL
  #18 in	Books > Computers & Internet > Databases > Oracle > PL & SQL
  #35 in	Books > Computers & Internet > Databases > Relational Databases

Customer Reviews

Most Helpful Customer Reviews

7 of 8 people found the following review helpful:

5.0 out of 5 stars Comprehensive on basics but weak on advanced features, August 12, 2005

By	James (Colorado Springs, CO United States) - See all my reviews

The book improves with each edition. The brief data modeling section is adequate but uses Information Engineering data models and should be updated to use UML. The treatment describing joins fails to adequately explain why you chose one over the other.

There are a few errors here and there, like the default for the DATE format mask, which is 'DD-MON-RR' not 'DD-MON-YY'. Multiple table join coverage of ANSI SQL: 1999 standard is weak but there is currently no better treatment. Hierarchical queries in the Oracle 10gR1 release perform differently than in Oracle 9i and there is no coverage of differences.

A future edition of the book should expand its treatment of recursive, or self-referencing, joins and hierarchical joins. Also, I would recommend she expand the: (a) discussion of inner, outer and full outer joins; (b) discussions and exercises to support multiple table joins; and (c) coverage of analytical SQL for data warehouses.

1 of 1 people found the following review helpful:

4.0 out of 5 stars Depth on a long and winding road, November 12, 2006

By	Spencer (San Jose) - See all my reviews

This is an good book to explore the mechanics of Oracle's implementation of SQL. It has average organization, but you'll have a bumpy read.

The exercises are sometimes the only place concepts are addressed. Some information on Oracle is incorrect, like the default date format. The book uses the value prior to Y2K. The 3rd Edition is a patch work of changes and a complete or major overhaul would be helpful. It is not for a beginner in Oracle technology.

The book vaguely mentions normalization, the examples are poorly thought out and too shallow to be of any value. If you're studying for the certification exam, this isn't the book you should buy.

3 of 4 people found the following review helpful:

4.0 out of 5 stars Good coverage of Oracle SQL , August 15, 2005

By	Zelimir Lucic - See all my reviews (REAL NAME)

The content look deceptively simple. However upon further reading one finds that it covers many aspects or ORACLE SQL plus differences between ORACLE and ANSI standard.
One does need to know some relational database theory before starting to read this book though. It does cover the basic of the relational database theory but not in a depth.
However the ORACLE SQL statements and functions are very well presented and the book does cover details and use cases.