Cover of Expert Oracle, Signature Edition Programming Techniques and Solutions for Oracle 7.3 through 8.1.7

Expert Oracle, Signature Edition Programming Techniques and Solutions for Oracle 7.3 through 8.1.7

By: Thomas Kyte

ISBN: 9781590595251

This special signature edition includes a CD that contains a searchable PDF version of the book and a sample chapter from the 10g edition, which was released in fall 2005. This remains the defining book on the older 8i Oracle database if you are a developer or database administrator who works with Oracle-driven database applications. You will encounter wisdom on designing, developing, and administering these applications from one of the world’s foremost Oracle experts, Thomas Kyte. This book is largely inspired by the thousands of questions that Kyte has answered on his site, asktom.oracle.com. The book covers every important feature and function of the 8i version of Oracle, and it is unique in the technical depth and insight that it provides on each topic. This book will show you how to expertly program with the database and exploit its feature set effectively. The result: you will build fast, effective, scalable, and secure Oracle applications.

Format: BOOK
Publisher: Apress
Pages: 1328
Published: 2005-04-20
Language: en

AI Overview

The book "Expert Oracle, Signature Edition Programming Techniques and Solutions for Oracle 7.3 through 8.1.7" by Thomas Kyte is a definitive guide for developers and DBAs working with Oracle-driven database applications. Here is a comprehensive overview of the book:

Key Themes

  1. Technical Depth: The book provides deep wisdom on designing, developing, and administering Oracle database applications. It covers every important feature and function of the Oracle database, explaining why they are important, how they work, and how to use them effectively.
  2. Problem-Solving: It tackles the problems that developers and DBAs struggle with every day, offering practical solutions and insights into common pitfalls.
  3. Database Architecture: The book delves into the architecture of the Oracle database, including files, memory structures, processes, locking mechanisms, concurrency, transactions, redo and undo logs, tables, indexes, data types, and partitioning.

Plot Summary

The book is structured to provide a comprehensive understanding of the Oracle database from version 7.3 to 8.1.7. It includes:

  • Designing and Developing Applications: Practical advice on how to design and develop efficient, scalable, and secure Oracle applications.
  • Administering the Database: Insights into managing the database effectively, including troubleshooting common issues.
  • Feature-Specific Guidance: Detailed explanations of each feature, including how to implement them and avoid common pitfalls.

Critical Reception

The book has received positive reviews for its technical depth and practical insights:

  • Biblio: Described as a defining book on the Oracle database, it is recommended for any developer or DBA working with Oracle-driven applications.
  • ThriftBooks: Praised for its unique technical depth and insight, it is considered essential for anyone looking to program correctly with the database and exploit its feature-set effectively.
  • General Consensus: The book is widely regarded as a must-have for Oracle professionals due to its comprehensive coverage of the database's features and functions.

Additional Features

The signature edition includes:

  • CD with Searchable PDF: A CD containing a searchable PDF of the book, making it easier to navigate and find specific information.
  • Sample Chapter from 10g Edition: A preview of the forthcoming 10g edition, providing a glimpse into future developments.
  • Personal Introduction from Tom Kyte: A personal introduction from the author, offering additional context and insights.
  • Foreword by Ken Jacobs: An intriguing foreword from "Dr. DBA," Ken Jacobs, adding another layer of expertise and perspective.

Overall, "Expert Oracle, Signature Edition" is a seminal work in the field of Oracle database programming, offering a wealth of knowledge and practical advice that has stood the test of time.