Description
In this course, you will learn :
- As an Oracle Database Administrator, you will understand the Database Architecture, which will assist you in performing your DBA duties more effectively.
- You would be able to install the necessary Oracle Software/Database as an Oracle Database Administrator (Oracle DBA).
- You would be able to administer user accounts in the database as an Oracle Database Administrator (Oracle DBA).
- You would be able to Manage Tablespaces as an Oracle Database Administrator (Oracle DBA) to provide the necessary space for the data.
- You would be able to perform Backup and Recovery as an Oracle Database Administrator (Oracle DBA) as needed.
- As an Oracle Database Administrator (Oracle DBA), you will be able to diagnose problems and, if necessary, work with Oracle Support.
Syllabus :
- Oracle Process Architecture
- Oracle Memory Architecture
- Architecture Recap
- Software Installation
- Tablespace Management
- UNDO Management
- REDO Management
- User Management
- Oracle Networking
- Data Dictionary
- Diagnostic Data
- Backup and Recovery (User Managed)
- Backup and Recovery (RMAN Backup)
- Database Objects - Materialized Views
- Table Partitioning