on 24 February 2014
Another quality book from Oracle Press; if you’re new into Oracle databases then this book has everything you need to get started. All the topics are well organised and structured. Really good introduction into database design which I was surprised to see. As well as the basic database fundamentals it covers more advanced topics such as virtual private databases, materialized views, plsql to mention a few. There were some 12c features notably the pluggable database but did feel it was an expansion of the 11g book with little bits of 12c nuggets.
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.
on 20 March 2014
First off this is a big book nearly 1500 pages covering all aspects of the Oracle database. The book is split into 8 parts, starting sensibly with an introduction to database concepts and then we are into part 2 - SQL and SQL*Plus an indepth look at SQL in the 12c database. Part 3 was titled beyond the basics, although I wouldn't have put all the the subjects (SQL Loader, accessing remote data for example) in this section as I consider them to be amongst the basics too but the other areas such as VPD, TDE adn Oracle Text are an advanced topic which we explained well in this section.
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.