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 33 Modules · 9 Courses

Online / Classroom

ORACLE DBA 12C-19C-23C COMBO

Week 1 (10 Hours): Introduction to Oracle Database and Core Administration + Week 2 (10 Hours): Backup, Recovery, and High Availability + Week 3 (10 Hours): Multitenant Architecture and Real Application Clusters (RAC) + Week 4 (10 Hours): Performance Tuning and Optimization + Week 5 (10 Hours): Security, Compliance, and Auditing + Week 6 (10 Hours): Migration, Upgrades, and AI/ML Features in 23c + Capstone Project (10 Hours): Comprehensive Database Solution Implementation + Optional Practical Workshops and Job Simulations (Integrated Throughout) + What You Learn After This Training –

Courses Included 9 Courses Combined

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: Contact us ·

Call Now

100% placement assistance

What you'll learn

Introduction to Oracle Database Versions (2 hours)

Database Architecture and Environment Setup (4 hours)

Backup and Recovery Basics (5 hours)

Advanced RMAN Recovery Techniques (5 hours)

Introduction to Multitenant Architecture (4 hours)

Advanced Multitenancy Features (3 hours)

Database Performance Tuning Fundamentals (5 hours)

Advanced Performance Tuning (5 hours)

Database Security Essentials (4 hours)

Advanced Security and Auditing (4 hours)

Programme Overview

33 modules across Week 1 (10 Hours): Introduction to Oracle Database and Core Administration, Week 2 (10 Hours): Backup, Recovery, and High Availability, Week 3 (10 Hours): Multitenant Architecture and Real Application Clusters (RAC), Week 4 (10 Hours): Performance Tuning and Optimization, Week 5 (10 Hours): Security, Compliance, and Auditing, Week 6 (10 Hours): Migration, Upgrades, and AI/ML Features in 23c, Capstone Project (10 Hours): Comprehensive Database Solution Implementation, Optional Practical Workshops and Job Simulations (Integrated Throughout), What You Learn After This Training – — a single, progressive learning arc from foundational concepts to real-world projects.

Courses Combined

Total Modules

198

Total Topics

4.8★

Average Rating

50K+

Students Trained

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

Master the core concepts and hands-on skills of Week 1 (10 Hours): Introduction to Oracle Database and Core Administration — from fundamentals to real-world application.

Oracle

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

Master the core concepts and hands-on skills of Week 2 (10 Hours): Backup, Recovery, and High Availability — from fundamentals to real-world application.

Backup and Recovery Basics (5 hours) Advanced RMAN Recovery Techniques (5 hours)

Week 3 (10 Hours): Multitenant Architecture and Real Application Clusters (RAC)

Master the core concepts and hands-on skills of Week 3 (10 Hours): Multitenant Architecture and Real Application Clusters (RAC) — from fundamentals to real-world application.

Oracle

Week 4 (10 Hours): Performance Tuning and Optimization

Master the core concepts and hands-on skills of Week 4 (10 Hours): Performance Tuning and Optimization — from fundamentals to real-world application.

SQL

Week 5 (10 Hours): Security, Compliance, and Auditing

Master the core concepts and hands-on skills of Week 5 (10 Hours): Security, Compliance, and Auditing — from fundamentals to real-world application.

Oracle

Week 6 (10 Hours): Migration, Upgrades, and AI/ML Features in 23c

Master the core concepts and hands-on skills of Week 6 (10 Hours): Migration, Upgrades, and AI/ML Features in 23c — from fundamentals to real-world application.

Oracle Machine Learning Python

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

9 courses • 33 modules • 198 topics

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

Courses Combined

100% Practical · Unlimited Doubt Sessions

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

Oracle Database architecture: Memory structures

processes

data files

Installation and configuration of Oracle 12c

19c

and 23c

virtual machine

or cloud-based setup

Database creation and basic administration tasks

Hands-On Practice

› Hands-on environment setup: Local machine

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

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

Courses Combined

100% Practical · Unlimited Doubt Sessions

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

Hands-On Practice

› Hands-on: Configuring and performing RMAN backups

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

Week 3 (10 Hours): Multitenant Architecture and Real Application Clusters (RAC)

Courses Combined

100% Practical · Unlimited Doubt Sessions

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

Resource management in a multitenant environment

Enhancements in multitenancy from 12c through 23c

Hands-On Practice

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

Overview of Oracle RAC architecture and components

Installing and configuring basic RAC instances

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

Week 4 (10 Hours): Performance Tuning and Optimization

