When will I have access to the lectures and assignments?

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.

What will I get if I subscribe to this Specialization?

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.

Is financial aid available?

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.

Oracle DBA 21c: Design, Manage & Secure Databases

kurs ist nicht verfügbar in Deutsch (Deutschland)

Wir übersetzen es in weitere Sprachen. Sehen Sie sich die Sprachen an, die wir anbieten.

Oracle DBA 21c: Design, Manage & Secure Databases

Dieser Kurs ist Teil von Spezialisierung „Oracle DBA 21c: Master Database Administration“

Dozent: EDUCBA

Bei enthalten

Mehr erfahren

5 Module

Verschaffen Sie sich einen Einblick in ein Thema und lernen Sie die Grundlagen.

14 Bewertungen

2 Wochen zu vervollständigen

unter 10 Stunden pro Woche

Flexibler Zeitplan

In Ihrem eigenen Lerntempo lernen

5 Module

Verschaffen Sie sich einen Einblick in ein Thema und lernen Sie die Grundlagen.

14 Bewertungen

2 Wochen zu vervollständigen

unter 10 Stunden pro Woche

Flexibler Zeitplan

In Ihrem eigenen Lerntempo lernen

Was Sie lernen werden

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

Kompetenzen, die Sie erwerben

Kategorie: SQL
Kategorie: Database Design
Kategorie: Data Storage Technologies
Kategorie: Database Administration
Kategorie: Database Management
Kategorie: File Management
Kategorie: Data Integrity
Kategorie: Security Controls
Kategorie: Data Management
Kategorie: User Accounts
Kategorie: Data Storage
Kategorie: Identity and Access Management
Kategorie: Database Architecture and Administration
Kategorie: Cyber Security Policies
Kategorie: Performance Tuning
Kategorie: System Monitoring

Werkzeuge, die Sie lernen werden

Kategorie: Database Management Systems
Kategorie: Oracle Databases
Kategorie: Oracle SQL Developer
Kategorie: Relational Databases

Wichtige Details

Zertifikat zur Vorlage

Zu Ihrem LinkedIn-Profil hinzufügen

Bewertungen

19 Aufgaben

Unterrichtet in Englisch

91% of learners achieved a positive career outcome

Erfahren Sie, wie Mitarbeiter führender Unternehmen gefragte Kompetenzen erwerben.

Weitere Informationen zu Coursera für Unternehmen

Logos von Petrobras, TATA, Danone, Capgemini, P&G und L'Oreal

Erweitern Sie Ihre Fachkenntnisse

Dieser Kurs ist Teil der Spezialisierung Spezialisierung „Oracle DBA 21c: Master Database Administration“

Wenn Sie sich für diesen Kurs anmelden, werden Sie auch für diese Spezialisierung angemeldet.

Lernen Sie neue Konzepte von Branchenexperten
Gewinnen Sie ein Grundverständnis bestimmter Themen oder Tools
Erwerben Sie berufsrelevante Kompetenzen durch praktische Projekte
Erwerben Sie ein Berufszertifikat zur Vorlage

In diesem Kurs gibt es 5 Module

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.

Moduldetails

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.

Das ist alles enthalten

14 Videos4 Aufgaben

14 VideosInsgesamt 89 Minuten

Introduction4 Minuten
Oracle Server, Instance and Database10 Minuten
SGA, Shared Pool, Library Cache12 Minuten
Redo Log Buffer, Large Pool and Java Pool3 Minuten
Program Global Area10 Minuten
Database Writer (DBWn), Log Writer (LGWR)System Monitor (SMON)5 Minuten
Checkpoint, Archiver9 Minuten
Processing SQL Statements2 Minuten
Checkpoint, Archiver and Logical Structure Summary1 Minute
Getting Started with the Oracle Server8 Minuten
Database Administrator Users, SQLPlus5 Minuten
Oracle Enterprise Manager and Console7 Minuten
Managing an Oracle Instance6 Minuten
SPFILE spfileSID.ora8 Minuten

4 AufgabenInsgesamt 60 Minuten

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

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.

Das ist alles enthalten

11 Videos4 Aufgaben

11 VideosInsgesamt 93 Minuten

Starting up database, Alter database11 Minuten
Shutting Down Database9 Minuten
Managing and Organizing a Database6 Minuten
Using Password File Authentication & Creating a Database6 Minuten
Create Database Using DCA And Manually12 Minuten
Creating a Database using OMF, Troubleshooting and After Database Creation11 Minuten
Creating a Database 018 Minuten
Creating a Database 028 Minuten
Data Dictionary10 Minuten
Dynamic Performance Tables7 Minuten
Practical Examples 55 Minuten

4 AufgabenInsgesamt 60 Minuten

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

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.

Das ist alles enthalten

24 Videos4 Aufgaben

24 VideosInsgesamt 183 Minuten

Maintaining the Control File8 Minuten
Maintaining the Control File Count5 Minuten
Practical Examples 66 Minuten
Maintaining Redo Log Files10 Minuten
Dropping Online Redo Log Files7 Minuten
Managing Online Redo Log Files7 Minuten
Practical Examples 74 Minuten
Types of Tablespaces10 Minuten
Locally Managed Tablespaces5 Minuten
Undo, Temporary and Read Only Tablespace6 Minuten
Default Temporary Tablespace9 Minuten
Tablespace offline, Storage Settings and Resizing Tablespace10 Minuten
Resizing, Dropping and Obtaining Tablespace information11 Minuten
Managing Tablespaces and Datafiles-Practical 016 Minuten
Managing Tablespaces and Datafiles-Practical 026 Minuten
Types of Segments8 Minuten
Storage Clause Precedence7 Minuten
Non Standard Block Size, Database Block Contents11 Minuten
Manual Data block Management and Practical Examples12 Minuten
Managing Undo Data6 Minuten
Types of Undo Segments7 Minuten
Automatic Undo Management Altering an UNDO Tablespace8 Minuten
Automatic Undo Management Sizing an UNDO Tablespace6 Minuten
Practical Example Session 108 Minuten

4 AufgabenInsgesamt 60 Minuten

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

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.

Das ist alles enthalten

18 Videos4 Aufgaben

18 VideosInsgesamt 130 Minuten

Storing User Data8 Minuten
Oracle Built-in Data Types8 Minuten
ROWID Format, Structure of a Row9 Minuten
Creating a Table7 Minuten
Truncating , Dropping Table6 Minuten
Dropping a Table7 Minuten
Practical Example Session 116 Minuten
Btree Index8 Minuten
Bitmap Indexes5 Minuten
Creating Btree and Bitmap Index10 Minuten
Changing Storage Parameters for Indexes7 Minuten
Changing Storage Parameters for Indexes Count7 Minuten
Practical Examples 126 Minuten
Types of Constraints , Constraints States8 Minuten
Types of Constraints , Constraints States Count7 Minuten
Defining Constraints8 Minuten
Enabling Constraints7 Minuten
Practical Examples 139 Minuten

4 AufgabenInsgesamt 60 Minuten

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

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.