2 Weeks
- Have knowledge of Oracle SQL Beginner skills
Backup and Recovery: Concepts
- DBA Responsibilities
- Categories of failure
- Flashback technology
- Phases of Instance Recovery
- Complete and Incomplete Recovery
Backup and Recovery: Configuration
- Configuring for Recoverability
- Configuring and Monitoring Fast Recovery Area
- Multiplexing Control files and Redo log files
Performing Database Backups
- Backup solutions
- Oracle Secure Backup
- Backup Terminology
- Types of Backups
- RMAN Backup types
Performing Database Recovery
- Opening a Database
- Keeping a database open
- Data Recovery Advisor
- Loss of Control file, Redo Log files, Data files.
Moving Data
- Moving Data
- Oracle Data pump
- Directory Objects for Data Pump
- Creating Directory Objects
- Performing a Data Pump Import
Database Maintenance
- Database Maintenance
- Terminology
- Automatic Workload Repository (AWR)
- AWR Infrastructure
Managing Performance
- Performance Monitoring
- Performance Planning
- Memory Management
- Automatic Memory Management (AMM)
- Automatic Shared Memory Management (ASMM)
Managing Performance: SQL Tuning
- SQL Tuning
- Oracle Optimizer
- SQL Tuning Advisor
Using Database Resource Manager
- Database Resource Manager overview and concepts
After successful completion of the project, the student will get a certificate from IST to validate their skills.
