Effective Oracle by Design (Oracle Press) and over 1.5 million other books are available for Amazon Kindle . Learn more

Buy New

or
Sign in to turn on 1-Click ordering.
Buy Used
Used - Very Good See details
Price: £10.72

or
Sign in to turn on 1-Click ordering.
 
   
Trade in Yours
For a £0.75 Gift Card
Trade in
More Buying Choices
Have one to sell? Sell yours here
Sorry, this item is not available in
Image not available for
Colour:
Image not available

 
Start reading Effective Oracle by Design (Oracle Press) on your Kindle in under a minute.

Don't have a Kindle? Get your Kindle here, or download a FREE Kindle Reading App.

Effective Oracle by Design (Oracle Press) [Paperback]

Thomas Kyte
4.2 out of 5 stars  See all reviews (5 customer reviews)
RRP: £41.99
Price: £26.87 & this item Delivered FREE in the UK with Super Saver Delivery. See details and conditions
You Save: £15.12 (36%)
o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o
Only 5 left in stock (more on the way).
Dispatched from and sold by Amazon. Gift-wrap available.
Want delivery by Saturday, 25 May? Choose Express delivery at checkout. See Details

Formats

Amazon Price New from Used from
Kindle Edition £20.15  
Paperback £26.87  
Trade In this Item for up to £0.75
Trade in Effective Oracle by Design (Oracle Press) for an Amazon.co.uk gift card of up to £0.75, which you can then spend on millions of items across the site. Trade-in values may vary (terms apply). Learn more

Book Description

1 Sep 2003 0072230657 978-0072230659
Tom Kyte of Oracle Magazine’s “Ask Tom” column has written the definitive guide to designing and building high-performance, scalable Oracle applications. The book covers schema design, SQL and PL/SQL, tables and indexes, and much more. From the exclusive publisher of Oracle Press books, this is a must-have resource for all Oracle developers and DBAs.

Frequently Bought Together

Effective Oracle by Design (Oracle Press) + Expert Oracle Database Architecture: Oracle Database Programming 9i, 10g, and 11g Techniques and Solutions 2nd Edition + Oracle PL/SQL Programming
Price For All Three: £107.10

Buy the selected items together


Product details

  • Paperback: 688 pages
  • Publisher: McGraw-Hill Osborne (1 Sep 2003)
  • Language: English
  • ISBN-10: 0072230657
  • ISBN-13: 978-0072230659
  • Product Dimensions: 18 x 2.5 x 23 cm
  • Average Customer Review: 4.2 out of 5 stars  See all reviews (5 customer reviews)
  • Amazon Bestsellers Rank: 463,813 in Books (See Top 100 in Books)
  • See Complete Table of Contents

More About the Author

Discover books, learn about writers, and more.

Product Description

Review

Effective Oracle by Design [provides] a lot of examples and tips that you
can use everyday.
-- Oraclehome.co.uk, July 2006

From the Back Cover

Streamline Application Development with Help from an Oracle Expert

Oracle guru Tom Kyte has written the definitive guide to designing and building high-performance, scalable Oracle applications. Providing detailed code examples throughout, Tom teaches proactive and efficient methods to develop and tune Oracle applications that fully exploit the database. You'll learn how to maximize the built-in functionality of the tools you're using in order to achieve the best results possible. From the exclusive publisher of Oracle Press books, this is a must-have resource for all Oracle developers and DBAs.

  • Use SQL*Plus, TKPROF, STATSPACK, JDeveloper, and other tools
  • Take advantage of Oracle's scalable architectural implementations
  • Handle administration with SPFILES, Oracle Managed Files, and Automatic Segment Space Management
  • Use archivelog mode, RMAN, and Data Guard for bulletproof backup and recovery
  • Improve statement processing by using bind variables and reducing parsing
  • Make full use of the Cost Based Optimizer (CBO)
  • Choose data structures that result in effectively designed schemas
  • Write efficient SQL statements and high-performance PL/SQL code
  • Learn invaluable techniques from an Oracle insider

Inside This Book (Learn More)
Browse Sample Pages
Front Cover | Copyright | Table of Contents | Excerpt | Index
Search inside this book:

What Other Items Do Customers Buy After Viewing This Item?


Customer Reviews