Courses Combined

100% Practical · Unlimited Doubt Sessions

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

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

Week 5 (10 Hours): Security, Compliance, and Auditing

Courses Combined

100% Practical · Unlimited Doubt Sessions

User authentication

roles

and profiles

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

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

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

Hands-On Practice

› Hands-on: Configuring comprehensive auditing and compliance settings

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

Week 6 (10 Hours): Migration, Upgrades, and AI/ML Features in 23c

Courses Combined

100% Practical · Unlimited Doubt Sessions

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

Hands-On Practice

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

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

Capstone Project (10 Hours): Comprehensive Database Solution Implementation

Courses Combined

100% Practical · Unlimited Doubt Sessions

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

Optional Practical Workshops and Job Simulations (Integrated Throughout)

Courses Combined

100% Practical · Unlimited Doubt Sessions

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

What You Learn After This Training –

Courses Combined

100% Practical · Unlimited Doubt Sessions

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.

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).

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).

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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

Oracle

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

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

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

Week 3 (10 Hours): Multitenant Architecture and Real Application Clusters (RAC)

Oracle

Covered in Week 3 (10 Hours): Multitenant Architecture and Real Application Clusters (RAC)

Week 4 (10 Hours): Performance Tuning and Optimization

SQL

Covered in Week 4 (10 Hours): Performance Tuning and Optimization

Week 5 (10 Hours): Security, Compliance, and Auditing

Oracle

Covered in Week 5 (10 Hours): Security, Compliance, and Auditing

Week 6 (10 Hours): Migration, Upgrades, and AI/ML Features in 23c

Oracle

Covered in Week 6 (10 Hours): Migration, Upgrades, and AI/ML Features in 23c

Machine Learning

Covered in Week 6 (10 Hours): Migration, Upgrades, and AI/ML Features in 23c

Python

Covered in Week 6 (10 Hours): Migration, Upgrades, and AI/ML Features in 23c

Capstone Project (10 Hours): Comprehensive Database Solution Implementation

Oracle

Covered in Capstone Project (10 Hours): Comprehensive Database Solution Implementation

Optional Practical Workshops and Job Simulations (Integrated Throughout)

Covered in Optional Practical Workshops and Job Simulations (Integrated Throughout)

What You Learn After This Training –

Oracle

Covered in What You Learn After This Training –

SQL

Covered in What You Learn After This Training –

Machine Learning

Covered in What You Learn After This Training –

Linux

Covered in What You Learn After This Training –

Tools & Libraries

198+

Hands-On Topics

Total Modules

Courses Combined

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

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

PROJECT // 01

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

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

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

→Week 3 (10 Hours): Multitenant Architecture and Real Application Clusters (RAC)

→Week 4 (10 Hours): Performance Tuning and Optimization

→Week 5 (10 Hours): Security, Compliance, and Auditing

→Week 6 (10 Hours): Migration, Upgrades, and AI/ML Features in 23c

→Capstone Project (10 Hours): Comprehensive Database Solution Implementation

→Optional Practical Workshops and Job Simulations (Integrated Throughout)

→What You Learn After This Training –

Capstone Project Combined

Apply everything you learn across Week 1 (10 Hours): Introduction to Oracle Database and Core Administration, Week 2 (10 Hours): Backup, Recovery, and High Availability, Week 3 (10 Hours): Multitenant Architecture and Real Application Clusters (RAC), Week 4 (10 Hours): Performance Tuning and Optimization, Week 5 (10 Hours): Security, Compliance, and Auditing and 4 more 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: Week 1 (10 Hours): Introduction to Oracle Database and Core Administration Hands-on Practice: Week 2 (10 Hours): Backup, Recovery, and High Availability Hands-on Practice: Week 3 (10 Hours): Multitenant Architecture and Real Application Clusters (RAC) Hands-on Practice: Week 4 (10 Hours): Performance Tuning and Optimization Hands-on Practice: Week 5 (10 Hours): Security, Compliance, and Auditing Hands-on Practice: Week 6 (10 Hours): Migration, Upgrades, and AI/ML Features in 23c Hands-on Practice: Capstone Project (10 Hours): Comprehensive Database Solution Implementation Hands-on Practice: Optional Practical Workshops and Job Simulations (Integrated Throughout) Hands-on Practice: What You Learn After This Training –

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

See Sample Project Reports

Upcoming Batches

No upcoming batches scheduled right now. Enquire to get notified.

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

Enroll Now

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

Enroll Now

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

Enroll Now

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.