OCA/OCP Oracle Database 12c All-in-One Exam Guide (Exams 1Z0-061, 1Z0-062, & 1Z0-063)

John Watson (UK) OCP DBA 8.0, 8.i, & 9i, 10g, 11g, Interrnet Application Server Administrator, and certified on Managing Oracle on Unix, is a senior consultant with BLP Management Consultants, and taught for Oracle University in South Africa for four years. John taught the DB10g New Features course, the DB10g Manageability and Performance seminars. He validated hundreds of OCP 10g New Features exam questions and contributed to the course material for all the 10g courses. John is the author of numerous articles on technology. Roopesh Ramklass  is an Oracle Certified Master with expertise in middleware and database architecture. He has worked for Oracle Global Support, Advanced Customer Services, and Oracle University. He is actively involved in the Oracle community, speaking at Oracle conferences, serving as an executive of the Toronto Oracle Users Group, and participating in the Oracle ACE program. Roopesh is the author of several Oracle technology books and blogs and is passionate about serving others through education. Bob Bryla (Plattville, WI) OCP, is an Oracle 8, 8i, 9i, 10g, and 11g Certified Professional with more than 15 years of experience in database design, database application development, training, and Oracle database administration. He is the primary Internet database designer and an Oracle DBA at Lands’ End in Dodgeville, Wisconsin. Bob is the co-author of the Oracle Database 11g DBA Handbook from Oracle Press (McGraw-Hill), and the OCA: Oracle 10g Administration I Study Guide (1Z0-042) and OCP: Oracle 10g Administration II Study Guide: Exam 1Z0-043 from Sybex/Wiley.

Part I: Getting Started
Chapter 1: Installing Oracle Database Software
Chapter 2: Creating an Oracle Database Using DBCA
Chapter 3: Installing Oracle Grid Infrastructure for a Standalone Server
Chapter 4: Using Oracle Restart
Part II: SQL
Chapter 5: DDL and Schema Objects
Chapter 6: DML and Concurrency
Chapter 7: Retrieving, Restricting and Sorting Data Using SQL
Chapter 8: Single Row and Conversion Functions
Chapter 9: Group Functions
Chapter 10: SQL Joins
Chapter 11: Subqueries and Set Operators
Part III: DBA1
Chapter 12: Exploring the Oracle Database Architecture
Chapter 13: Managing the Database Instance
Chapter 14: Oracle Networking
Chapter 15: Oracle Storage
Chapter 16: Oracle Security
Chapter 17: Moving and re-organizing data
Chapter 18: The AWR and the Alert system
Chapter 19: Performance tuning
Chapter 20: The Resource Manager
Chapter 21: The Scheduler
Part IV: DBA2
Chapter 22: Configuring the DB for backup and recovery
Chapter 23: Backup with RMAN
Chapter 24: Restore and Recover with RMAN
Chapter 25: Diagnosing Failures
Chapter 26: Flashback
Chapter 27: Duplicating a Database
Chapter 28: Encrypting, Securing, Monitoring, and Tuning RMAN Backups
Part V: Upgrades and Multitenant
Chapter 29: Upgrading Oracle Database Software
Chapter 30: Upgrading an Oracle database
Chapter 31: Multitenant Container and Pluggable Database Architecture
Chapter 32: Creating and Managing Multitenant Container and Pluggable Databases
Chapter 33: Managing Storage, Security, Availability and Performance in a CDB and PDBs
Glossary