1. Introduction
- Understanding DB architectures
- Diagnosing database problems
- Global objectives of the course
- Schedule of the week
- Using SQL new features and tools
- Lessons grouped by modules

2. Using SQL New Features and SQLcl 
- Use SQL row-limiting clause
- Use new 128 bytes identifier length for database objects
- Describe the support for invisible and hidden columns
- Increase length limits of data types
- Use the new VALIDATE_CONVERSION function
- Recall SQL*Plus commands in the same session from history
- Describe the new SQLcl utility 

3. Understanding CDB Basicsl &#65279; 
- Challenges
- Configurations
- CDB root and pluggable database containers
- SYSTEM objects in the USER container
- New Multitenant Architecture: Benefits
- Non-CDB Architecture vs Oracle Multitenant Container Database
- A pristine installation
- Provisioning a pluggable database 

4. Creating CDB and Regular PDBs 
- Tools
- Create a CDB using new clauses
- What's new in CDB after CDB creation
- ADR
- Data dictionary views
- Provisioning new PDBs: overview
- What to do in CDB after CDB creation 

&#65279;5. Creating Application PDBs and Installing Applications
- PDBs and applications
- Application common objects
- Create and manage an application container
- Types of containers
- Patch and upgrade applications
- Regular PDBs vs application PDBs
- Application containers
- Install applications

6. Creating PDBs 
- Cloning regular and application containers PDBs
- Converting regular PDBs to application root or PDBs
- Cross-Platform transportable PDB
- Plugging unplugged regular and application PDBs into CDB
- Plugging unplugged PDBs with encrypted data
- Perform hot cloning and relocation 
- Configure and use locla UNDO mode
- Plugging or cloning a non-CDB into a CDB
 
7.  Managing CDB and PDBs 
- Creating and renaming Services
- Switching Connection
- Opening CDBs and PDBs
- Managing CDB and PDBs
- Mounting a CDB
- Evaluating the impact of parameter value changes
- Changing the different modes and settings of PDBs
- Starting Up a CDB Instance

8. Managing Storage
- Creating Permanent Tablespaces in a CDB
- Objects in Tablespaces
- UNDO Tablespaces
- Tablespaces Created During PDB Creation
- Temporary Tablespaces
- Defining Default Permanent Tablespaces
 
9. Managing Security 
- Enabling Common Users to Access Data in PDBs
- Encrypting data in PDBs 
- Creating common users, roles and profiles in CDB and PDBs
- Protecting data with Database Vault policies in CDB and PDBs
- Common objects in Application PDBs and operations on Data-Linked objects
- Granting privileges commonly in CDB and PDBs
- Auditing users in CDB and PDBs
- Managing PDB lockdown profiles
 
10. Backing up, Recoverying and Flashing  
- Instance failure and instance recovery
- CDB and PDB backups
- PDB point-in-time recovery
- New syntax and clauses in RMAN
- PDB tempfile, essential and non-SYSTEM tablespaces recovery
- CDB and PDB flashback
- Duplicating PDBs
- Using RMAN backup to plug an unplugged PDB

11. Back Managing Performance 
- Monitoring PDB memory usage
- AWR report
- Managing SGA and PGA for PDBs
- Controlling the Degree of Parallelism of Queries 
- PDB-Level snapshot views
- AWR and ADDM behaviour at CDB and PDB levels
- Sizing the CDB
- Tuning a CDB
 
12. Managing Resources Allocation
&#65279;- Controlling PDB IO rate limit 
- Managing resources within a PDB
- CDB Resource plan basics: Limits + cpu_count init parm per PDB
- Creating and setting PDB performance profiles
- Allocating resources in the CDB and PDBs
- Managing resources between PDBs
 
13. Moving and Migrating Data 
- Transporting a database over the network
- Exporting non-CDB data and importing non-CDB data into PDB
- Using SQL*Loader with PDBs
- Exporting and importing between PDBs
- Exporting from PDB and importing into a non-CDB
- Full Transportable export/import
- Using Oracle Data Pump with PDBs
 
14. Performing Miscellaneous Operations
- Using catcon.pl utility to install/remove options from CDB/PDB
- Jobs coordinator and resources
- Creating a standby of a CDB
- Using Xstreams with a CDB and PDB
- Mining statements of a PDB using LogMiner
- Scheduling operations in a PDB
 
15. Understanding Database Sharding
- Benefits of Sharding
- Advantages of Oracle Sharding over NoSQL
- Creating Sharded Tables
- Sharded Table Family
- What Is Database Sharding?
- Application Considerations for Sharding
- Components of Database Sharding
- Complete Deployment of a System-Managed SDB
 
16. Diagnosing Database Problems
- TFA Collector utility
- Tracing Data Pump
- New ADRCI Command
- Automatic Diagnostic Repository
- MVs refreshed statistics history
- Trace File Analyzer (TFA) Collector process and repository
- ADR Retention
- Network Performance
