Oracle Database 19c Bootcamp
Oracle Database 19c Bootcamp is a hands-on bootcamp training course.
Description
Oracle Database 19c Bootcamp is a hands-on bootcamp training course.
Outline
5 modules
•
15 Days total
- Oracle Database Architecture Overview
- Oracle Database Instance Configurations
- Oracle Database Memory Structures
- Process Structures
- Database Storage Architecture
- Logical and Physical Database Structures
- Configuring the Oracle Network
- Administering User Security
- Creating and Managing Tablespaces
- Managing Storage Space
- Managing UNDO Data
- Moving Data
- Understanding container database (CDB)
- Understanding pluggable databases (PDBs)
- Differences between non-CDB and CDB architectures
- Installation of Oracle Database 19c with multitenant option
- Configuration of a multitenant environment
- Creating a CDB
- User security in CDB and PDBs
- Managing roles and privileges
- Oracle Resource Manager within a multitenant database environment.
- Configuring for Recoverability
- Using the RMAN Recovery Catalog
- Backup Strategies and Terminology
- Performing Backups
- Critical VS Non Critical files
- Control file Trace
- Using RMAN-Encrypted Backups
- Backup and recovery best practices
- Performance tuning best practices
- Backup CDB VS PDB
- Performing Recovery
- Using Flashback Technologies
- Duplicate database
- Basic Tuning Diagnostics
- Using Automatic Workload Repository
- Monitoring Applications
- Identifying Problem SQL Statements
- Influencing the Optimizer
- Reducing the Cost of SQL Operations
- Tuning PGA and Temporary Space
- Automatic Memory
- Introduction to Oracle Data Guard
- Networking for Oracle Data Guard
- Creating a Physical Standby Database by Using SQL and RMAN Commands
- Oracle Data Guard Broker: Overview
- Creating a Data Guard Broker Configuration
- Using Oracle Active Data Guard
- Configuring Data Protection Modes
- Performing Role Transitions