Oracle Database Administration: Advanced Fundamentals of SQL training helps you to create materialized views to replicate data across servers, improve performance by using simple SQL syntax, use Analytic SQL to aggregate, analyze, report, and model data using the SQL Analytic capabilities.
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.
What to learn next?
