US flag signifying that this is a United States Federal Government website  Official website of the Department of Homeland Security

Due to the lapse in federal funding, this website will not be actively managed. More info.

Oracle Database 12c: Managing CDB and PDB, and Data Optimization

  • Online, Self-Paced

Oracle Database 12c: Managing CDB and PDB, and Data Optimization

  • Online, Self-Paced

Course Description

Oracle database contains the Oracle Multitenant feature, which enables Oracle database to contain a portable set of schemas, objects, and related structures that appear logically to an application as a separate database, called a Container Database or CDB. CDB contains pluggable databases or PDBs. Database administrators need to understand how to manage this new option. This course will demonstrate how to connect to, start and shut these databases down, as well has how to manage their tablespaces and users. It will also demonstrate how to backup and recover them for different media failure situations. This course is one in a series in the SkillSoft learning path that covers the objectives for the 1Z0-060: Upgrade to Oracle Database 12c certification exam.

Learning Objectives

CDB and PDB Tablespaces, Users, and Recovery

  • identify how to connect to, start up, and shut down a CDB
  • identify how to create and manage permanent and temporary tablespaces in a CDB instance and PDBs
  • identify how to create and manage common and local users in a CDB instance and PDBs
  • identify how to manage privileges and roles in CDB and PDB
  • identify how to perform CDB and PDB backups
  • perform recovery of CDB in a given scenario
  • recover PDBs in a given scenario
  • identify how to manage CDBs and PDBs in a given scenario

Framework Connections

  • Icon that says Operate and maintain with a hammer & wrench in x shape depicted.
  • Icon that says Securely Provision with a padlock depicted.

The materials within this course focus on the Knowledge Skills and Abilities (KSAs) identified within the Specialty Areas listed below. Click to view Specialty Area details within the interactive National Cybersecurity Workforce Framework.

Feedback

If you would like to provide feedback for this course, please e-mail the NICCS SO at NICCS@hq.dhs.gov.