|Got More Books?This month’s question came to us from a colleague:
“In a previous issue, you recommended a couple of introductory Oracle books? Can you recommend some advanced Oracle books?”
Iggy Fernandez of the Database Specialists team responds:
Mark Twain stated the obvious when he said: “The man who doesn’t read good books has no advantage over the man who can’t read them.” But who has the time to read?
Books to the ceiling, books to the sky;
My piles of books are a mile high.
How I love them!
How I need them!
I’ll have a long beard by the time I read them.
If I had the time, these are the books I would read twice, from cover to cover.
- Oracle Database Concepts by Oracle Corporation: If you have time to read only one book, then this is the book you should read. As Leonardo da Vinci said: “Those who are in love with practice without science are like the sailor who boards a ship without rudder and compass, who is never certain where he is going. Practice must always be built on sound theory.” This book is the rudder and compass for your journey through the world of Oracle. And you can’t quarrel with the price; it’s free.
Effective Oracle By Design
by Tom Kyte
: Instead of scrambling to improve performance after you have deployed your database and application, why not design them right? This book was written in the days of Oracle 9i
but it is still one of the best Oracle books that money can buy.
Practical Oracle 8i: Building Efficient Databases
by Jonathan Lewis
: Don’t be misled by the title. Mogens Norgaard reports that when Jonathan Lewis was asked if his book would ever be published in an updated 9i
version, his response was to suggest that you put a sticker with a “9” over the “8” on the cover because the advice, methods and techniques described in the book were still very valid with Oracle 9i
The Art and Science of Oracle Performance Tuning
by Chris Lawson
: This book was written for Oracle 8i
and Oracle 9i
but is one of my favorites. It describes a systematic five-step method for solving any performance tuning problem. Oracle Database versions may change and specific tools and techniques may change but the five steps always remain the same. A problem may be simple and require only a few minutes of your time or it may be tremendously complex and require weeks of your time but the five steps always remain the same.
by Dan Tow
: Dan Tow has spent a lifetime studying how to write SQL that is both correct as well as efficient and this book summarizes knowledge accumulated over many years.
SQL Programming Style
by Joe Celko
: This is not the easiest book to read but it will appeal to those who are working towards their black belt in SQL.
Oracle PL/SQL Best Practices
by Steven Feuerstein
: Steven Feuerstein’s mastery of PL/SQL is positively transcendent and this book is worth its weight in gold.
Database System Concepts
by Abraham Silberschatz et al
: This book, now in its fifth edition, is a well-known college textbook. Its main focus is the theory of database management systems e.g. relational algebra, relational calculus, normal forms, transaction management, query optimization, etc. but it also has great discussions of the big three database systems i.e. Oracle, DB2, and SQL Server.
I hope this answer helps you. Best of luck to you.
From the May 2008 issue of The Specialist newsletter.
P.S. Reader Mark Harrison from Northern California commented: “Nice list… and at 6,020 pages, it’s only half again as long as the 4,195 pages in Harry Potter.” Congratualations, Mark. You win the accuracy prize. We clicked on the Amazon.com links for each book in the list and came up with the same total. We also noticed that used copies of some of the books in the list can be purchased for just a few dollars. Get them while they last.