Databases · Beginner → Expert
🟥 Oracle Database Developer and DBA
Learn Oracle SQL and database administration including schema design, PL/SQL, transactions, indexing, security, backup/recovery, performance, architecture, and high availability concepts.
Course roadmap
Pass each module exam to unlock the next module.
Module 1 · Beginner
Oracle Database Architecture, Instances and Storage Concepts
Locked
Module 2 · Beginner
Oracle SQL Query Fundamentals
Locked
Module 3 · Beginner
Joins, Aggregation, Subqueries and Analytic Functions
Locked
Module 4 · Beginner
Schema Objects, Constraints and Data Modeling
Locked
Module 5 · Intermediate
Transactions, Isolation, Undo and Read Consistency
Locked
Module 6 · Intermediate
PL/SQL Blocks, Procedures, Functions and Packages
Locked
Module 7 · Intermediate
Triggers, Sequences and Programmatic Database Objects
Locked
Module 8 · Intermediate
Indexes, Optimizer Statistics and Execution Plans
Locked
Module 9 · Advanced
Users, Roles, Privileges and Database Security
Locked
Module 10 · Advanced
Tablespaces, Datafiles and Storage Administration Concepts
Locked
Module 11 · Advanced
Memory, Processes and Instance Configuration Concepts
Locked
Module 12 · Advanced
Backup and Recovery with RMAN Concepts
Locked
Module 13 · Advanced
Import, Export and Data Pump Concepts
Locked
Module 14 · Expert
Monitoring, Wait Events and Performance Tuning
Locked
Module 15 · Expert
Concurrency, Locking and Troubleshooting
Locked
Module 16 · Expert
Data Guard, RAC and High Availability Concepts
Locked
Module 17 · Expert
Expert Capstone: Operate a Production Oracle Database
Locked
Certification gate
Final course exam
Pass mark: 80%. Time limit: 360 minutes. All module exams must be passed first.
Locked until modules are passed