Complete Oracle Database Administration course (19C,21C)

Oracle Database Administration course /Multitenancy/ Oracle Database Backup&Recovery/Data Guard/Patching & Upgrade

4.45 (2651 reviews)

Udemy

platform

English

language

Operating Systems

What you will learn

Oracle Database Administration

Oracle Database Architecture, Physical files of the DB, Memory Structures, Memory Management, Background Processes

How to install Oracle Database Software on the server without GUI

How to access Oracle Database via sqlplus, sqlcl and SQL Developer

Managing Database Instance: Starting and Shutting down DB, working with initialization parameters, Diagnosing problems, working with Data Dictionary

Oracle Net Services

Administering User Access, Privileges & Roles, Resource Limitation

Multitenancy: Creating PDBs from SEED, Clonning PDBs, creating Refreshable Clones, Unplug/Plug PDBs

Transparent Data Encryption (TDE)

Creating and Managing Tablespaces

Managing UNDO Data

Practicing different Backup and Recovery scenarious via RMAN

Moving Data: Data Pump, SQL Loader

Data Guard configuration

Applying the latest Database Patch

Database Upgrade from 19c to 21c

Course Gallery

Complete Oracle Database Administration course (19C,21C) – Screenshot 1 — Screenshot 1 – Complete Oracle Database Administration course (19C,21C)

Complete Oracle Database Administration course (19C,21C) – Screenshot 2 — Screenshot 2 – Complete Oracle Database Administration course (19C,21C)

Complete Oracle Database Administration course (19C,21C) – Screenshot 3 — Screenshot 3 – Complete Oracle Database Administration course (19C,21C)

Complete Oracle Database Administration course (19C,21C) – Screenshot 4 — Screenshot 4 – Complete Oracle Database Administration course (19C,21C)

Loading charts...

Comidoc Review

Our Verdict

While the accent of the instructor and occasional difficulty following terminal sessions might present some hurdles for non-native English speakers and novice users, the course's comprehensive curriculum, real-world examples, and practical implementation exercises make this Oracle Database Administration (19C,21C) course a valuable resource for students seeking to expand their knowledge of Oracle database management, Multitenancy, Backup&Recovery, Data Guard, Patching & Upgrade processes.

What We Liked

Comprehensive coverage of Oracle Database Administration (19C,21C) including Multitenancy, Backup&Recovery, Data Guard, Patching & Upgrade
Real-world examples and best practices shared by the experienced instructor
Well-structured curriculum focusing on both theory and practical implementation
Complementary materials, scripts, and clear diagrams provided to facilitate learning

Potential Drawbacks

Accent of the instructor can be challenging for non-native English speakers, although subtitles are available
Some students find it difficult to follow commands in terminal sessions on small devices due to low contrast
Occasional fast-paced delivery and lack of clear indication when to execute certain commands during hands-on exercises
Minor issues with documentation, such as typos or unclear instructions