Professional Oracle Programming (with source code)

Professional Oracle Programming is intended for application developers who use Oracle as their database. As such, this book does not devote much space to topics which are primarily of interest to database administrators, such as backup and recovery. Most importantly, this book is designed to help a programmer understand the database issues that can have a direct impact on the operation and performance of their applications.

This volume attempts to provide a foundation for these developers, as well as guidance and examples of some of the key areas of interest and necessity. These areas include accessing data using SQL, handling issues such as multi-user concurrency and data integrity and security, the basics of programming with Java, PL/SQL and XML, and data warehousing.

This book is intended for people whose primary job is to create application systems. They are developers, rather than database administrators. Following through on this profile, we believe that you, the professional developer, are well informed and skilled in the creation of these application systems. In our experience, even professional developers may think of the database they use as nothing more than a place to store data.

TABLE OF CONTENT:
Chapter 01 - Oracle Architecture and Storage
Chapter 02 - Using SQL
Chapter 03 - Handling Multiple Users
Chapter 04 - Database Design Basics
Chapter 05 - Oracle Security
Chapter 06 - The Oracle Data Dictionary
Chapter 07 - Installing Oracle
Chapter 08 - Introduction to SQL
Chapter 09 - Extended SQL
Chapter 10 - Indexes
Chapter 11 - Constraints
Chapter 12 - Other Database Structures
Chapter 13 - Functions
Chapter 14 - Distributed Queries, Transactions, and Databases
Chapter 15 - PL/SQL Basics
Chapter 16 - PL/SQL and SQL
Chapter 17 - PL/SQL Packages
Chapter 18 - Introduction to Java Database Programming
Chapter 19 - Triggers
Chapter 20 - Regular Expressions and Expression Filter
Chapter 21 - Object Relational Interactions with Oracle
Chapter 22 - Oracle XML DB
Chapter 23 - HTML-DB
Chapter 24 - High-Speed Data Movement
Chapter 25 - Data Loading and Management
Chapter 26 - Business Intelligence Query
Chapter 27 - Business Intelligence Analysis
Chapter 28 - Optimization

Download Here

Password:ganelon