❗The content presented here is sourced directly from Udemy platform. For comprehensive course details, including enrollment information, simply click on the 'Go to class' link on our website.
Updated in [July 18th, 2023]
This Oracle DBA 11g&12c - Database Administration for Junior DBA course provides an opportunity for students to learn the fundamentals of becoming an Oracle Database Administrator (DBA). The course is designed to be completed in 6 weeks and upon completion, students will be well-equipped to pursue a career as a Junior DBA.
The course follows a step-by-step methodology to introduce concepts and demonstrations to students in an easy-to-understand manner. It covers both Oracle Database 11g and Oracle Database 12c, allowing students to gain knowledge of the differences between the two.
The course begins by teaching the fundamentals of database and the Oracle Architecture. It then moves on to cover topics such as process and memory architecture, installation of Oracle Database 11g & 12c, tablespace management, undo tablespace management, redo log file management, user and security management, networking, data dictionary tables/views, diagnosing issues, backup and recovery, materialized views, table partitioning, and a project work.
By the end of the course, students will have a comprehensive understanding of Oracle Database Administration and be well-prepared to pursue a career as a Junior DBA.
Course Syllabus
Introduction
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
Project Work!!!