Become an Oracle DBA (Database Administrator) Curriculum

Section 1: Exploring the Oracle Database Architecture
Explain the Memory Structures
Describe the Process Structures 
Overview of Storage Structures
Section 2: Preparing the Database Environment
Identify the tools for Administering an Oracle Database
Plan an Oracle Database installation 
Install the Oracle software by using Oracle Universal Installer (OUI)
Section 3: Creating an Oracle Database
Create a database by using the Database Configuration Assistant (DBCA)
Section 4: Managing the Oracle Instance
Setting database initialization parameters
Describe the stages of database startup and shutdown
Using alert log and trace files
Using data dictionary and dynamic performance views
Section 5: Configuring the Oracle Network Environment
Configure and Manage the Oracle Network
Using the Oracle Shared Server architecture
Section 6: Managing Database Storage Structures
Overview of table space and data files
Create and manage table spaces
Space management in table spaces
Section 7: Administering User Security
Create and manage database user accounts
Grant and revoke privileges
Create and manage roles
Create and manage profiles
Section 8: Managing Undo Data
Overview of Undo
Transactions and undo data
Managing undo
Section 9: Implementing Oracle Database Security
Database Security and Principle of Least Privilege
Work with Standard Database Auditing
Section 10: Database Maintenance
Use and manage optimizer statistics
Use and manage Automatic Workload Repository (AWR)
Use advisory framework
Manage Alerts and Thresholds
Section 11: Performance Management
Use Automatic Memory Management
Use Memory Advisors
Troubleshoot invalid and unusable objects
Section 11: Backup and Recovery Concepts
Identify the types of failure that can occur in an Oracle database
Describe ways to tune instance recovery 
Identify the importance of checkpoints, redo log files, and archived log files 
Overview of flash recovery area 
Configure ARCHIVELOG mode
Section 12: Performing Database Backups
Create consistent database backups
Back up your database without shutting it down 
Create incremental backups 
Automate database backups 
Manage backups, view backup reports and monitor the flash recovery area
Section 13: Performing Database Recovery
Overview of Data Recovery Advisor
Use Data Recovery Advisor to Perform recovery (Control file, Redo log file and Data file)
Section 14: Moving Data
Describe and use methods to move data (Directory objects, SQL*Loader, External Tables)
Explain the general architecture of Oracle Data Pump 
Use Data Pump Export and Import to move data between Oracle databases
Section 15: Configuring for Recoverability
Configure multiple archive log file destinations to increase availability
Define, apply and use a retention policy 
Configure the Flash Recovery Area 
Use Flash Recovery Area
Section 16: Using the RMAN Recovery Catalog
Identify situations that require RMAN recovery catalog
Create and configure a recovery catalog 
Synchronize the recovery catalog  
Create and Use RMAN stored scripts 
Back up the recovery catalog 
Create and use a virtual private catalog
Section 17: Configuring Backup Specifications
Configure backup settings
Allocate channels to use in backing up  
Configure backup optimization 
Section 18: Using RMAN to Create Backups
Create image file backups
Create a whole database backup  
Enable fast incremental backup  
Create duplex backup and back up backup sets 
Create an archival backup for long-term retention  
Create a multisection, compressed and encrypted backup  
Report on and maintain backups 
Section 19: Using RMAN to Perform Recovery
Perform complete recovery from a critical or noncritical data file loss using RMAN
Perform incomplete recovery using RMAN  
Recover using incrementally updated backups  
Switch to image copies for fast recovery 
  • $799.00
  • 40 Days
  • Course Certificate