1. Oracle Architechture Part (1)
· Basic Overview about oracle db & architect and different versions
2. Oracle Architechture Part (2)
· Server Architechture
· Physical Architecture
· Memory Architechture & management
· Background Process
· Multitenant Architecture
3. Oracle DB installation
· Download and install Oracle Linux VM
· Software installation
4. Create database
· via DBCA
· via a manual process
· IniT file
· Create PDB (12c onward)
· Clone PDB
· Unplug and plug PDB
· Drop PDB
· Accessing DB
5. Manage database
· Starting instance
· Shutting instance
· Diagnostic repository
· Data Dictionary
· Datafile & tablespace
· Undo & temp tablespace
6. Oracle Network services
· Listener overview & creation
· start & stop
· status check
7. Users
· Creates Users
· Roles & Privileges
· Revoke Privileges, drop user & role
· Authentication
· Resource Management
Oracle DBA Training
8. Backup & Recovery
· Overview of backup and restore
· Types of Backup & scripts
· Backup in detail ie full
· schedule a backup
· view backups
· Rman in detail with configuration
· Recovery in different scenarios
· data corruption
9. Security
· OS and DB security
· Security Options
· Audit Overview
· Audit types in details
· Enable & disable audit
10. Patch
· Overview of patch
· download and installation
· Opatch utility
· Preparation steps
· Apply patch
11. Performance & Monitoring
· Purpose and Overview
· Tuning on instance and SQL
· Repository report and analysis
· Different Approches
· Source of tuning information
· Optimizer
12. Upgrade overview
· Step by step process
13. In hand challenges