Combo Program

★★★★★

(2,088 ratings) 50,000+ Student

ORACLE DBA 12C-19C-23C COMBO Training in Pune

Covers each topics with Real Time Examples . Covers More than 250+ Real Time Scenarios which is divided into Admin 1 (Basic) + Admin2 + 23C (which is why we called it a combo course). Trainer from Real Time Industry .This is completely hands-on training , which covers 70% Practical And 30% Theory .Specail attention / session for interview preparation after the course is done.We give examples and exposure to real time scenarios to make sure all the candidate will get at least 5+ Year experience knowledge in Oracle DBA after attending this course.Covers 12C-19C-23C topics in Details from the very basic to advanced level . Complete OCA and OCP Exam Preparations.Appear for OCA/OCP Certification Exam at any time After the course . At your convenient time , you can book and appear for exam at our place as we are Pearson certified institute

Radical Technologies

50,000+ English 9 Modules · 1 Section

Online / Classroom

ORACLE DBA 12C-19C-23C COMBO

Sections Included 1 Section (ORACLE DBA 12C-19C-23C COMBO)

Batch Type Weekdays / Weekends

Mode of Training Classroom / Online / Corporate

Locations Pune, Bangalore, Kochi

Language English

Certification Globally Recognized

Tools you'll master

Oracle SQL Machine Learning Python Linux

Next batch: 19/09/2026 · Online

Call Now

100% placement assistance

Enquire Now

Get course fees, batch dates & a callback

We never share your details.

What you'll learn

Week 1 (10 Hours): Introduction to Oracle Database and Core Administration

Week 2 (10 Hours): Backup, Recovery, and High Availability

Programme Overview

9 modules across ORACLE DBA 12C-19C-23C COMBO — a single, progressive learning arc from foundational concepts to real-world projects.

Programme Sections

Total Modules

177

Total Topics

4.8★

Average Rating

50K+

Students Trained

ORACLE DBA 12C-19C-23C COMBO

Master the core concepts and hands-on skills of ORACLE DBA 12C-19C-23C COMBO — from fundamentals to real-world application.

Oracle SQL Machine Learning

Who is this programme for?

Whether you're starting from scratch, know some SQL, or are already writing code — this programme takes you from database fundamentals through Python programming to real-world data analysis.

Students & Freshers

Build a strong foundation in ORACLE DBA 12C-19C-23C COMBO and gain practical, job-ready experience from day one.

Working Professionals

Upskill and combine complementary skills from multiple courses in one structured programme.

Career Switchers

Move into a new technical role with a single, structured path covering everything you need.

IT Professionals

Deepen your expertise and broaden your skill set with hands-on, practical training.

Course Curriculum

1 section • 9 modules • 177 topics

ORACLE DBA 12C-19C-23C COMBO

Programme Sections

100% Practical · Unlimited Doubt Sessions

Introduction to Oracle Database Versions (2 hours)

Overview of Oracle 12c, 19c, and 23c

Key new features in each version, especially AI-enhanced features in 23c

DBA roles and responsibilities in a professional setting

Database Architecture and Environment Setup (4 hours)

Oracle Database architecture: Memory structures, processes, data files

Installation and configuration of Oracle 12c, 19c, and 23c

Database creation and basic administration tasks

Core Database Management Tasks (4 hours)

User, schema, and role management

Managing tablespaces and storage structures

Configuring parameters for database management

Real-world DBA scenario: Managing user privileges and data storage requirements

Hands-On Practice

› Hands-on environment setup: Local machine, virtual machine, or cloud-based setup

Backup and Recovery Basics (5 hours)

Backup strategies: Full, incremental, differential, and archived backups

Introduction to RMAN (Recovery Manager) and its configuration

Job-role simulation: Developing backup strategies for various environments

Advanced RMAN Recovery Techniques (5 hours)

Configuring and performing database restores and recoveries

Cloning databases using RMAN

Utilizing Data Guard for disaster recovery and failover scenarios

Real-world scenario: Configuring high-availability options in production setups

Hands-On Practice

› Hands-on: Configuring and performing RMAN backups

Introduction to Multitenant Architecture (4 hours)

