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 StartedChapter 1: Installing Oracle Database SoftwareChapter 2: Creating an Oracle Database Using DBCAChapter 3: Installing Oracle Grid Infrastructure for a Standalone ServerChapter 4: Using Oracle RestartPart II: SQLChapter 5: DDL and Schema ObjectsChapter 6: DML and ConcurrencyChapter 7: Retrieving, Restricting and Sorting Data Using SQLChapter 8: Single Row and Conversion FunctionsChapter 9: Group FunctionsChapter 10: SQL JoinsChapter 11: Subqueries and Set OperatorsPart III: DBA1Chapter 12: Exploring the Oracle Database ArchitectureChapter 13: Managing the Database InstanceChapter 14: Oracle NetworkingChapter 15: Oracle StorageChapter 16: Oracle SecurityChapter 17: Moving and re-organizing dataChapter 18: The AWR and the Alert systemChapter 19: Performance tuningChapter 20: The Resource ManagerChapter 21: The SchedulerPart IV: DBA2Chapter 22: Configuring the DB for backup and recoveryChapter 23: Backup with RMANChapter 24: Restore and Recover with RMANChapter 25: Diagnosing FailuresChapter 26: FlashbackChapter 27: Duplicating a DatabaseChapter 28: Encrypting, Securing, Monitoring, and Tuning RMAN BackupsPart V: Upgrades and MultitenantChapter 29: Upgrading Oracle Database SoftwareChapter 30: Upgrading an Oracle databaseChapter 31: Multitenant Container and Pluggable Database ArchitectureChapter 32: Creating and Managing Multitenant Container and Pluggable DatabasesChapter 33: Managing Storage, Security, Availability and Performance in a CDB and PDBsGlossary