Free Downloads
Oracle Database 12c The Complete Reference (Oracle Press)

Master the Cutting-Edge Features of Oracle Database 12c Maintain a scalable, highly available enterprise platform and reduce complexity by leveraging the powerful new tools and cloud enhancements of Oracle Database 12c. This authoritative Oracle Press guide offers complete coverage of installation, configuration, tuning, and administration. Find out how to build and populate Oracle databases, perform effective queries, design applications, and secure your enterprise data. Oracle Database 12c: The Complete Reference also contains a comprehensive appendix covering commands, keywords, features, and functions. Set up Oracle Database 12c or upgrade from an earlier version Design Oracle databases and plan for application implementation Construct SQL and SQL*Plus statements and execute powerful queries Secure data with roles, privileges, virtualization, and encryption Move data with SQL*Loader and Oracle Data Pump Restore databases using flashback and the Oracle Database Automatic Undo Management feature Build and deploy PL/SQL triggers, procedures, and packages Work with Oracle pluggable and container databases Develop database applications using Java, JDBC, and XML Optimize performance with Oracle Real Application Clusters

Series: Oracle Press

Hardcover: 1472 pages

Publisher: McGraw-Hill Education; 1 edition (October 2, 2013)

Language: English

ISBN-10: 0071801758

ISBN-13: 978-0071801751

Product Dimensions: 7.5 x 2.2 x 9.3 inches

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

Average Customer Review: 4.2 out of 5 stars  See all reviews (16 customer reviews)

Best Sellers Rank: #238,849 in Books (See Top 100 in Books) #38 in Books > Computers & Technology > Databases & Big Data > Oracle #53 in Books > Computers & Technology > Software > Databases #57 in Books > Computers & Technology > Databases & Big Data > Data Warehousing

This book is written in very simple, precise, straight forward and easy to understand language. There are tons of day to day usage SQLs and examples for everyday dba. Good amount of details in advanced topics like external tables, flashback, SQL replay, advanced security etc., Very useful Hitchhiker's guides and also a cd with code and ebook included. Over all the content is nicely presented.

This book is very good. I bought the hardcover volume and I am very glad with it. However, I am a little bit surprise with its content and need to explain: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.cheers

In my opinion this book is missing details about Oracle 12c's Pluggable Database architecture. I expected specific content about both EM Express and Single/Multitenant configurations due to the subtitle of the book "Administer and Secure a Robust Cloud Based Environment". Although the old database architecture is still available for use, Oracle recommends new 12c databases utilize the single or multitenant pluggable database configuration. There are some screenshots of a CDB/PDB installation, (6 pages on Pluggable Databases in total) but other than that there are very few pages which detail administration tasks and specific architecture information within a "Cloud database" single tenant/ multitenant configuration in 12c. On the other hand, the book does holds good content as a quick reference guide and overview on many different aspects of Oracle databases. Perhaps for new DBAs, this book would be a welcome asset for those who like a quick dictionary type look up of any and all things Oracle on their bookshelf. However, for a more seasoned DBA it doesn't contain the depth I expected strictly based on the titile and subtitile.

I just finished reading through "Oracle Database 12c - The Complete Reference". If you have been using Oracle for a while you are familiar with the title - Kevin and Bob have been publishing revised versions of the book for quite a while. And as the title says, this is not a tutorial or a how-to book. It is a reference book of many of the important topics that an Oracle professional will need to know in order to work effectively with 12cThe chapters cover the material you would think they would cover. Including the new CDB and PDB concepts in 12c. Also important newer - but not new - topics like VPD, TDE, SQL Replay. I was happy to find sections on Tuning but saw little on Data Guard and RMAN. As a DBA, I am not that interested in topics such as XML, Object-SQL, and Java. I would like to see the RAC section be larger. But overall, it is a very important addition to the library of EVERY Oracle professional. Keep the book at home, but keep the electronic copy of the book (on an include CD) with you everywhere.

Overall a solid book. Kevin has done a great job keep up with the changes between versions and has solid references through out the book. If you want clean oracle documentation this is the place... docs.oracle.com is not bad either, but the docs are 10x more voluminous - perhaps Larry would give the docs.oracle.com the exaDocs.oracle.com :).

This is the offline copy of the Oracle Database 12C. If per chance you do not have internet but you still would like to learn about Oracle 12C SQL, you can use this to your advantage. If however you want to use the Free Online Version, Here's the link to the Oracle 12C Documentation. [...]

The book itself is okay, but it is difficult to get around in. Maybe it's just a function of the Kindle system. My preference would be to be able to go (easily) to the index and click to the desired location.

Oracle Database 12c The Complete Reference (Oracle Press) Oracle Database 12c DBA Handbook (Oracle Press) OCA Oracle Database 12c SQL Fundamentals I Exam Guide (Exam 1Z0-061) (Oracle Press) Oracle Database 12c Install, Configure & Maintain Like a Professional (Oracle Press) Oracle Database 12c Oracle RMAN Backup and Recovery Oracle ASM 12c Pocket Reference Guide: Database Cloud Storage Oracle Essbase & Oracle OLAP: The Guide to Oracle's Multidimensional Solution (Oracle Press) OCA/OCP Oracle Database 12c All-in-One Exam Guide (Exams 1Z0-061, 1Z0-062, & 1Z0-063) Oracle Database 12c For Beginners Oracle Database 12c PL/SQL Programming 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 11g SQL (Oracle Press) Oracle Database 11g New Features (Oracle Press) Oracle Database Ajax & PHP Web Application Development (Oracle Press) Beginning Oracle Database 11g Administration: From Novice to Professional (Expert's Voice in Oracle) Oracle Database Cloud Cookbook with Oracle Enterprise Manager 13c Cloud Control Oracle Performance Survival Guide: A Systematic Approach to Database Optimization (Prentice Hall Professional Oracle Series) Oracle WebLogic Server 12c: Distinctive Recipes: Architecture, Development and Administration Effective Oracle by Design (Osborne ORACLE Press Series)