Oracle Database 12c: Install, Configure & Maintain Like a Professional (Anglais) Broché – 14 octobre 2013
|Neuf à partir de||Occasion à partir de|
Produits fréquemment achetés ensemble
Les clients ayant acheté cet article ont également acheté
Descriptions du produit
Présentation de l'éditeur
Master the Fundamentals of Oracle Database 12c
Filled with easy-to-follow tutorials, this Oracle Press guide provides detailed coverage of core database concepts, the role of the administrator, and enterprise database capabilities. Oracle Database 12c: Install,Configure & Maintain Like a Professional walks you through database configuration, administration, programming, backup and recovery, and high availability. You'll get in-depth introductions to SQL and PL/SQL as well as important information on managing large databases and using Oracle's engineered systems. This essential beginner's resource features:
- Critical Skills--Lists of specific skills covered in each chapter
- Projects--Practical exercises that show how to apply the critical skills learned in each chapter
- Progress Checks--Quick self-assessment sections to check your progress
- Ask the Expert--Q&A sections filled with helpful tips
- Notes--Extra information related to the topic being covered
- Mastery Checks--Chapter-ending quizzes to test your knowledge
Biographie de l'auteur
Ian Abramson (@iabramson) lives in Toronto, Canada, where he works for EPAM Systems as the Canadian Director of Enterprise Data, a global leader in softwareengineering. Ian is a graduate in Mathematics from Concordia University in Montreal. His involvement with implementing solutions using Oracle technology and data warehouses reaches back over 25 years, as a developer of creative and innovative solutions for clients around the globe. He is the past president of the IOUG (Independent Oracle Users Group) and continues to share his knowledge through his lively presentations and published technical articles and blog. In his spare time, Ian spends his freetime golfing in the summer and playing hockey in the winter.
Michael S. Abbey (@MichaelAbbeyCAN) has done nothing but Oracle since V3 in 1986. He has been a frequent presenter at tech shows on four continents since the early 1990s and started writing for Oracle Press in 1994. He is a well-known tech in the Oracle space and has a voracious appetite for the CORE Oracle technology. Michael has been actively involved in the user group programs for over two decades and is an Oracle ACE.Michelle Malcher (@malcherm) is the current president of the Independent Oracle Users Group (IOUG). She is an Oracle ACE Director with more than 15 years' experience in database development, security, design, and administration. Michelle is based in Chicago, USA, where she leads a team of database developers and administrators. She has contributed articles to the IOUG Select Journal, has written the Oracle Database Administration for Microsoft SQL Server DBAs,and has contributed to other Oracle Press books. She enjoyspresenting and sharing ideas about Oracle database topics at conferences and user group meetings.
Michael Corey (@Michael_Corey) is Founder and Chief Executive Officer of Ntirety. Michael is a frequent speaker at technology and business conferences throughout the world, from Australia to Brazil. Michael is a VMware vExpert and Oracle ACE, and is on the Talkin’ Cloud 200 Computing Executives and Experts List.Michael is a past president of the Independent Oracle UsersGroup; he helped found the Professional Association of SQLServer, is a current board member of the IOUG Virtualization SIG, and is actively involved in numerous professional associations and industry user groups.
Michael is the original Oracle Press author and a frequent blogger for Database Trends and Applications, and has written numerous articles and books.
Aucun appareil Kindle n'est requis. Téléchargez l'une des applis Kindle gratuites et commencez à lire les livres Kindle sur votre smartphone, tablette ou ordinateur.
Pour obtenir l'appli gratuite, saisissez votre adresse e-mail ou numéro de téléphone mobile.
Détails sur le produit
En savoir plus sur les auteursDécouvrez des livres, informez-vous sur les écrivains, lisez des blogs d'auteurs et bien plus encore.
Dans ce livre(En savoir plus)
Quels sont les autres articles que les clients achètent après avoir regardé cet article?
Commentaires en ligne
Commentaires client les plus utiles sur Amazon.com (beta)
In the dedication, one of the authors remarks that "the process of writing a book is long and arduous"; and I imagine it must be, with so many authors.
It doesn't take very long for the plan to unravel.
The section on storage tells us that powers of two are used for counting storage, stressing that disk sizes are always powers of two with a table and a "Mastery Check" quiz question at the end of the chapter: "Why are storage factors in the computer industry expressed as a factor of 2 and not the more common 10"? Of course, these aren't factors of two and ten; they're powers of two and ten. And what disk drive vendor uses powers of two? They all use powers of ten; a 250 gigabyte drive really has 250,000,000,000 bytes of storage, which is only 232 gibibytes.
For some reason, the first chapter introduces some data types. Gems like "VARCHAR: Same as VARCHAR2, although its use is not recommended" can't be classified as explanations. Between the discussion of character data types and numeric data types appears a note telling us that "all user-defined names used for just about anything in the Oracle database are limited to no more than 30 characters". I doubt it's clear to the neophyte reader that the limit being expressed is about identifiers, not the limits in storable data -- but the position of this sidebar makes its scope confusing to the reader. I believe this poor organization is a symptom of the communal approach to writing a book, and the symptoms are acute throughout the volume.
A superficial discussion of Oracle's shared memory setup is punctuated by the assertion that "it would be impossible to get into the details of each of these components", an un-qualified assertion that's profoundly disappointing for a book that purports to teach me "professional"-level management of the system in question. Is the information in question truly un-knowable?
Most descriptions of any advanced topics are like that memory management section in Chapter 1; two options are described, one is identified as the default, and no description of the tradeoffs of the two are offered. Others are like the discussion of pluggable database -- they're identified as, well, pluggable, but there's absolutely no advice given about their practical or appropriate application. Superficial descriptions aren't a path to professional-level understanding.
Readers leave Chapter 1 without a sound understanding of the difference between processes and files; memory and data; databases and instances. While the authors stab at the content, they never make a killing stroke.
The installing chapter provides a walk through of the GUI-based Oracle installer. As is consistent for the title, it provides no description of the detailed options or how they might be appropriate. There's no discussion of managing storage, splitting drives or volumes appropriate, or planning for growth. Notably lacking are any troubleshooting steps or security guidelines, of paramount importance to the "professional" DBA.
Inexplicably, the book provides chapters on SQL and PL/SQL programming; topics worthy of their own books, and covered with more depth, clarity, and accuracy in almost any such title.
Chapter 5 contains a section titled "understand the Oracle Database 12c Architecture", which a reader might find redundant to the "learn the Oracle Database 1c Architecture" in Chapter 1. This time, "architecture" means -- well, it doesn't mean architecture; it just means the hierarchy of objects within a database. Somehow, the authors think it's accurate to use "programs" to describe triggers an procedures. There's some coverage given to security; particularly the creation of users and the granting of privileges. Unfortunately, it's too thin to be more than an introduction.
In Chapter 6, database backups are examined. I expected deep coverage of the RMAN backup tool and its plethora of options, but the coverage was so thin that I don't think a reader would be competent to perform a backup of their own system had it a non-default installation. Little heed is given to the practice of backup management itself, and disaster recovery planning (certainly something I'd expect from a "professional") is ignored.
Nowhere is the thin coverage in this book more inadequate than Chapter 7, where high-availability features are investigated. There's little context given to the subjects, and simple overviews of canned scenarios are presented with no elaboration, leaving the user to struggle with planning all on their own.
Partitioning and compression are examined in Chapter 8 as approaches for the physical management of larger data. Queries over large data are investigated in this same chapter with brief coverage of rollups, models, and cubes. "Coverage" is a generous term, as each section provides a single sample query and its output with little explanation of how the particular technique works or when it is recommended.
I found Chapter 9 particularly puzzling. The chapter covers the management and use of Oracle's database appliance and Exadata line of systems. These products are quite expensive, and the notion that the rank beginner that is apparently the authors' target reader would find themselves with access and responsibility for such systems seems -- well, inappropriate.
This book's minimal coverage of the claimed topic necessitates an amount of perceived errors because the half-baked explanations are are sometimes difficult to identify as the whole truth. The technical errors and inconsistent editing, coupled with confusing diagrams add up to a volume that I just can't recommend.
Level: Beginner to Intermediate Oracle DBA
Pros: Easy to read, covers a great area of subjects, from installation on Linux, not onli database but also RAC , tools like SQL Plus, SQL Developer, Entrepreise manager, but also to developing in PL/SQL.
Cons: Some experienced DBA can find a lot of already known subjects. Title is a little bit misleading, I would say is a first step to a professional.
Being a very generalistic , the book offered very interesting subjects for me like RAC , new features in 12C, Exadata architecture.
I would recommend it for approaching Oracle Database.