Skip to Content
Home └Oracle 19c Database Administration
Oracle 19c Database Administration

Oracle 19c Database Administration

Recorded video sessions covering Oracle Database 19c installation, storage, users and security, backup and recovery, and day-to-day administration.

Self-paced: watch at your own speed, any time, on any device.

Self-paced course
₹15,000
or start with ₹5,000 and pay the balance within 3 months
₹
Pay in full ₹15,000
  • ○ Lessons, videos and quizzes from ₹5,000
  • 🔒 Lab recordings at ₹15,000
  • 🔒 Certification exam at full payment
  • ○ Optional real lab: ₹5,000 per month (after full payment)
Valid 12 months from your first payment. Refund policy
Responsible XertApp
Last Update 10/17/2026
Completion Time 16 hours 56 minutes
Members 1
Self-Paced Video Oracle Courses Database
  • Module 1 — Oracle Database 19c architecture (empty)
    12Lessons · 1 hr 37 min
    • 1.1 Video: The instance and the database
    • 1.1 The instance and the database
    • 1.2 Video: Memory structures: SGA and PGA
    • 1.2 Memory structures: SGA and PGA
    • 1.3 Video: Background processes
    • 1.3 Background processes
    • 1.4 Video: Physical storage: the files of a database
    • 1.4 Physical storage: the files of a database
    • 1.5 Video: Logical storage: tablespaces, segments, extents and blocks
    • 1.5 Logical storage: tablespaces, segments, extents and blocks
    • 1.L Lab: Touring a 19c instance: memory, processes and files
      Lab
    • Module 1 Quiz: Oracle Database 19c Architecture
      10 xp
  • Module 2 — Installation and database creation (empty)
    12Lessons · 1 hr 40 min
    • 2.1 Video: Preparing Linux for Oracle Database 19c
    • 2.1 Preparing Linux for Oracle Database 19c
    • 2.2 Video: Installing the software: image-based installation
    • 2.2 Installing the software: image-based installation
    • 2.3 Video: Creating a database with DBCA
    • 2.3 Creating a database with DBCA
    • 2.4 Video: Oracle base, Oracle homes and the inventory
    • 2.4 Oracle base, Oracle homes and the inventory
    • 2.5 Video: Post-installation checks
    • 2.5 Post-installation checks
    • 2.L Lab: Silent installation and database creation
      Lab
    • Module 2 Quiz: Installation and Database Creation
      10 xp
  • Module 3 — Managing the database instance (empty)
    12Lessons · 1 hr 37 min
    • 3.1 Video: Starting up and shutting down
    • 3.1 Starting up and shutting down
    • 3.2 Video: Initialization parameters and the SPFILE
    • 3.2 Initialization parameters and the SPFILE
    • 3.3 Video: Alert log, trace files and the ADR
    • 3.3 Alert log, trace files and the ADR
    • 3.4 Video: The data dictionary and dynamic performance views
    • 3.4 The data dictionary and dynamic performance views
    • 3.5 Video: Administration tools: SQL*Plus, SQLcl and Enterprise Manager
    • 3.5 Administration tools: SQL*Plus, SQLcl and Enterprise Manager
    • 3.L Lab: Changing a parameter safely and reading the ADR
      Lab
    • Module 3 Quiz: Managing the Database Instance
      10 xp
  • Module 4 — Oracle Net Services (empty)
    12Lessons · 1 hr 37 min
    • 4.1 Video: The listener and database services
    • 4.1 The listener and database services
    • 4.2 Video: Naming methods: Easy Connect and tnsnames.ora
    • 4.2 Naming methods: Easy Connect and tnsnames.ora
    • 4.3 Video: Service registration and the LREG process
    • 4.3 Service registration and the LREG process
    • 4.4 Video: Dedicated and shared server
    • 4.4 Dedicated and shared server
    • 4.5 Video: Troubleshooting connections
    • 4.5 Troubleshooting connections
    • 4.L Lab: Creating a service and fixing a connection error
      Lab
    • Module 4 Quiz: Oracle Net Services
      10 xp
  • Module 5 — Managing database storage (empty)
    12Lessons · 1 hr 37 min
    • 5.1 Video: Tablespaces and data files
    • 5.1 Tablespaces and data files
    • 5.2 Video: Managing space in segments
    • 5.2 Managing space in segments
    • 5.3 Video: Undo management
    • 5.3 Undo management
    • 5.4 Video: Temporary tablespaces
    • 5.4 Temporary tablespaces
    • 5.5 Video: Redo log groups and ARCHIVELOG mode
    • 5.5 Redo log groups and ARCHIVELOG mode
    • 5.L Lab: Space, undo and redo: three common fixes
      Lab
    • Module 5 Quiz: Managing Database Storage
      10 xp
  • Module 6 — Users, security and auditing (empty)
    12Lessons · 1 hr 37 min
    • 6.1 Video: Users, authentication and profiles
    • 6.1 Users, authentication and profiles
    • 6.2 Video: System and object privileges
    • 6.2 System and object privileges
    • 6.3 Video: Roles
    • 6.3 Roles
    • 6.4 Video: Unified auditing
    • 6.4 Unified auditing
    • 6.5 Video: Least privilege and securing a new database
    • 6.5 Least privilege and securing a new database
    • 6.L Lab: An application account with least privilege and auditing
      Lab
    • Module 6 Quiz: Users, Security and Auditing
      10 xp
  • Module 7 — Backup and recovery with RMAN (empty)
    12Lessons · 1 hr 38 min
    • 7.1 Video: Backup and recovery concepts and the fast recovery area
    • 7.1 Backup and recovery concepts and the fast recovery area
    • 7.2 Video: RMAN backups: full, incremental and image copies
    • 7.2 RMAN backups: full, incremental and image copies
    • 7.3 Video: Retention policy, the recovery catalog and reporting
    • 7.3 Retention policy, the recovery catalog and reporting
    • 7.4 Video: Restore and recovery scenarios
    • 7.4 Restore and recovery scenarios
    • 7.5 Video: Duplicating a database
    • 7.5 Duplicating a database
    • 7.L Lab: RMAN backup, a lost data file and a restore test
      Lab
    • Module 7 Quiz: Backup and Recovery with RMAN
      10 xp
  • Module 8 — Flashback and data movement (empty)
    12Lessons · 1 hr 37 min
    • 8.1 Video: Flashback query, version query and flashback table
    • 8.1 Flashback query, version query and flashback table
    • 8.2 Video: Flashback drop and the recycle bin
    • 8.2 Flashback drop and the recycle bin
    • 8.3 Video: Flashback database and restore points
    • 8.3 Flashback database and restore points
    • 8.4 Video: Data Pump export and import
    • 8.4 Data Pump export and import
    • 8.5 Video: SQL*Loader and external tables
    • 8.5 SQL*Loader and external tables
    • 8.L Lab: Undoing mistakes with flashback and copying a schema with Data Pump
      Lab
    • Module 8 Quiz: Flashback and Data Movement
      10 xp
  • Module 9 — Performance monitoring and maintenance (empty)
    12Lessons · 1 hr 37 min
    • 9.1 Video: AWR, ASH and ADDM
    • 9.1 AWR, ASH and ADDM
    • 9.2 Video: Optimizer statistics and automated maintenance
    • 9.2 Optimizer statistics and automated maintenance
    • 9.3 Video: SQL tuning and plan stability
    • 9.3 SQL tuning and plan stability
    • 9.4 Video: Memory management
    • 9.4 Memory management
    • 9.5 Video: The scheduler, metrics and alerts
    • 9.5 The scheduler, metrics and alerts
    • 9.L Lab: Finding a slowdown with ASH and fixing a plan regression
      Lab
    • Module 9 Quiz: Performance Monitoring and Maintenance
      10 xp
  • Module 10 — Patching, upgrade and multitenant (empty)
    12Lessons · 1 hr 37 min
    • 10.1 Video: Release Updates, OPatch and datapatch
    • 10.1 Release Updates, OPatch and datapatch
    • 10.2 Video: Upgrading to 19c with AutoUpgrade
    • 10.2 Upgrading to 19c with AutoUpgrade
    • 10.3 Video: Multitenant architecture: CDB and PDBs
    • 10.3 Multitenant architecture: CDB and PDBs
    • 10.4 Video: Creating, cloning and moving PDBs
    • 10.4 Creating, cloning and moving PDBs
    • 10.5 Video: Staying supported: the 19c lifecycle
    • 10.5 Staying supported: the 19c lifecycle
    • 10.L Lab: Applying a Release Update and cloning a PDB
      Lab
    • Module 10 Quiz: Patching, Upgrade and Multitenant
      10 xp
  • Final Certification (empty)
    1Lessons · 40 min
    • Certification Exam: Oracle 19c Database Administration