Oracle Database 12c The Complete Reference (Oracle Press) by Bryla, Bob Published by McGraw-Hill Osborne Media 1st (first) edition (2013) Hardcover Hardcover
Enter your mobile number or email address below and we'll send you a link to download the free Kindle App. Then you can start reading Kindle books on your smartphone, tablet, or computer - no Kindle device required.
To get the free app, enter your mobile phone number.
Top Customer Reviews
If you’re an experienced dba then you will know most of the content in this book and if you’re looking for 12c content I would try the Oracle 12c New features book; if you are new to Oracle or have SQL Server background moving into Oracle, then this is a perfect title to keep as a reference.
Oracle 12c has expanded to 1500 pages and I obtained a copy hoping to learn more about 12c New Features and Recovery Manager and Dataguard in particular. However – silly me - they are big enough subjects in themselves and there are only short summaries in the book, referring to books devoted to just that subject. As others have noted, Oracle documentation is now so huge that NO book can be The Complete Reference. So this book by Bryla and Loney can really be no more (and no less) than a complete introduction with pointers elsewhere. As such it succeeds, though as a summary has too much detail about dynamic tables rather than just highlighting the key ones, whereas I’d have like more DBA commands. It consistently felt like a book written for an Oracle developer.
I particularly liked the roadmaps, highlighting useful new 12c features and what I skimmed was as cogent as ever. I had hoped to read it cover to cover, but it is just too big. So I’m left wondering if a shorter book is needed for wannabe DBAs or developers, but then you couldn’t call it The Complete Reference – but then it isn’t anyway. Though I suppose you could argue it’s the complete reference as it refers to other books
The main gotcha for new DBAs or Developers who are thinking about trying new features (or any features) is LICENSING. So beware of any licence features that are enabled by default or have a mild reference to licensing, even if you use just once.Read more ›
Part 4, 5 and 6 covered using PL/SQL, Object-Relational Databases and Java in the Oracle Database respectively. Part 7 was described as a series of hitchhikers guides in to a number of areas, one example was the 12c specific Pluggable databases guide which took you through installing and managing PDBs on a 12c installation. Part is a very useful alphabetical reference of virtually all the commands you are likely to want to use in SQL, SQL*PLUS and PL/SQL. Each command is decribed and cross-referenced back into the main text of the book and within the alphabetical reference itself.
All in all it is a very useful reference and the inclusion of the CD an ebook version means you can leave the heavy book at home but still take the content with you where ever you need it.
There is no doubt that Oracle as a database system had it's day many, many, many years ago. There is no reason these days to use this awful product (and it's expensive and awful documentation) as regardless of the platform being used there are better alternatives.
Most Helpful Customer Reviews on Amazon.com (beta) (May include reviews from Early Reviewer Rewards Program)
1 - This book does not contain recipes for database administrators.
Although it contains many chapters explaining architecture and features, such as how to deploy ASM, Data Guard, etc. It cannot be used by a DBA to learn how to do day to day administration. If that is your goal, I recommend searching another book, like Oracle Press' Install and Administrate Oracle 12c.
2- It is perfect as a reference, but the text is not boring and anyone willing to know about a new concept will be very satisfied with this book. The appendix contains a complete commands reference in alphabetical order like ORACLE OTN guides (SQL REFERENCE AND PL/SQL REFERENCE), full of examples and text explaining them.
3- The textual part is very creative. In it one can find real classess on each topics. The language is simple and enthusiastic. The examples are simple to follow and well commented and the name of the chapters are amazing. For example, instead of saying "Chapter 12 - Grouping functions", they decided to name it "Chapter 12 - Grouping things together", instead of Subqeueries, "When one query depends on another" and so forth.
In final words, as a DBA, this book is an excellent reference and will allow me to learn new concepts. As a Developer, this book is perfect and gives real classes in SQL and PL/SQL as well as a very important chapter on how to use SQL PLUS properly.
P.S. I don't know if the kindle edition will be helpful since this book is REALLY BIG and heavy so kindle edition may be too small for a good reading.