Oracle DBA 19c Advanced Training
The complete 19c administrator track — 45 live sessions and around 80 hours that take you from Linux foundations all the way to RAC, Data Guard, GoldenGate and performance tuning. Available as a 1:1 track or a live weekend batch, taught entirely by a working production DBA.
- Weekend or weekday batches · morning or evening slots · check upcoming schedule →
- Hands-on labs on a real 19c estate — Architecture, Installation, Storage & Users, RMAN Backup & Recovery, Data Guard, RAC, Patching, Upgrades, GoldenGate & Tuning
- Certificate + lifetime recordings in your student portal
Overview
This is the full Oracle DBA 19c administrator program — the same end-to-end journey we have used to train thousands of working database administrators. Over 45 live sessions of 90 minutes each, roughly 80 hours in total, you start from the very beginning with the Linux operating system and the Oracle architecture, and finish able to install, manage, back up, protect, cluster, replicate, patch, upgrade and tune a production Oracle database. Every concept is taught live and then practised hands-on in a lab you build yourself, so the knowledge sticks.
You learn it from our senior Oracle DBA instructors, who have spent 12+ years running Oracle databases in production across 19c, RAC, Data Guard, GoldenGate and the cloud. Sessions run live on weekday evenings, are recorded to your secure student portal with session notes, and stay with you for life. You get assignments after every module, documentation for each session, software and patches for practice, WhatsApp doubt-clearing, interview Q&A and a course completion certificate. Whether you are starting your DBA career or filling gaps before an interview, this program covers the whole job.
What you'll learn
- Set up a Linux VM lab and run a database from scratch
- Understand Oracle 19c architecture, memory and processes
- Install Oracle and create CDB/PDB databases with DBCA
- Manage tablespaces, users, roles, privileges and profiles
- Administer control files, redo logs and ARCHIVELOG mode
- Back up and recover with RMAN and Datapump
- Build and operate Data Guard physical standby databases
- Patch and upgrade databases the right way
- Install and run a two-node RAC cluster with ASM
- Tune performance with AWR, ASH and ADDM, and replicate with GoldenGate
Complete syllabus (~80 hours)
1Introduction to Linux OS for an Oracle DBA2 sessions · 3 hrs
- Install VirtualBox and build a Linux VM lab
- Daily Linux commands every DBA needs
- Users, groups and permissions
- Monitoring disk and filesystem space
- SSH and SCP for remote access and transfers
- Editing files with vi; starting and stopping the server
2Oracle Database Architecture 19c3 sessions · 4.5 hrs
- 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
3Installation of Oracle Database2 sessions · 3 hrs
- Prerequisites: kernel parameters, packages and users
- GUI installation with the Oracle Universal Installer
- Silent installation using a response file
- Post-install verification and validation
4Database Creation including CDB/PDB3 sessions · 4.5 hrs
- Create a database with DBCA and a CDB
- Configure the listener and tnsnames
- Manual and silent database creation
- PDB management — create from PDB$SEED, connect
- Plug and unplug pluggable databases
5Managing the Oracle Database Instance1 session · 1.5 hrs
- Startup and shutdown stages: NOMOUNT, MOUNT, OPEN
- Managing parameters with spfile and pfile
- Key data dictionary views and log locations
- Introduction to SQL DDL and DML
6Managing Tablespaces, Users, Roles & Privileges3 sessions · 4.5 hrs
- Tablespaces and datafiles
- Creating and managing users and roles
- Granting and revoking privileges
- Password profiles, resource limits and quotas
- Auditing basics and a hands-on lab
7Managing Control File, Redo Log & Archive Log Files2 sessions · 3 hrs
- Control file multiplexing and backup
- Online redo log management
- Adding and dropping redo log groups
- Enabling ARCHIVELOG mode
- Archive destinations and monitoring
8Backup & Recovery using RMAN & Datapump7 sessions · 10.5 hrs
- Backup concepts; RMAN architecture and configuration
- Full, incremental and compressed backups
- CDB/PDB backups and the Fast Recovery Area
- Restore and recovery: datafile, tablespace and block
- Control file and spfile recovery; point-in-time recovery
- Database cloning
- Datapump expdp/impdp and schema refresh
9Oracle Data Guard Administration5 sessions · 7.5 hrs
- Concepts and protection modes
- Physical standby creation
- Redo transport and real-time apply
- Monitoring lag; switchover and failover
- Snapshot standby databases
- Data Guard Broker (DGMGRL) and troubleshooting
10Oracle Database Patching2 sessions · 3 hrs
- My Oracle Support patches and OPatch
- Running prechecks
- Applying and rolling back patches
- Post-patch verification
11Oracle Database Upgradation2 sessions · 3 hrs
- Upgrade methods and prerequisites
- Manual 12c → 19c upgrade
- Upgrading with DBUA
- AutoUpgrade and post-upgrade tasks
12Oracle Real Application Clusters (RAC)7 sessions · 10.5 hrs
- RAC concepts and architecture
- Prerequisites and storage with ASM
- Public, private and SCAN networking
- Grid Infrastructure install; 2-node RAC creation
- ASM management with srvctl and crsctl
- Adding and removing nodes; OCR and voting disks
- RAC backup, recovery, patching and upgrade
13Oracle Database Performance Tuning2 sessions · 3 hrs
- AWR, ASH and ADDM reports
- Reading and interpreting wait events
- Explain plan and SQL Tuning Advisor
- Comparing performance with AWR compare
14Oracle GoldenGate2 sessions · 3 hrs
- GoldenGate architecture and install
- Extract, pump and replicat processes
- Unidirectional and bi-directional replication
- Monitoring and troubleshooting replication
15Oracle Enterprise Manager (OEM)2 sessions · 3 hrs
- OEM setup and configuration
- Adding hosts and targets
- Using the dashboard and database health monitoring
- Jobs and email notifications
- Course wrap-up, interview prep and certification guidance
Program benefits
- Live instructor-led90-minute sessions taught live every weekend
- Session recordingsEvery session saved to your student portal
- Module assignmentsHands-on tasks after each module to lock in skills
- Session documentationDetailed notes provided for every session
- WhatsApp supportFast doubt-clearing help between sessions
- Software & patchesEverything you need for hands-on practice
- Interview prepCurated Q&A to get you interview-ready
- Completion certificateAwarded when you finish the course
Who it's for
This program is built for anyone who wants to become a job-ready Oracle DBA. It is ideal for freshers and graduates starting from zero — the course assumes no prior database experience and begins with Linux and architecture fundamentals. It also suits IT professionals from development, support or system administration who want to move into the database administration role, and working DBAs who want to fill gaps and add advanced skills like RAC, Data Guard, GoldenGate and tuning. If you are preparing for DBA interviews, the assignments, documentation and interview Q&A throughout the course get you ready to perform.
What learners say
I joined with zero database background and finished able to install, back up and recover a database on my own. The Linux and architecture modules at the start made everything after them click. Best decision for my career.
RKRajesh KumarLead DBA · ChennaiThe RMAN and Data Guard sessions are incredibly thorough — seven full sessions just on backup and recovery. The instructor shows real failure scenarios and how to recover, not just the happy path. The recordings and notes are gold before interviews.
EWEmily WatsonDatabase Engineer · TorontoComing from app support, I wanted a complete path into DBA work. Building the two-node RAC cluster myself and practising patching and upgrades gave me the confidence to clear my interview and switch roles. Worth every rupee.
AAAhmed Al-RashidLead DBA · DubaiDo I need any prior database experience?
How are the sessions delivered?
Will I get hands-on practice?
Do I get a certificate and lifetime access?
Become a complete Oracle DBA
Join the next live weekend batch and go from Linux foundations to RAC, Data Guard and tuning in ~80 hours — with lifetime recordings, hands-on labs and real support.