Oracle Core DBA recorded course
The full 19c administrator track on demand — architecture, installation, RMAN backup and recovery, Data Guard, RAC, performance tuning and security, the way it actually works in production. Buy once, learn at your pace, keep it for life.
- The complete core DBA track — install to production ops
- Hands-on labs on a real 19c estate — Architecture, Installation, Tablespaces & Users, RMAN Backup & Recovery, Data Guard, RAC & ASM, Tuning, Patching & Upgrades
- Notes, assignments & interview Q&A included
What this course covers
This self-paced recorded course is the complete Oracle 19c administrator track on demand. Oracle 19c is the long-term support release running production databases across the world, so it's the version most DBA roles still hire for. You'll go from the 19c architecture and installation all the way through database creation, storage and security, RMAN backup and recovery, Data Guard, RAC, performance tuning, patching and upgrade — the way it actually works in production, not just on slides.
You learn it from our senior Oracle DBA instructors, who have spent 12+ years running Oracle 19c databases in production. Every lesson streams in HD inside your secure student portal — no downloads — with companion notes, scripts and assignments, and stays with you for life on any device. Whether you're starting your DBA career or filling gaps before an interview, this course covers the whole 19c administrator job.
What you'll learn
- Oracle 19c architecture, memory and processes
- Install Oracle and create CDB/PDB databases
- Manage tablespaces, users, roles and privileges
- Administer control files, redo logs and ARCHIVELOG mode
- Back up and recover with RMAN and Data Pump
- Build and operate Data Guard physical standby databases
- Install and run a two-node RAC cluster with ASM
- Tune performance with AWR, ASH and ADDM
- Patch and upgrade databases the right way
- Practise every module hands-on in your own lab
Course contents
119c architectureFoundations
- RDBMS fundamentals; instance vs database
- Memory architecture — SGA and PGA
- Background processes: SMON, PMON, DBWn, LGWR, CKPT, ARCn
- Physical and logical storage structures
- Introduction to the multitenant CDB/PDB model
2Installation & DB creationSetup
- Prerequisites: kernel parameters, packages and users
- GUI and silent software installation
- Create a database with DBCA and a CDB
- Configure the listener and tnsnames
- PDB management — create, plug and unplug
3Tablespaces, users & rolesAdministration
- Tablespaces and datafiles
- Creating and managing users and roles
- Granting and revoking privileges
- Password profiles, resource limits and quotas
- Control files, redo logs and ARCHIVELOG mode
4RMAN backup & recovery + Data PumpProtection
- RMAN architecture and configuration
- Full, incremental and compressed backups
- CDB/PDB backups and the Fast Recovery Area
- Restore and recovery; point-in-time recovery
- Data Pump expdp/impdp and schema refresh
5Data GuardHigh availability
- Concepts and protection modes
- Physical standby creation
- Redo transport and real-time apply
- Monitoring lag; switchover and failover
- Data Guard Broker (DGMGRL) and troubleshooting
6RACClustering
- RAC concepts and architecture
- Storage with ASM and SCAN networking
- Grid Infrastructure install; 2-node RAC creation
- ASM management with srvctl and crsctl
- Adding/removing nodes; OCR and voting disks
7Performance tuningOptimization
- AWR, ASH and ADDM reports
- Reading and interpreting wait events
- Explain plan and SQL Tuning Advisor
- Comparing performance with AWR compare
- Practical tuning scenarios
8Patching & upgradeOperations
- My Oracle Support patches and OPatch
- Running prechecks; applying and rolling back patches
- Upgrade methods and prerequisites
- Manual 12c → 19c upgrade and DBUA
- AutoUpgrade and post-upgrade tasks
What you get
- Lifetime accessStream every lesson in your student portal, forever
- Any deviceWatch in HD on mobile, desktop and tablet
- Notes & scriptsCompanion notes and ready-to-run scripts for every module
- Practice assignmentsHands-on exercises to reinforce each module
- WhatsApp mentorshipDoubt-clearing support while you work through the course
Who it's for
This course is built for anyone who wants to become a job-ready Oracle 19c DBA. It's ideal for freshers and graduates starting from zero — it assumes no prior database experience and begins with 19c architecture fundamentals. It also suits IT professionals from development, support or system administration moving into the DBA role, and working DBAs who want to fill gaps and add advanced skills like RAC, Data Guard and tuning. If you're preparing for DBA interviews, the assignments and notes throughout the course get you ready to perform on the version most employers still run.
What learners say
I joined with zero database background and finished able to install, back up and recover a 19c database on my own. The architecture module at the start made everything after it click. Best decision for my career.
RKRajesh KumarLead DBA · ChennaiThe RMAN and Data Guard sections are incredibly thorough. The instructor shows real failure scenarios and how to recover, not just the happy path. Being able to rewatch the recordings before interviews was a huge help.
NHNadia HassanSenior DBA · RiyadhComing from app support, I wanted a complete 19c path. Building the two-node RAC cluster and practising patching and upgrades gave me the confidence to clear my interview and switch roles. Worth every rupee.
RARobert AndersonPrincipal DBA · SydneyPurchase & access
How do I get access after I pay?
Is it lifetime access?
Can I watch on mobile?
Can I download the videos?
What payment methods do you accept?
Do I get a certificate?
What is the refund policy?
About the course
Is it live or recorded?
Do I need prior experience?
Is support included?
Master core Oracle DBA skills at your pace
Get the full core DBA administrator track for ₹4,000 — lifetime access, stream on any device, with notes, labs and WhatsApp support.