Oracle SQL: Jumpstart with Examples [Paperback]

Gavin JT Powell (Author), Carol McCullough-Dieter (Author)

Book Description

ISBN-10: 1555583237 | ISBN-13: 978-1555583231 | Publication Date: October 7, 2004 | Edition: 1

Developers and DBAs use Oracle SQL coding on a daily basis, whether for application development, finding problems, fine-tuning solutions to those problems, or other critical DBA tasks. Oracle SQL: Jumpstart with Examples is the fastest way to get started and to quickly locate answers to common (and uncommon) questions. It includes all the basic queries: filtering, sorting, operators, conditionals, pseudocolumns, single row functions, joins, grouping and summarizing, grouping functions, subqueries, composite queries, hierarchies, flashback queries, parallel queries, expressions and regular expressions, DML, datatypes (including collections), XML in Oracle, DDL for basic database objects such as tales, views and indexes, Oracle Partitioning, security, and finally PL/SQL.

* Each of the hundreds of SQL code examples was tested on a working Oracle 10g database
* Invaluable everyday tool that provides an absolute plethora of properly tested examples of Oracle SQL code
* Authors have four decades of commercial experience between them as developers and database administrators

Editorial Reviews

Review

"As a consultant with more than 12 years of experience working with Oracle databases on a daily basis, reviewing this book was a unique and enjoyable experience. The SQL language is without doubt one of the most critical database skills and it is best learned by example. This book addresses that crucial need. Mr. Powell does an excellent job of clarifying the concepts by using meaningful and easy to understand examples. Frankly, I have not come across any other book on SQL that is as good a compilation of SQL concepts in a single source as this book.

One comes across very few books that make a significant difference in your fundamental understanding of the subject. This is one such book if you want to understand a core database skill - SQL. This book deserves a place in your library and you will find it a great reference not only for learning SQL but also for learning data relationships, data organization, data analysis possibilities and so forth. I feel that the title, Oracle SQL: Jumpstart with Examples, might be too simplistic to describe the content. Read on, you will find the real value hidden inside this book." -- Ravi Sharma, Senior Principal Consultant

Book Description

For the quickest solutions to any knotty coding problem, a complete Oracle SQL reference

See all Editorial Reviews

Product Details

• Paperback: 688 pages
• Publisher: Digital Press; 1 edition (October 7, 2004)
• Language: English
• ISBN-10: 1555583237
• ISBN-13: 978-1555583231
• Product Dimensions: 9.1 x 7.5 x 1.7 inches
• Shipping Weight: 3.1 pounds (View shipping rates and policies)
• Average Customer Review: 4.3 out of 5 stars  See all reviews (3 customer reviews)
• Amazon Best Sellers Rank: #2,148,084 in Books (See Top 100 in Books)

More About the Author

Discover books, learn about writers, read author blogs, and more.

Customer Reviews

Most Helpful Customer Reviews

9 of 13 people found the following review helpful:

3.0 out of 5 stars Real reviews, please, May 13, 2006

By 

Melliforte (Georgia, US) - See all my reviews

This review is from: Oracle SQL: Jumpstart with Examples (Paperback)

It is interesting that reviewers J. Shimko and Jon Equrrola have identical reviewer rank, and that they only review books by Gavin JT Powell.

I'll wait for less suspicious and more informative reviews to be posted before considering this book.

Since I must give a rating in order to post a review, I am giving the book 3 stars because the existing reviews have neither honestly extolled its brilliance nor decried its awfulness, so I am guessing its quality is average.

3 of 5 people found the following review helpful:

5.0 out of 5 stars Another Gem!, November 13, 2004

By 

David H. Kravatz "dhk_books" (Forest Hills, New York United States) - See all my reviews
(REAL NAME)   

This review is from: Oracle SQL: Jumpstart with Examples (Paperback)

I recently purchased Gavin Powell's Exam Cram Title which I thought was an excellent product. Because I still needed help with SQL because I was a newbee, I purchased his Oracle SQL: Jumpstart with Examples. With his clear, easily understandable writing, Mr. Powell has a gift for making some very difficult concepts within the scope of the reader with an average intelligence. He also provides excellent examples.

3 of 6 people found the following review helpful:

5.0 out of 5 stars Excellent Oracle Jumpstart!, January 24, 2005

By 

J. Shimko - See all my reviews

This review is from: Oracle SQL: Jumpstart with Examples (Paperback)

I found the Oracle SQL Jumpstart with Examples an excellent Oracle review and reference book.

The authors have provided valuable SQL and general database information. The book covers SQL and basic database structure and syntax, and provides simple and easy to understand examples which are useful for building complex database elements.