Product DescriptionOracle is the world's leading relational database. It provides a rich environment to store, handle, and extract data. When used properly, Oracle provides a solid foundation upon which to build enterprise scale applications.
Mastering the Oracle database is not an overnight job. It takes time, practice, and a lot of real world experience. This book teaches you the core concepts behind using the database, shows you the tools and techniques you need to master, and gives you practical examples of programming Oracle. By the time you have completed this book, you will have all the knowledge you need to use Oracle databases with confidence.
You are setting out on the same journey we travelled some years ago. We know the things you are going to run into time and time again. We understand the challenges you are going to meet when you have to develop an application or administer your database. We can guarantee you that the techniques you'll learn in this book are proven and have led us through many successful implementations.
What does this book cover:
* Oracle terminology, tools, concepts, and architecture * The functionality of the different versions and editions of Oracle (8, 8i, and 9i) * Basic and advanced Oracle SQL * Mastering SQL * Plus as an Oracle development tool * Understanding tables, indexes, transactions and concurrency, views, triggers, and objects * Using PL/SQL to write and package procedural code in the database * Securing your Oracle applications * Evaluating performance and tuning your Oracle application * A SQL Toolkit of useful scripts that you can use in your database * Case studies that apply this knowledge to create two practical Oracle applications
Customer Reviews
Average Rating:
Rating: - Provides in-depth, lucid and systematic treatment of subject
The book epitomises simple yet detailed coverage of the Oracle 9i programming. The best feature of the book is the methodical illustration of even the smallest and trivial concept by sample program which aides in understanding. Nonetheless I found the coverage of arcane topics like index, objects - which sound simple at the periphery but daunt the programmers once dealth in depth - very nice. The two case studies provided illustrates the concept better. However the book doesnt cover data modelling ... Read More
Rating: - Excellent stuff for a beginner
This one is great book for anyone who's beginning to learning oracle programming. I bought this book after the T kyte's expert one-on-one so to me I could brush faster thru (some) pages. I guess i'm a sucker when it comes to wrox books.
But a good starting point for beginners!
Rating: - Not bad, but doesn't cover Java programming with Oracle ...
This books isn't bad on PL/SQL, but if you want to write Java programs with Oracle you'll also need a JDBC book.
Rating: - Best Beginner Book, HANDS DOWN!
I am a Web Developer (ASP) with an MS SQL background. I got throw into a project that uses an Oracle database for its backend. If not for this book I do not know where I would be. This is the best book I've seen for a newbie to Oracle. BUY THIS BOOK NOW!!!
Rating: - Should be titled "Beginning Oracle 9i Programming"
In the usual Wrox style, this is a well-rounded introductory book on Oracle programming, with detailed, reader-friendly discussions on architecture and many "Try it out" exercises.
That being said, the book concentrates so much on 9i that if you have installed 8i (or perhaps even Personal Oracle 9i) then you might be discouraged by frequent references and exercises for things you won't be able to do. According to Oracle, 9i Enterprise for Win2K requires 512M of RAM (although other sources ... Read More
- Provides in-depth, lucid and systematic treatment of subject
- Excellent stuff for a beginner
- Not bad, but doesn't cover Java programming with Oracle ...
