Oracle DBA 21c: Design, Manage & Secure Databases
Ends soon! Keep adding new skills with 10,000+ programs for $239 (usually $399). Save now.
Oracle DBA 21c: Design, Manage & Secure Databases
This course is part of Oracle DBA 21c: Master Database Administration Specialization
Included with
Ask Coursera
18 reviews
18 reviews
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
Details to know
See how employees at top companies are mastering in-demand skills
Build your subject-matter expertise
- 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.
Explore more from Data Analysis
- Status: Free Trial
Specialization
- Status: Free Trial
Course
- Status: Free Trial
Specialization
- Status: Free Trial
Course
Why people choose Coursera for their career
Learner reviews
- 5 stars
100%
- 4 stars
0%
- 3 stars
0%
- 2 stars
0%
- 1 star
0%
Showing 3 of 18
Reviewed on Mar 2, 2026
The video lectures were high quality with clear audio and visuals. The instructor explained concepts in a very engaging way.
Reviewed on Feb 6, 2026
Core DBA concepts such as database architecture, users, roles, and storage management are explained clearly.
Reviewed on Jun 5, 2026
Excellent Oracle DBA course with clear explanations of database architecture, security, storage management, and Oracle 21c features, making it a great choice for aspiring database administrators
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.
More questions
Financial aid available,