Custom cover image
Beginning Oracle Database 12c Administration : From Novice to Professional / by Ignatius Fernandez
Resource type: Ressourcentyp: Buch (Online)Book (Online)Language: English Series: SpringerLink BücherPublisher: [New York, NY] : Apress, 2015Edition: Second EditionDescription: Online-Ressource (XXXII, 384 p. 85 illus, online resource)ISBN:- 9781484201930
- 005.74
- QA76.9.D3
Contents:
Summary: Beginning Oracle Database 12c Administration is your entry point into a successful and satisfying career as an Oracle Database Administrator. The chapters of this book are logically organized into four parts closely tracking the way your database administration career will naturally evolve. Part 1 "Database Concepts" gives necessary background in relational database theory and Oracle Database concepts, Part 2 "Database Implementation" teaches how to implement an Oracle database correctly, Part 3 "Database Support" exposes you to the daily routine of a database administrator, and Part 4 "Database Tuning" introduces the fine art of performance tuning. Beginning Oracle Database 12c Administration provides information that you won't find in other books on Oracle Database. You'll discover not only technical information, but also guidance on work practices that are as vital to your success as are your technical skills. The author's favorite chapter is "The Big Picture and the Ten Deliverables." (It is the editor’s favorite chapter too!) If you take the lessons in that chapter to heart, you can quickly become a much better Oracle database administrator than you ever thought possible. You will grasp the key aspects of theory behind relational database management systems and learn how to: • Install and configure an Oracle database, and ensure that it’s properly licensed; • Execute common management tasks in a Linux environment; • Defend against data loss by implementing sound backup and recovery practices; and • Improve database and query performancePPN: PPN: 1657482820Package identifier: Produktsigel: ZDB-2-CWD
Contents at a Glance; Contents; About the Author; About the Technical Reviewer; Acknowledgments; Foreword to the First Edition; Introduction; Part I: Database Concepts ; Chapter 1: Relational Database Management Systems; A First Look at Oracle Database 12 c ; What Is a Database?; What Is a Relational Database?; The Secret Sauce; Examples of Relational Operations; Efficiency of Relational Operators; Query Optimization; What Is a Database Management System?; Transaction Management ; The Atomicity Property of Transactions; The Consistency Property of Transactions
The Isolation Property of Transactions The Durability Property of Transactions ; Data Integrity ; Data Security ; What Makes a Relational Database Management System Relational?; Summary; Further Reading; Chapter 2: SQL and PL/SQL by Example; Railroad Diagrams ; Types of SQL; Data Definition Language; Database Manipulation Language; The INSERT Statement ; The UPDATE Statement; The DELETE Statement; The MERGE Statement; Embedded SQL; SQL*Plus and SQL Developer ; Criticisms of SQL; Duplicates; Redundancy ; Nullable Data Items ; Introduction to PL/SQL; Summary; Exercises
Further ReadingChapter 3: Oracle Architecture; Database vs. Instance; Database; Software; Configuration Files; Data Files; Temporary Files; Redo Log Files; Archived Redo Log Files; Control File; Event Logs; Database Backups; Instance; System Global Area; Buffer Cache; Shared Pool; Log Buffer; Server Processes; Background Processes; One-to-Many Configuration; Many-to-One Architecture; Life Cycle of a Database Session; Summary; Exercises; Further Reading; Part II: Database Implementation ; Chapter 4: Planning; Licensing; Practical Example
Free to Download, Free to Learn, Unlimited Evaluation Database Editions; Architectural Choices; Dedicated Server; Shared Server; Real Application Clusters; Standby Database; Maximum Availability Architecture (MAA); Sizing; Disk Sizing; Data Files; Control Files and Online Redo Logs; Archived Redo Logs; Backups and Exports; Software Executables and Related Files; Other Disk Considerations; Usable Space; File Placement; Disk Speed; Memory Sizing; CPU Sizing; Network Sizing; Modern Options; Engineered Systems; Oracle Database Appliance; Exadata; Cloud Computing
Platform as a Service (PaaS)Infrastructure as a Service (IaaS); Summary; Further Reading; Chapter 5: Software Installation; Oracle Technology Network; The Forgotten Manuals; Prerequisites and Preinstallation Requirements; Client Installations; Instant Client; SQL Developer ; Server Installations; Oracle Database Examples; Summary; Chapter 6: Database Creation; Creating and Configuring a Listener; Creating and Configuring a Database; Common Options ; Initialization Parameters ; Data Files ; Control Files ; Redo Log Groups ; Basic Database Administration Tasks
Stopping the Database
No physical items for this record