Oracle DBA 21c: Design, Manage & Secure Databases

This course is part of Oracle DBA 21c: Master Database Administration Specialization

Instructor: EDUCBA

Access provided by Dlocal Payments

5 modules

Gain insight into a topic and learn the fundamentals.

2 weeks to complete

at 10 hours a week

Flexible schedule

Learn at your own pace

5 modules

Gain insight into a topic and learn the fundamentals.

2 weeks to complete

at 10 hours a week

Flexible schedule

Learn at your own pace

What you'll learn

Define Oracle 21c architecture and configure database instances.
Manage tablespaces, undo data, indexes, and user security.
Apply blockchain tables, auto indexing, and flashback features.

Details to know

Shareable certificate

Add to your LinkedIn profile

Assessments

19 assignments

Taught in English

See how employees at top companies are mastering in-demand skills

Learn more about Coursera for Business

logos of Petrobras, TATA, Danone, Capgemini, P&G and L'Oreal

Build your subject-matter expertise

This course is part of the Oracle DBA 21c: Master Database Administration Specialization

When you enroll in this course, you'll also be enrolled in this Specialization.

Learn new concepts from industry experts
Gain a foundational understanding of a subject or tool
Develop job-relevant skills with hands-on projects
Earn a shareable career certificate

There are 5 modules in this course

Learners will define Oracle database architecture, apply SQL commands to manage data, configure storage structures, implement security policies, and evaluate Oracle 21c innovations. By completing this Oracle DBA 21c course, they will gain hands-on expertise in managing instances, creating databases, monitoring performance, and securing enterprise environments.

This comprehensive program begins with foundational Oracle Database concepts, progresses through startup and shutdown procedures, data dictionary usage, tablespaces, control files, and undo management, and advances into working with tables, indexes, constraints, and user security. Learners also explore cutting-edge Oracle 21c features such as blockchain tables, automatic indexing, and flashback technologies. Designed for aspiring and practicing DBAs, this course provides real-world practical examples, step-by-step demonstrations, and structured module-based learning. By the end, learners will be equipped with the knowledge and applied skills to design efficient storage strategies, manage mission-critical databases, enforce security, and leverage Oracle 21c enhancements—setting them apart in the competitive field of database administration.

This module introduces the fundamentals of Oracle Database architecture, covering database servers, processes, memory structures, and administration basics. Learners gain the foundation required to understand how Oracle Database operates and is managed.

What's included

14 videos4 assignments1 plugin

14 videosTotal 89 minutes

Introduction4 minutes
Oracle Server, Instance and Database10 minutes
SGA, Shared Pool, Library Cache11 minutes
Redo Log Buffer, Large Pool and Java Pool2 minutes
Program Global Area9 minutes
Database Writer (DBWn), Log Writer (LGWR)System Monitor (SMON)4 minutes
Checkpoint, Archiver9 minutes
Processing SQL Statements2 minutes
Checkpoint, Archiver and Logical Structure Summary0 minutes
Getting Started with the Oracle Server7 minutes
Database Administrator Users, SQLPlus5 minutes
Oracle Enterprise Manager and Console6 minutes
Managing an Oracle Instance5 minutes
SPFILE spfileSID.ora7 minutes

4 assignmentsTotal 60 minutes

Oracle Database Foundations30 minutes
Introduction and Basics10 minutes
Oracle Processes and Architecture10 minutes
Getting Started with Oracle Administration10 minutes

1 pluginTotal 30 minutes

Exploring Oracle Database Foundations: Architecture, Processes, and Administration30 minutes

This module explains how to manage Oracle instances, startup and shutdown procedures, authentication methods, and database creation. It also explores data dictionaries and dynamic performance views essential for DBA operations.

What's included

11 videos4 assignments

11 videosTotal 93 minutes

Starting up database, Alter database10 minutes
Shutting Down Database9 minutes
Managing and Organizing a Database6 minutes
Using Password File Authentication & Creating a Database6 minutes
Create Database Using DCA And Manually12 minutes
Creating a Database using OMF, Troubleshooting and After Database Creation10 minutes
Creating a Database 018 minutes
Creating a Database 028 minutes
Data Dictionary9 minutes
Dynamic Performance Tables6 minutes
Practical Examples 54 minutes

4 assignmentsTotal 60 minutes

Managing Oracle Instances and Databases30 minutes
Instance and Database Startup/Shutdown10 minutes
Database Creation and Authentication10 minutes
Data Dictionary and Dynamic Views10 minutes

This module covers Oracle storage architecture, including control files, redo logs, tablespaces, datafiles, and undo management. Learners will manage database structures and ensure integrity with effective storage administration.

What's included

24 videos4 assignments

24 videosTotal 183 minutes

Maintaining the Control File8 minutes
Maintaining the Control File Count5 minutes
Practical Examples 66 minutes
Maintaining Redo Log Files10 minutes
Dropping Online Redo Log Files7 minutes
Managing Online Redo Log Files7 minutes
Practical Examples 74 minutes
Types of Tablespaces9 minutes
Locally Managed Tablespaces4 minutes
Undo, Temporary and Read Only Tablespace5 minutes
Default Temporary Tablespace9 minutes
Tablespace offline, Storage Settings and Resizing Tablespace10 minutes
Resizing, Dropping and Obtaining Tablespace information10 minutes
Managing Tablespaces and Datafiles-Practical 016 minutes
Managing Tablespaces and Datafiles-Practical 026 minutes
Types of Segments7 minutes
Storage Clause Precedence7 minutes
Non Standard Block Size, Database Block Contents10 minutes
Manual Data block Management and Practical Examples11 minutes
Managing Undo Data5 minutes
Types of Undo Segments7 minutes
Automatic Undo Management Altering an UNDO Tablespace7 minutes
Automatic Undo Management Sizing an UNDO Tablespace5 minutes
Practical Example Session 107 minutes

4 assignmentsTotal 60 minutes

Storage Structures and Control Management30 minutes
Control Files and Redo Logs10 minutes
Tablespaces and Datafiles10 minutes
Segments, Blocks and Undo10 minutes

This module teaches how to manage user data, create and modify tables, implement indexes, and enforce constraints. Learners will apply Oracle SQL techniques to ensure data efficiency, integrity, and security.

What's included

18 videos4 assignments

18 videosTotal 130 minutes

Storing User Data8 minutes
Oracle Built-in Data Types8 minutes
ROWID Format, Structure of a Row8 minutes
Creating a Table7 minutes
Truncating , Dropping Table6 minutes
Dropping a Table6 minutes
Practical Example Session 116 minutes
Btree Index8 minutes
Bitmap Indexes5 minutes
Creating Btree and Bitmap Index9 minutes
Changing Storage Parameters for Indexes6 minutes
Changing Storage Parameters for Indexes Count6 minutes
Practical Examples 125 minutes
Types of Constraints , Constraints States7 minutes
Types of Constraints , Constraints States Count6 minutes
Defining Constraints7 minutes
Enabling Constraints6 minutes
Practical Examples 138 minutes

4 assignmentsTotal 60 minutes

Working with User Data, Indexes, and Constraints30 minutes
Tables and Data Storage10 minutes
Indexing Techniques10 minutes
Constraints and Security Basics10 minutes

This module introduces advanced Oracle DBA topics including security management, profiles, resource directives, and enhancements in Oracle 21c. Learners will evaluate and apply modern features such as blockchain tables and automatic indexing.