Oracle expert one-on-one

It is critical that the DBA knows what the developers are trying to accomplish and the best developers know how to exploit the DBA's data management strategies. Armed with the fundamental knowledge of the Oracle environment that Tom describes, you will be able to build bigger, faster, and more scalable applications.

Knowledge of SQL and PL/SQL is assumed and familiarity with any 3GL language (such as C, Java, or Visual Basic) would be useful.

Table of Contents

• Introduction
• Setting Up
• Chapter 1: Developing Successful Oracle Applications
• Chapter 2: Architecture
• Chapter 3: Locking and Concurrency
• Chapter 4: Transactions
• Chapter 5: Redo and Rollback
• Chapter 6: Database Tables
• Chapter 7: Indexes
• Chapter 8: Import and Export
• Chapter 9: Data Loading
• Chapter 10: Tuning Strategies and Tools
• Chapter 11: Optimizer Plan Stability
• Chapter 12: Analytic Functions
• Chapter 13: Materialized Views
• Chapter 14: Partitioning
• Chapter 15: Autonomous Transactions
• Chapter 16: Dynamic SQL
• Chapter 17: interMedia
• Chapter 18: C-Based External Procedures
• Chapter 19: Java Stored Procedures
• Chapter 20: Using Object Relational Features
• Chapter 21: Fine Grained Access Control
• Chapter 22: n-Tier Authentication
• Chapter 23: Invoker and Definer Rights
• Appendix A: Necessary Supplied Packages
• Appendix B: Support, Errata and p2p.wrox.com
• Index