Enter your mobile number or email address below and we'll send you a link to download the free Kindle App. Then you can start reading Kindle books on your smartphone, tablet, or computer - no Kindle device required.
To get the free app, enter your mobile phone number.
Pro Oracle SQL (Expert's Voice in Oracle) 1st ed. Edition
Use the Amazon App to scan ISBNs and compare prices.
Windows 10 For Dummies Video Training
Get up to speed with Windows 10 with this video training course from For Dummies. Learn more.
Customers Who Bought This Item Also Bought
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 ›
This book covers a wide variety of critically important topics. Each chapter author is a recognized expert in their field, and each chapter is infused with practical, real-world experience. Each chapter includes illustrative and informative examples. The topics cover a very wide range: design, troubleshooting, monitoring, tuning, firefighting, very large databases, running on Windows, cloud computing, and security. Most of the chapters are technical, but plenty of organizational and collaborative advice is also included. Although it is unlikely that your work spans all of these topics, you will certainly find direct and immediate benefit from one or more of the chapters. Reading the other chapters is an excellent and easy way to broaden your outlook and improve your skills.
A book like this, written independently by sixteen authors, with each chapter addressing a different topic, has a real potential to be scattered and incoherent. This book does not fall prey to that danger. Instead, this book has a very coherent and cohesive flavor, probably due to the shared vision of the Oak Table Network. What seems to bind these authors together is a scientific spirit, grounded in empirical, verifiable, real-world experience. Also, these authors are all very active contributors to the Oracle community, so they know how to collaborate, explain, and educate. Moreover, they do this with a sense of fun and adventure! This spirit of joyful sharing, combined with practical expert advice, sets this book apart. It is required reading for all serious DBAs.
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 ›
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
Few books shaped my approach to Understand Oracle architecture and systematize Oracle tuning. 1. Expert one on one -Tom Kyte 2. Effective Oracle by design -Tom Kyte 3. Read morePublished on September 13, 2011 by David Raj Daniel
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
This is by far the best Oracle SQL book I have ever come across. They give a fantastic explanation of how things work and in an easy to understand way...Published on March 7, 2011 by Mike Alba
This is not a book for learning to write SQL - you need to know how to do that before you read this book. This is a book for learning to write better SQL with Oracle. Read morePublished on December 30, 2010 by Scott