4 star
0
3 star
0
2 star
0
4.2 out of 5 stars
4.2 out of 5 stars
Most Helpful Customer Reviews
17 of 17 people found the following review helpful
5.0 out of 5 stars Another masterpiece from Thomas Kyte 22 Feb 2004
Format:Paperback
The previous work by the same author, "Expert one-on-one: Oracle", got an average of 5/5 stars and more than 50 reviews, which is of course an outstanding result for any book, but especially for books about Oracle, which aren't normally so well-received by the readers community (to say the least). Well, I'm sure that this book is going to get the same success.

Thomas Kyte is well known for being an excellent writer, and in fact the material is presented here in a clear, concise yet complete manner, and it's very easy to follow the discussion and reproduce the examples.

The examples themselves are one of the greatest strengths of this book, because they illustrate, and prove, the topics discussed (and so what is written is *reliable*, which is of course a fundamental property for any technical book, but a quality seldom found in other Oracle tomes). At the same time, the examples (written mostly in SQL and PL/SQL) teach you a lot about how to code appropriately (the Author being a well-known SQL guru), showing e.g. syntactic variations, useful Oracle-supplied packages, new Oracle extensions ... I strongly believe that in order to be a good developer you must be exposed to high quality code, and reading this book is an excellent way to achieve this (well, I learnt more about SQL and PL/SQL from Thomas Kyte's books than from other books dedicated exclusively to SQL and PL/SQL programming).

The book is also magic - it can read your mind. Yes, I had in store a couple of non-trivial questions to be asked on asktom.oracle.com, and I found the answers in the book! Well, this magic property comes straight from the Author's experience in answering thousands of technical question on his aforementioned web site, asked by Oracle developers and DBAs all around the world - so it's not surprising that the book is tuned with what people think, and need to know, about Oracle. I would say that this is a feature present only in Thomas Kyte's books, since there is simply no other place like asktom.

To sum up - this book and "Expert one-on-one: Oracle" are overall the best books about Oracle I've read, and I own more than 15 of them. I can't remember all the times that I've used the latter book in my work as an Oracle specialist, and I've already used a lot of things learnt from this book as well. I absolutely recommend both this and "Expert one-on-one: Oracle".

Comment | 
Was this review helpful to you?
4 of 4 people found the following review helpful
5.0 out of 5 stars All technical books should be written like this 25 Feb 2005
By N. Chivers VINE™ VOICE
Format:Paperback|Amazon Verified Purchase
This is possibly one of the best technical books I have ever read - I can't believe I have been taking a wage based on my skills as an Oracle developer considering the huge gaps in my knowlege that have been highlighted by this tome.

Usually I shy away from large technical volumes because I know from experience they just sit, gathering dust, on my bookshelves. However, this book is so well written it is actually like pleasure reading. If I did have a criticism it would be that the author really pushes his mantra of "do your own benchmarking", consequently every point he makes has lenghthy examples of tests he has run along side it. Sometimes it just makes you think, "OK, I believe you, now lets get on with it". This is a minor quibble, the book is a reference, not meant to be read from cover to cover (although I did) and also much can be learnt from just looking at the code he is writing.

If you have anything to do with Oracle in your working life, other than being the most low level user, you need to read this book.

Comment | 
Was this review helpful to you?
2 of 2 people found the following review helpful
5.0 out of 5 stars Superb 9 April 2005
By Mr. D. S. Stadler VINE™ VOICE
Format:Paperback
I have enjoyed this book a great deal. Kyte offers strategy as well as tactics. His section about Oracle architecture may be unique and is certainly unmatched.

The only criticisms I can offer is that this book is rather long for what it offers and sometimes neglects to show the whys as well as the hows.

An example is with bind variables. Kyte certainly tells you how to do it but I had to learn the why and when (and when not to) from an O'Reilly book. Kyte makes the point that rarely is there a majic bullet within Oracle, that many techniques work well in many or most situations. But he soemtimes doesn't offer the theory which might lead to a good guess on what will work in your situation....

Comment | 
Was this review helpful to you?
Would you like to see more reviews about this item?
Were these reviews helpful?   Let us know
Most Recent Customer Reviews
Search Customer Reviews
Only search this product's reviews

Customer Discussions

This product's forum
Discussion Replies Latest Post
No discussions yet

Ask questions, Share opinions, Gain insight
Start a new discussion
Topic:
First post:
Prompts for sign-in
 

Search Customer Discussions
Search all Amazon discussions
   
Related forums


Listmania!


Look for similar items by category


Feedback


Amazon.co.uk Privacy Statement Amazon.co.uk Delivery Information Amazon.co.uk Returns & Exchanges