Free Downloads
Effective Oracle By Design (Osborne ORACLE Press Series)

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.

Series: Oracle Press

Paperback: 688 pages

Publisher: McGraw-Hill Education; 1st edition (September 12, 2003)

Language: English

ISBN-10: 0072230657

ISBN-13: 978-0072230659

Product Dimensions: 7.1 x 1.7 x 9.1 inches

Shipping Weight: 3 pounds (View shipping rates and policies)

Average Customer Review: 4.9 out of 5 stars  See all reviews (33 customer reviews)

Best Sellers Rank: #982,818 in Books (See Top 100 in Books) #240 in Books > Computers & Technology > Databases & Big Data > Oracle #1025 in Books > Textbooks > Computer Science > Database Storage & Design #7312 in Books > Computers & Technology > Software

Of course, the best Oracle book ever is "Expert One-on-One Oracle" also by Tom Kyte, but being second is still being a head and shoulders above any other Oracle book. Tom's books, both of them, really do show you how to be successful with Oracle. Again and again, chapter after chapter, he shows you how find the information, how to create packages, and how to test. If you did nothing but type in the examples he gives you on testing (they all work, by the way), you would easily justify buying both this book and dinner for Tom (which is not required). There are few books that boost your skills by a quantum measure, but this is one. Tom's emphasis on testing at a low level of development, is the only way to insure that you are not wasting money on a non scalable application. Most of us do not know how easy it is to do small-time and big-time bench marking, so it does not get done often enough. This book shows you every step, from setting up your environment, to tests that really work. There is nothing missing that would keep you from understanding what he is doing, why it is meaningful, and how you can do the same thing. Tom does not assume you have any particular knowledge, he shows you how, in a way that engineers of any level can follow. One thing the book does not do, is describe a huge project that Tom did. Books that do that are rarely much good for anything but the same project. What this book does do, is take the questions you might have about current topics relating to enterprise level applications, and work you through many iterations of the basic Oracle designs and tools you will need to be successful on any project, not just one he did.

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!

Effective Oracle by Design (Osborne ORACLE Press Series) Oracle Essbase & Oracle OLAP: The Guide to Oracle's Multidimensional Solution (Oracle Press) Crystal Reports XI: The Complete Reference (Osborne Complete Reference Series) Oracle Database 11g & MySQL 5.6 Developer Handbook (Oracle Press) OCA/OCP Oracle Database 11g All-in-One Exam Guide with CD-ROM: Exams 1Z0-051, 1Z0-052, 1Z0-053 (Oracle Press) Oracle Database 12c The Complete Reference (Oracle Press) Oracle Database 12c DBA Handbook (Oracle Press) Oracle Big Data Handbook (Oracle Press) Oracle E-Business Suite Development & Extensibility Handbook (Oracle Press) OCA Oracle Database 12c SQL Fundamentals I Exam Guide (Exam 1Z0-061) (Oracle Press) Oracle Solaris 11.2 System Administration Handbook (Oracle Press) Oracle Database 12c Install, Configure & Maintain Like a Professional (Oracle Press) Oracle Procure-to-Pay Guide (Oracle Press) Oracle Database 11g SQL (Oracle Press) Oracle Database 11g New Features (Oracle Press) ORACLE PL/SQL 101 (Oracle Press) Oracle RMAN 11g Backup and Recovery (Oracle Press) Oracle Database Ajax & PHP Web Application Development (Oracle Press) Effective MySQL Optimizing SQL Statements (Oracle Press) AIX 5L Administration (McGraw-Hill Osborne Networking)