Understanding CDB (Container Databases) and PDB (Pluggable Databases)

Managing CDBs and PDBs: Creation, plugging, unplugging, and cloning

Role-based activity: Implementing a multitenant architecture to consolidate databases

Advanced Multitenancy Features (3 hours)

Resource management in a multitenant environment

Enhancements in multitenancy from 12c through 23c

Introduction to Oracle RAC (Real Application Clusters) (3 hours)

Overview of Oracle RAC architecture and components

Installing and configuring basic RAC instances

Role-based scenario: Setting up a high-availability environment using RAC

Hands-On Practice

› Hands-on: Configuring resource allocation and isolation across PDBs

Database Performance Tuning Fundamentals (5 hours)

Memory management: SGA, PGA, and automatic memory management

Identifying and resolving I/O, CPU, and network bottlenecks

SQL tuning basics and using the SQL Tuning Advisor

Role-based task: Diagnosing and solving common performance issues

Advanced Performance Tuning (5 hours)

Using Automatic Workload Repository (AWR) and Automatic Database Diagnostic Monitor (ADDM)

SQL Plan Management (SPM) and adaptive query plans

SQL tuning enhancements in 19c and AI-driven optimization in 23c

Real-world scenario: Applying tuning methodologies in a simulated environment

Database Security Essentials (4 hours)

User authentication, roles, and profiles

Database encryption: Transparent Data Encryption (TDE) and Data Redaction

Role-based task: Implementing basic security policies and access controls

Advanced Security and Auditing (4 hours)

Virtual Private Database (VPD), Label Security, and fine-grained access control

Unified auditing features across 12c, 19c, and 23c

AI-driven security enhancements in Oracle 23c

Compliance and Data Privacy (2 hours)

Overview of compliance standards: GDPR, HIPAA, and PCI DSS

Oracle’s Data Masking and Subsetting options for compliance

Job role simulation: Implementing database policies to meet regulatory standards

Hands-On Practice

› Hands-on: Configuring comprehensive auditing and compliance settings

Database Migration and Upgrade Strategies (5 hours)

Planning for upgrades: From 12c to 19c or 23c

Using Oracle Data Pump, GoldenGate, and Transportable Tablespaces for migration

Role-based task: Minimizing downtime and ensuring data integrity during migration

Introduction to Oracle 23c AI and Machine Learning Features (5 hours)

Overview of AI-driven features: Autonomous Database and Oracle Machine Learning (OML)

Implementing machine learning models for predictive analysis within Oracle 23c

Integration of Python and R for advanced analytics

Job-oriented exercise: Utilizing AI insights for proactive database management

Hands-On Practice

› Hands-on: Performing a simulated database upgrade and migration

Final Project: Building and Managing a Production-Ready Oracle Database (10 hours)

Implementing a complete database solution using Oracle 12c, 19c, and 23c components

Configuring high availability, Data Guard, and RAC for production-grade resilience

Applying performance tuning, security, compliance, and AI-driven insights

Role-based scenario: Each trainee demonstrates and defends their solution, mimicking a real-world DBA role

Simulated job roles where students practice DBA tasks (managing users, backups, high availability)

Mock job scenarios for disaster recovery, troubleshooting, and performance optimization

Group activities to reinforce concepts in backup management, security, and AI-driven analytics

Here is a list of over 50 intermediate to advanced tasks for an Oracle Database Administrator (DBA), organized by core functional areas. These tasks reflect what Oracle DBAs commonly manage to ensure database performance, security, reliability, and alignment with organizational needs.

Database Installation, Configuration, and Environment Setup

Install and configure Oracle Database across different environments (Linux, Windows, Cloud).

Perform Oracle patching and upgrading (e.g., from 12c to 19c or 23c).

Configure listener and network parameters for database access.

Set up database instances and manage multiple Oracle Homes.

Manage database initialization parameters for performance optimization.

Configure Automatic Memory Management (AMM) and Automatic Shared Memory Management (ASMM).

Implement and manage Oracle Multitenant with Container Databases (CDBs) and Pluggable Databases (PDBs).

Backup and Recovery Management

Design and implement backup strategies (full, incremental, differential, and archived log backups).

