OCP Upgrade 1Z0-060 Exam guide

Key Features

• This is your one-stop solution to understanding what’s new in Oracle 12c and how to bring these features to your systems in a hassle-free manner
• A complete guide to clearing the OCP Upgrade 1Z0-060 Exam
• Dive deep into Oracle administration and get up to date

Book Description

This guide will get Oracle admins up to date with the latest developments in Oracle 12c. It includes all the necessary information that you need to implement in your existing systems.

All of the information in this book has been handpicked to help you study for the Oracle 12c upgrade exam. Each chapter has been written with the objective of helping you pass this exam with ease. Content in this book is aligned with the objectives of the exam, making it really easy to follow the course content. Every example mentioned in this book has been tried and tested in actual environment. Real-world examples will help you learn about new features such as multitenant containers database architecture, managing containers, pluggable databases, database administration enhancements, database auditing, tuning, backup, and flashback enhancements.

You will also learn about storage enhancements, security updates, tuning, troubleshooting, and backup enhancements. This book also covers section 2 of the exam course making this book a complete guide for passing OCP 12c upgrade exam 1Z0-060.

What you will learn

• All of the new features of the Oracle 12c database that you are required to know for the OCP Upgrade Exam 1Z0-060
• New multitenant architecture introduced in Oracle 12c and how it works
• Monitor complex database operations and use the new enhanced SQL tuning features to tune bad SQLs
• Manage data over time using information life cycle management
• Make your data more secure by implementing new enhanced auditing
• Learn new security features and how to implement encryption to secure your data
• Explore how backup and flashback works with new multitenant architecture
• Performance management techniques that will analyze and tune your database

About the Author

Advait Deo has 12 years of experience in the database domain starting from Oracle Version 9i until Oracle 12c. By nature, a mechanical engineer, Advait transformed his career around Software and databases right from the beginning. He joined a consultancy company Tata Consultancy Services and 2004 and learned about database technology. In 2006, he moved to Oracle India Pvt. Ltd. where he was mentored by Indira Karnati. He later moved to Amazon.com as database administrator in 2010. He is currently working at Amazon as a senior database engineer.

Advait has worked in various aspects of Oracle databases and administered huge fleet of complex production databases. He is an expert in performance tuning and troubleshooting. He also focuses on schema design, automation using shell and Python, and architecting solutions to complex problems.

Currently, he is working on various products in Amazon Web Services (AWS) technology and providing database and storage solutions in AWS to various clients.

Advait is an Oracle Certified Professional in Oracle 9i, 10g, 11g, and 12c databases and Oracle Certified Expert in 11g RAC. His certification credentials are available at https://www.youracclaim.com/users/advait-deo. He also publishes some of his work and learnings on his website http://avdeo.com.

You can find him on LinkedIn at https://www.linkedin.com/in/advaitdeo

Prior to writing this book, Advait reviewed Oracle Database 11g R2 Performance Tuning Cookbook and Learning Linux Shell Scripting.

Indira Karnati is an engineering graduate in electronics and communications and did her Executive General Management Program at IIM Bangalore, India.

Indira is an expert Oracle DBA and Apps DBA, having worked in various capacities for the past 19 years in IT, of which 15 years has been with Oracle Corporation, India Development Centre, Hyderabad. She has extensive hands on experience of installations, configurations of Oracle databases (single instance and RAC), Oracle Identity Management (OID/OAM/OIM), Fusion Middleware products, Oracle EBS, Oracle Fusion applications, Oracle Demantra, and Oracle iLearning.

Indira has rich experience in turning around the complex Oracle installations. Her expertise includes installation, configuration, cloning, refreshing, patching, upgrading, debugging many Oracle Products, the primary being Oracle Database, identity management, and enterprise manager. Her work experience covers high availability and disaster recovery solutions.

She is an Oracle Certified Professional in 12c and 11g in the Database Administration track, Oracle Certified Expert in 11g RAC, and Exadata Ceritified Implementation Specialist. Her Certification credentials are available at https://www.youracclaim.com/users/indira-karnati

Find her on LinkedIn at https://www.linkedin.com/in/indirakaranati

Table of Contents

Chapter 1. Getting Started with Oracle 12c
Chapter 2. Multitenant Container Database Architecture
Chapter 3. Managing CDBs and PDBs
Chapter 4. Information Lifecycle Management and Storage Enhancements
Chapter 5. Auditing, Privilege Analysis and Data Redaction
Chapter 6. Database Tuning and Troubleshooting
Chapter 7. Backup and Flashback Enhancements
Chapter 8. Database Administration Enhancements
Chapter 9. Miscellaneous New Features
Chapter 10. Core Administration
Chapter 11. Performance Management