Oracle DBA 21c: Design, Manage & Secure Databases

Grow your skills with Coursera Plus for $239/year (usually $399). Save now.

Oracle DBA 21c: Design, Manage & Secure Databases

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

Instructor: EDUCBA

Included with

Learn more

5 modules

Gain insight into a topic and learn the fundamentals.

10 reviews

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.

10 reviews

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.

Skills you'll gain

Tools you'll learn

Details to know

Shareable certificate

Add to your LinkedIn profile

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 assignments

14 videos Total 89 minutes

Introduction 4 minutes
Oracle Server, Instance and Database 10 minutes
SGA, Shared Pool, Library Cache 12 minutes
Redo Log Buffer, Large Pool and Java Pool 3 minutes
Program Global Area 10 minutes
Database Writer (DBWn), Log Writer (LGWR)System Monitor (SMON) 5 minutes
Checkpoint, Archiver 9 minutes
Processing SQL Statements 2 minutes
Checkpoint, Archiver and Logical Structure Summary 1 minute
Getting Started with the Oracle Server 8 minutes
Database Administrator Users, SQLPlus 5 minutes
Oracle Enterprise Manager and Console 7 minutes
Managing an Oracle Instance 6 minutes
SPFILE spfileSID.ora 8 minutes

4 assignments Total 60 minutes

Introduction and Basics 10 minutes
Oracle Processes and Architecture 10 minutes
Getting Started with Oracle Administration 10 minutes
Oracle Database Foundations 30 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 videos Total 93 minutes

Starting up database, Alter database 11 minutes
Shutting Down Database 9 minutes
Managing and Organizing a Database 6 minutes
Using Password File Authentication & Creating a Database 6 minutes
Create Database Using DCA And Manually 12 minutes
Creating a Database using OMF, Troubleshooting and After Database Creation 11 minutes
Creating a Database 01 8 minutes
Creating a Database 02 8 minutes
Data Dictionary 10 minutes
Dynamic Performance Tables 7 minutes
Practical Examples 5 5 minutes

4 assignments Total 60 minutes

Instance and Database Startup/Shutdown 10 minutes
Database Creation and Authentication 10 minutes
Data Dictionary and Dynamic Views 10 minutes
Managing Oracle Instances and Databases 30 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 videos Total 183 minutes

Maintaining the Control File 8 minutes
Maintaining the Control File Count 5 minutes
Practical Examples 6 6 minutes
Maintaining Redo Log Files 10 minutes
Dropping Online Redo Log Files 7 minutes
Managing Online Redo Log Files 7 minutes
Practical Examples 7 4 minutes
Types of Tablespaces 10 minutes
Locally Managed Tablespaces 5 minutes
Undo, Temporary and Read Only Tablespace 6 minutes
Default Temporary Tablespace 9 minutes
Tablespace offline, Storage Settings and Resizing Tablespace 10 minutes
Resizing, Dropping and Obtaining Tablespace information 11 minutes
Managing Tablespaces and Datafiles-Practical 01 6 minutes
Managing Tablespaces and Datafiles-Practical 02 6 minutes
Types of Segments 8 minutes
Storage Clause Precedence 7 minutes
Non Standard Block Size, Database Block Contents 11 minutes
Manual Data block Management and Practical Examples 12 minutes
Managing Undo Data 6 minutes
Types of Undo Segments 7 minutes
Automatic Undo Management Altering an UNDO Tablespace 8 minutes
Automatic Undo Management Sizing an UNDO Tablespace 6 minutes
Practical Example Session 10 8 minutes

4 assignments Total 60 minutes

Control Files and Redo Logs 10 minutes
Tablespaces and Datafiles 10 minutes
Segments, Blocks and Undo 10 minutes
Storage Structures and Control Management 30 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 videos Total 130 minutes

Storing User Data 8 minutes
Oracle Built-in Data Types 8 minutes
ROWID Format, Structure of a Row 9 minutes
Creating a Table 7 minutes
Truncating , Dropping Table 6 minutes
Dropping a Table 7 minutes
Practical Example Session 11 6 minutes
Btree Index 8 minutes
Bitmap Indexes 5 minutes
Creating Btree and Bitmap Index 10 minutes
Changing Storage Parameters for Indexes 7 minutes
Changing Storage Parameters for Indexes Count 7 minutes
Practical Examples 12 6 minutes
Types of Constraints , Constraints States 8 minutes
Types of Constraints , Constraints States Count 7 minutes
Defining Constraints 8 minutes
Enabling Constraints 7 minutes
Practical Examples 13 9 minutes