Configure RMAN (Recovery Manager) for backup and recovery operations.

Set up incremental backup and block change tracking for RMAN.

Perform tablespace point-in-time recovery (PITR).

Clone databases using RMAN duplicate commands.

Restore and recover from database failures using RMAN.

Schedule and automate RMAN backups.

Configure flashback technologies (Flashback Database, Flashback Query, Flashback Table).

High Availability and Disaster Recovery

Configure and manage Oracle Data Guard for disaster recovery.

Set up and manage Oracle Real Application Clusters (RAC) for high availability.

Implement failover and switchover operations with Data Guard.

Manage physical and logical standby databases.

Install and configure Oracle Clusterware for RAC.

Use Oracle GoldenGate for real-time replication and high availability.

Implement high availability with Application Continuity for transparent failover.

Performance Tuning and Optimization

Analyze Automatic Workload Repository (AWR) reports for performance tuning.

Use Automatic Database Diagnostic Monitor (ADDM) for bottleneck identification.

Optimize SQL queries using SQL Tuning Advisor and SQL Plan Management (SPM).

Perform index tuning (creating, rebuilding, and monitoring indexes).

Implement optimizer hints and understand adaptive query optimization in 19c/23c.

Use SQL Profiles and Baselines to manage SQL execution plans.

Monitor and tune Oracle PGA and SGA memory structures.

Manage partitioned tables and indexes for better performance.

Monitor and troubleshoot I/O performance with Oracle’s Enterprise Manager.

Security Management

Configure Transparent Data Encryption (TDE) for sensitive data protection.

Implement Virtual Private Database (VPD) for fine-grained access control.

Manage roles, privileges, and secure user access.

Configure Oracle Data Redaction for sensitive data masking.

Implement Label Security for row-level data access control.

Set up database auditing (Unified Auditing in 12c/19c/23c).

Conduct security vulnerability assessments using Database Security Assessment Tool (DBSAT).

Encrypt network traffic using Oracle Net encryption.

User Management and Access Control

Create and manage database users and profiles.

Configure resource profiles to control CPU, memory, and I/O utilization per user.

Monitor and resolve user lock conflicts and resource contention.

Implement resource manager plans to prioritize workloads.

Set up password policies and manage expired or locked accounts.

Data Management and Partitioning

Create and manage partitioned tables and indexes.

Perform data compression for storage optimization.

Implement Hybrid Columnar Compression (HCC) on Exadata environments.

Use Oracle Data Pump for data import/export and database migration.

Automate large data transfers and migrations using transportable tablespaces.

Set up materialized views for data replication and performance.

Multitenant Database Management (12c, 19c, and 23c)

Configure and manage Pluggable Databases (PDBs) within Container Databases (CDBs).

Plug and unplug PDBs across different CDBs.

Implement PDB cloning for testing and development environments.

Manage resource allocation across multiple PDBs.

Perform cross-PDB data sharing using metadata links and object links.

Oracle 23c AI and Machine Learning Integration

Integrate Machine Learning (ML) models into SQL queries for predictive insights.

Use Oracle Machine Learning (OML) for in-database ML model development.

Apply AI-driven insights for SQL optimization and query recommendations.

Monitor and manage ML model performance with Oracle 23c enhancements.

Monitoring and Reporting

Set up and monitor alerts for database health (CPU, memory, storage).

Configure and monitor database alerts through Oracle Enterprise Manager (OEM).

Generate periodic health check reports for database performance.

Monitor session activity and troubleshoot blocking sessions.

Use ASH (Active Session History) reports for real-time session monitoring.

Database Migration and Upgrade Management

Plan and execute database upgrades using Database Upgrade Assistant (DBUA).

Perform cross-platform migration using Oracle GoldenGate or Data Pump.

Configure Zero Downtime Migration (ZDM) for Oracle Cloud migrations.

Utilize transportable tablespaces for large data migrations.

Compliance, Auditing, and Data Privacy

Implement database-level GDPR and HIPAA compliance configurations.

Set up data masking and subsetting for non-production environments.

Generate and manage compliance reports to audit user actions and changes.

Conduct routine database security audits and review audit trails.

Job Scheduling and Automation

