Oracle Database 19c Administration

A comprehensive Oracle Database 19c Administration course covering installation, architecture, storage management, backup and recovery, performance tuning, and enterprise features from beginner to advanced levels.

Topic 1: Oracle DBA Overview & Environment Setup

Learn DBA roles and responsibilities, Oracle 19c features, and installation procedures.

2 Lessons
6 Sessions
8 Notes
Topic 2: Oracle 19c Architecture in Depth

Understand Oracle architecture including memory structures, processes, and storage components.

2 Lessons
6 Sessions
10 Notes
Topic 3: Database Creation & Management

Learn to create databases using DBCA and manually, manage control files, redo logs, and archive logs.

6 Lessons
8 Sessions
10 Notes
Topic 4: Storage Structures & Tablespace Management

Learn tablespace types, datafile management, segment space management, and storage optimization.

5 Lessons
15 Sessions
17 Notes
Topic 5: Multitenant Architecture (CDB/PDB)

Learn Container Database (CDB) and Pluggable Database (PDB) architecture and management.

2 Lessons
3 Sessions
3 Notes
Topic 6: ASM (Automatic Storage Management)

Learn Automatic Storage Management for simplified storage administration.

2 Lessons
2 Sessions
2 Notes
Topic 7: Backup & Recovery Concepts

Learn backup types, RMAN, recovery strategies, and failure scenarios.

3 Lessons
10 Sessions
10 Notes
Topic 8: Logical Backup & Data Pump

Learn Data Pump (expdp/impdp) for logical backups and data migration.

3 Lessons
6 Sessions
6 Notes
Topic 9: Patching and Upgrades

Learn to apply patches and upgrade Oracle databases.

2 Lessons
6 Sessions
6 Notes
Topic 10: Performance Monitoring & Tuning

Learn performance monitoring tools, AWR, ADDM, and tuning techniques.

3 Lessons
8 Sessions
8 Notes
Topic 11: Data Guard (High Availability & Disaster Recovery)

Learn Data Guard architecture, configuration, and role transitions.

2 Lessons
2 Sessions
2 Notes
Topic 12: Introduction to User & Security Management

Learn database security, authentication types, and user management fundamentals.

2 Lessons
4 Sessions
4 Notes
Topic 13: Privileges and Access Control

Learn system and object privileges, granting and revoking access.

1 Lessons
1 Sessions
1 Notes
Topic 14: Role Management

Learn role creation, management, and predefined roles.

1 Lessons
2 Sessions
2 Notes
Topic 15: Profiles and Resource Management

Learn profile creation, password and resource parameters, and resource monitoring.

1 Lessons
2 Sessions
2 Notes
Topic 16: Auditing and Accountability

Learn auditing concepts, unified auditing, and audit policies.

1 Lessons
1 Sessions
1 Notes
Topic 17: Advanced Security Features

Learn advanced security features: VPD, TDE, column security, and secure administration.

1 Lessons
5 Sessions
5 Notes
Course content is locked. Please purchase or enroll to access all lessons and topics.
Course Progress
0%

Enroll to start learning!

Course Stats
  • Total Topics 17
  • Total Lessons 39
  • Total Sessions 87
  • Total Notes 97
  • Estimated Time 67.10000000000001 hours
View Cart