To get the free app, enter your email address or mobile phone number.
Pro Oracle SQL (Expert's Voice in Oracle) 2010th Edition
Use the Amazon App to scan ISBNs and compare prices.
Top 20 lists in Books
View the top 20 best sellers of all time, the most reviewed books of all time and some of our editors' favorite picks. Learn more
Customers Who Bought This Item Also Bought
More About the AuthorsDiscover books, learn about writers, read author blogs, and more.
Top Customer Reviews
The authors have assumed you are already in the Oracle field. If you are not, then the material may often overwhelm you. Novices can find more suitable books out here for sure. By the time you are through the book, you'll be up several levels when it comes to writing better SQL or understanding better already written SQL.
I give all 5 STARS to the authors of the book for the great job done on demystifying SQL execution plans. The book shows and analyzes execution plans over and over again until they become your second nature. It took chapters 2 through 6 to build the necessary background and take readers to the very hart of execution plans. The rest of the book also uses the plans as the main tool for SQL characterization and performance analysis.
Page 165 shows how to read an exec plan as a plain English narrative. In my experience, this is highly useful for:
1. Putting yourself in the shoes of Oracle Optimizer - think the way HE thinks.
2. Presenting in plain English the SQL execution problems to inquisitive but less-technical folks, from VPs and directors to functional users.
My experience has thought me that being able to understand, interpret, assess and compare SQL execution plans is a great skill to have.Read more ›
I pre-ordered this book in October 2010 while searching for a way to learn some of the more advanced features of Oracle Database's SQL; I have been searching for a follow up book to the "Mastering Oracle SQL and SQL*Plus" book that I read a couple of years ago, and I think that I finally found that follow up book. Written as the Oracle Database 11.2 sequel to the book "Mastering Oracle SQL and SQL*Plus" (and that book's much updated revision titled "Beginning Oracle SQL"), this book is not written as a simple reference for the Oracle specific SQL dialect. This is not a book that you will want to use when trying to learn the basics of creating a simple SQL statement with a four table join. However, if you are able to create that simple SQL statement with a four table join in less than 30 minutes with the help of an entity-relationship diagram (ERD), and without using a DISTINCT clause, this book's contents will prove to be a valuable resource not only to expand your depth of knowledge of the SQL language, but also to extract the extra value that becomes visible when Oracle Database is viewed as much more than a black box dumping ground for data.
The authors of this book are all OakTable Network members and have between 15 and 29 years of experiencing working with Oracle products. This long term exposure to Oracle Database is quite clearly an advantage when discussing many of the subtopics that are simply missed by other Oracle specific SQL language references. While there was no discussion of the SQL language from Oracle Database 2.Read more ›
Ignore chapter One - it's not indicative of the rest of the book. It covers only things you ought to already know and rightly redirects you elsewhere if you don't understand any of it.
You'll want to have an Oracle system available to you as you read this book, so that you can try out the examples. It should be a system where you can freely experiment because you will want to create tables, run the SQL and then look at the explain results in the Plan tables.
I did especially like Chapter 5 - "It's about the Question" -- you do really need to understand what you are trying to retrieve before you write the query. That chapter is about determining what the question really is. This is perhaps the only chapter that is independent of the database system.
There's a lot of information in this book and many times I found I was picking up things that were new to me, even though I have been working with Oracle for some years (and SQL for many more years).
This books does a great job in refreshing what you already know and enriching with
lot of additional information.Though all the chapeters in the book were good. The chapters from Kerry Osborne is Excellent. Any developer/DBA working on a complex production system should read Chaper 16. Plan stability and Control. Trouble shooting Oracle perfomance from Christian Antognini addresses this topic in great length ,but still there are some additional information.
The scripts provided alongside is extremely useful as well.
The chapters from the other authors were also pretty interesting and well researched.
I am planning to write another review on Expert Oracle Exadata by Kerry Osborne,Randy Johnson,Tanel Poder which is the Bible for Exadata as of today.
Overall excellent value for money.
Most Recent Customer Reviews
Some excellent tips here on Oracle in general, from a number of contributors, all experts in their various fields. Read morePublished on May 23, 2013 by Gerry
I bought this book because I am about to get involved with Oracle 11g. The first thing I liked about it is that each chapter is written by a different person, so you don't get one... Read morePublished on September 21, 2012 by William R. Bullerman
This book is great. If you are DBA or developer , you will find a lot of things in this book you have ever skip for latter understanding. Read morePublished on May 7, 2012 by Sergey Tatarinov
I recently began reading Pro Oracle SQL to get a brush up on writing better SQL. What I got was far better. Read morePublished on May 23, 2011 by Lon White - AZOAUG