Automate DBA tasks using Oracle Scheduler.

Create and manage automated jobs and job chains for routine maintenance.

Set up job notifications for success or failure alerts.

Manage scheduled jobs using DBMS_SCHEDULER.

Troubleshooting and Support

Troubleshoot and resolve ORA- and RMAN-specific error codes.

Diagnose and resolve connectivity issues with Oracle Net and listeners.

Recover and restore from data corruption or logical errors.

Perform root cause analysis for critical database failures.

Capacity Planning and Storage Management

Monitor and forecast database growth for capacity planning.

Implement tablespace monitoring and proactively manage storage allocations.

Configure ASM (Automatic Storage Management) for efficient storage.

Perform disk group maintenance and rebalancing with ASM.

Tools & Technologies

Every tool and library listed here is installed, configured and used in a hands-on lab session.

ORACLE DBA 12C-19C-23C COMBO

Oracle

Covered in ORACLE DBA 12C-19C-23C COMBO

SQL

Covered in ORACLE DBA 12C-19C-23C COMBO

Machine Learning

Covered in ORACLE DBA 12C-19C-23C COMBO

Python

Covered in ORACLE DBA 12C-19C-23C COMBO

Tools & Libraries

177+

Hands-On Topics

Total Modules

Programme Sections

You don't just learn ORACLE DBA 12C-19C-23C COMBO. You apply it.

A combined capstone project across all 1 section — the same way you'd apply these skills on the job.

PROJECT // 01

ORACLE DBA 12C-19C-23C COMBO Capstone Project

→ORACLE DBA 12C-19C-23C COMBO

Capstone Project Combined

Apply everything you learn across ORACLE DBA 12C-19C-23C COMBO to one real-world project

Bring together every course in this programme into a single, end-to-end project — the same way you would apply these combined skills on the job.

A working project combining all course modules

Added directly to your project portfolio

Reviewed by mentors before you graduate

Stack Oracle SQL Machine Learning Python Linux

Hands-on Practice Areas

Hands-on Practice: ORACLE DBA 12C-19C-23C COMBO

All projects go directly into your portfolio & resume — reviewed by mentors before you graduate.

See Sample Project Reports

Upcoming Batches

Start Date	Time	Day	Mode	Enroll
19/09/2026	09:30 AM – 12:30 PM	Weekend	Online	Enroll Now
19/09/2026	10:30 AM – 12:30 PM	Weekend	Online	Enroll Now
23/09/2026	09:00 PM – 10:00 PM	Weekday	Online	Enroll Now
26/09/2026	09:30 AM – 12:30 PM	Weekend	Online	Enroll Now

Why Radical Technologies

Live Online Training

Highly practical oriented training
Installation support on your system
24/7 Email and Phone support
100% Placement Assistance
Global Certification Preparation
Trainer-Student Interactive Portal
Assignments and Projects by Mentors

Live Classroom Training

Weekend / Weekdays / Morning / Evening batches
80:20 Practical and Theory ratio
Real-life Case Studies
Easy make-up for missed sessions
PSI | Kryterion | Redhat Test Centers
Lifetime Video Classroom Access (coming soon)
Resume Prep and Mock Interviews

Self-Paced Training

Learn 300+ courses at your own time
50,000+ Satisfied Learners
Course Completion Certificate
Practical Labs available
Mentor Support available
Doubt Clearing Session available
10% Discounted Global Certification

Like the Curriculum? Let's Get Started

Join 50,000+ students already enrolled at Radical Technologies

Enroll Now

Global Certification

Radical Technologies is the leading IT certification institute in Pune, offering globally recognized certifications across various domains. With expert trainers and comprehensive materials, we ensure students gain in-depth knowledge and hands-on experience to excel in their careers. Our certification programs are tailored to meet industry standards — from cloud technologies to data science — empowering individuals to stay ahead in the ever-evolving tech landscape.

Career Services

At Radical Technologies, we are committed to your success beyond the classroom. Our 100% Job Assistance program ensures that you are not only equipped with industry-relevant skills but also guided through the job placement process. With personalised resume building, interview preparation, and access to our extensive network of hiring partners, we help you take the next step confidently into your IT career.