Title : Expert Oracle Database Architecture: Oracle Database Programming 9i, 10g, and 11g Techniques and Solutions, Second Edition
Author/s : Thomas Kyte
Publisher : Apress
Category : Data modeling, SQL and JDBC Review by : Christophe Verre
Rating : 10 horseshoes
No need to introduce Tom Kyte from "Ask Tom". Now imagine this great Oracle Database expert, sitting in front of you, lecturing about topics like table and index design or file management. Impossible you think ? Think twice. "Expert Oracle Database Architecture: Oracle Database Programming 9i, 10g, and 11g Techniques and Solutions" is Tom Kyte giving you a lecture. The book talks to you. The book forces you to open SQL*Plus and try yourself. This book is full of examples. Reading about databases might not be as fun as reading about programming, but you'll never get bored.
A chapter at the beginning of the book will help you create a proper test environment. Other chapters can be picked up in any order. In each chapter the author introduces some features, explains why you could be interested in them and how to use them. This includes tons of examples, common pitfalls and misuses.
I've been using Oracle Database for years, not as a DBA, but as a software developer. The amount of knowledge I have learnt with this book is tremendous. Tom Kyte has completely changed the way I see the database. Every developer using the Oracle Database should know more than just SQL. If you're one of them, grab this book as soon as possible.