The course covers the multitenant architecture and the different types of pluggable databases (PDBs) in multitenant container databases (CDBs). After you understand the concept of regular and PDBs, you will create a CDB and then use different methods to create PDBs. It will cover other methods of PDB creation. You will learn how to start and shut down a CDB and how to open and close a PDB. It will examine security aspects in CDBs and PDBs in various areas like privileges and roles, lockdown profiles, auditing, Database Vault, and encryption. It will also examine availability through backup, duplicate, recovery, and flashback topics and then performance, monitoring, and resources allocation management in CDBs and PDBs. Finally, it will teach you how you can move data from a non-CDB environment to a PDB. You will also learn how to move data between PDBs by using utilities such as the export and import features of Oracle Data Pump, SQL*Loader, external tables, and Oracle Recovery Manager.
Required: Basic computer skills, internet access, basic analytic or programming skills.
2 Days/Lecture & Lab
- Multitenant Architecture
- PDB Creation
- Data Movement