Paperback: 1192 pages
Publisher: McGraw-Hill Education; 1 edition (February 14, 2014)
Product Dimensions: 7.4 x 2.6 x 8.9 inches
Shipping Weight: 4.3 pounds (View shipping rates and policies)
Average Customer Review: 4.7 out of 5 stars See all reviews (18 customer reviews)
Best Sellers Rank: #114,976 in Books (See Top 100 in Books) #4 in Books > Computers & Technology > Databases & Big Data > Oracle #52 in Books > Computers & Technology > Databases & Big Data > SQL #117 in Books > Textbooks > Computer Science > Database Storage & Design
To put it quite simply, this book is fantastic. Each chapter is rich with content and offers numerous amounts of coding examples that help paint a vivid picture of how you would impliment the code in your own day to day experiences with 12c. What really won me over with this book wasn't the fine detail within the chapters, but what was outside the chapters. More than HALF of this book is made up of Appendices that go into an amazing amount of detail for the code examples in each of the chapters. This is particularly useful in two different ways.The first being that it helps each chapter become much easier to follow and understand, and that the chapter doesn't become bogged down by creating too much attention on one example. Instead, each chapter discusses a concept with detail, and then refers you to the Appendix for further in depth detail. For me personally, this really made it easier for me to read through each chapter and create an understanding on all the material, and then I could reference the Appendix for further detail if needed.The second being that if you struggle with a concept or want to learn more about a particular subject within any of the chapters, you can reference the Appendix and have more than enough material to become extremely knowledgable on the subject matter. One particular thing I really enjoyed from personal experience, Is I had referenced the Appendix for "Security Hardening". I was suprised to find an amazing amount of information, one bit of information in particular teaches you how to use a packet sniffer tool, called wireshark, to detect and find user login credentials as well as how to protect yourself from those who are trying to use this method to gain access to your own credentials!
This will be the third book I have read out of several of Michael's books on Oracle.I get the same feeling from reviewing this book that I get when writing a procedure or package to fill a Technical Requirement and, after spending some time on it, the procedure or package all comes together as neat, clean, efficient and complete.The striking thing about this book, for me, is its precise focus on subject matter. By that I mean that if a section is entitled, "Lexical Units", that's exactly what it's about, with no superfluous information or digressions found there. I, personally and in various technical documents I have written for work, have found that this precise focus is an easy thing to conceive of and aspire to, and a difficult thing to accomplish in a project of any scale. The difficulty comes in trying to strike that balance between being thorough and being focused and concise.The way Michael accomplished this in this book is by "back-loading" the book with massive and great appendixes on the following subjects: 1) Oracle Database Primer, 2) SQL Primer, 3) SQL Built-in Functions, 4) PL/SQL Built-in Packages and Types, 5) Regular Expression Primer, 6) Wrapping PL/SQL Code Primer, 7) PL/SQL Hierarchical Profiler Primer and 8) PL/SQL Reserved Words and Keywords.Putting all of this deep technical knowledge at your fingertips, without having to cloud a given chapter or section with it, when the chapter or section describes a more specific but related topic, gives this book its crisp and clean quality of reading or reference.This book is worth the purchase price for either the "SQL Primer" appendix (almost 200 pages) or the "PL/SQL Built-in Packages and Types" appendix alone.
I have been using this book to tutor students taking a PL/SQL class. I have found the book to be very helpful as the concepts are broken out well and the book correctly compartmentalizes various subject areas. I found the prototypes to be very helpful and made it easy to explain to students the syntax of everything from function and procedures to packages and classes. After listing the prototype at the beginning of a section the book does a great job at explaining in detail each clause of the prototype.I also found it very helpful that the beginning of the book contained a section about all the new features of 12c. In addition, the book elaborates on some new features and how implementation has improved from 12c from previous versions. In some cases when functionality has changed significantly from previous versions of oracle, and the author spends needed detail where possible on how the code would need to be implemented in older installations.Additionally I also found the appendixes to be VERY helpful, as it helps out with some remedial information on SQL in appendix B, as well as information about built-in packages and types that exist in 12c. Appendix H is particularly helpful as it contains an alphabetical list of all the reserved words built in the oracle 12c at initial set up, as well as a function that can query the database for all reserved words currently in the database. This is particularity helpful when you have created objects and there is a reserved word that you think should not be reserved.All in all, I found it to be one of the clearest textbooks I've used and the best book by Micheal McLaughlin that I have read so far. It is clear and concise, yet expands upon topics that need further detail.