4 assignments Total 60 minutes

Tables and Data Storage 10 minutes
Indexing Techniques 10 minutes
Constraints and Security Basics 10 minutes
Working with User Data, Indexes, and Constraints 30 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.

What's included

18 videos3 assignments

18 videos Total 129 minutes

Profiles and Password Management 7 minutes
Profiles and Password Management Count 9 minutes
Alter, Drop Profile 7 minutes
Resource Plan Directives 9 minutes
Practical Examples 14 6 minutes
Users and Security 8 minutes
Creating a New User Operating System Authentication 6 minutes
Practical Examples 15 6 minutes
Granting and Revoking System Privileges 13 minutes
What is Database Server 9 minutes
PGA and Background Process 7 minutes
Database Buffer Cache 8 minutes
Database System Files 7 minutes
Application Container 8 minutes
LREG and SMON 4 minutes
Checkpoint Process 6 minutes
RVWR 5 minutes
Oracle 21c New Features 5 minutes

3 assignments Total 50 minutes

Security, Profiles, and Resource Management 10 minutes
Oracle 21c Processes and Enhancements 10 minutes
Advanced Administration and Oracle 21c Features 30 minutes

Earn a career certificate

Add this credential to your LinkedIn profile, resume, or CV. Share it on social media and in your performance review.

Instructor

EDUCBA

1,050 Courses 252,287 learners

Offered by

EDUCBA

Explore more from Data Analysis

EDUCBA
Oracle DBA 21c: Master Database Administration
Specialization
EDUCBA
Oracle SQL 21c Mastery: Apply, Analyze & Manage Data
Course
EDUCBA
Oracle SQL 21c: Database Design & Query Mastery
Specialization
EDUCBA
Oracle DBA Training: Architecture, SQL & User Admin
Course

Why people choose Coursera for their career

Felipe M.

Learner since 2018

"To be able to take courses at my own pace and rhythm has been an amazing experience. I can learn whenever it fits my schedule and mood."

Jennifer J.

Learner since 2020

"I directly applied the concepts and skills I learned from my courses to an exciting new project at work."

Larry W.

Learner since 2021

"When I need courses on topics that my university doesn't offer, Coursera is one of the best places to go."

Chaitanya A.

"Learning isn't just about being better at your job: it's so much more than that. Coursera allows me to learn without limits."

Learner reviews

5 stars
100%
4 stars
0%
3 stars
0%
2 stars
0%
1 star
0%

Showing 3 of 10

Reviewed on Jan 20, 2026

Step-by-step demonstrations make complex DBA tasks easier to understand and follow.

Reviewed on Mar 24, 2026

Covers important Oracle 21c features in a simple way.

Reviewed on Feb 6, 2026

Core DBA concepts such as database architecture, users, roles, and storage management are explained clearly.

View more reviews

Open new doors with Coursera Plus

Unlimited access to 10,000+ world-class courses, hands-on projects, and job-ready certificate programs - all included in your subscription

Learn more

Advance your career with an online degree

Earn a degree from world-class universities - 100% online

Explore degrees

Join over 3,400 global companies that choose Coursera for Business

Upskill your employees to excel in the digital economy

Learn more

Frequently asked questions

To access the course materials, assignments and to earn a Certificate, you will need to purchase the Certificate experience when you enroll in a course. You can try a Free Trial instead, or apply for Financial Aid. The course may offer 'Full Course, No Certificate' instead. This option lets you see all course materials, submit required assessments, and get a final grade. This also means that you will not be able to purchase a Certificate experience.

When you enroll in the course, you get access to all of the courses in the Specialization, and you earn a certificate when you complete the work. Your electronic Certificate will be added to your Accomplishments page - from there, you can print your Certificate or add it to your LinkedIn profile.

Yes. In select learning programs, you can apply for financial aid or a scholarship if you can’t afford the enrollment fee. If fin aid or scholarship is available for your learning program selection, you’ll find a link to apply on the description page.