Radical Technologies

ORACLE DBA 11G + 12C +19C Combo

Covers each topics with Real Time Examples . Covers More than 250+ Real Time Scenarios which is divided into Admin 1 (Basic) + Admin2 + 12C (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 11G +12C 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

google
0 +

Google Reviews

0 +

JustDial Reviews

The Syllabus

Curriculum Designed by Experts

Week 1 (10 Hours): Introduction to Oracle Database and Core Administration
  1. 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
  1. Database Architecture and Environment Setup (4 hours)
  • Oracle Database architecture: Memory structures, processes, data files
  • Installation and configuration of Oracle 12c, 19c, and 23c
  • Hands-on environment setup: Local machine, virtual machine, or cloud-based setup
  • Database creation and basic administration tasks
  1. 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
Week 2 (10 Hours): Backup, Recovery, and High Availability
  1. Backup and Recovery Basics (5 hours)
  • Backup strategies: Full, incremental, differential, and archived backups
  • Introduction to RMAN (Recovery Manager) and its configuration
  • Hands-on: Configuring and performing RMAN backups
  • Job-role simulation: Developing backup strategies for various environments
  1. 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
Week 3 (10 Hours): Multitenant Architecture and Real Application Clusters (RAC)
  1. 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
  1. Advanced Multitenancy Features (3 hours)
  • Resource management in a multitenant environment
  • Hands-on: Configuring resource allocation and isolation across PDBs
  • Enhancements in multitenancy from 12c through 23c
  1. 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
Week 4 (10 Hours): Performance Tuning and Optimization
  1. 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
  1. 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
Week 5 (10 Hours): Security, Compliance, and Auditing
  1. 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
  1. 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
  • Hands-on: Configuring comprehensive auditing and compliance settings
  1. 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
Week 6 (10 Hours): Migration, Upgrades, and AI/ML Features in 23c
  1. 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
  • Hands-on: Performing a simulated database upgrade and migration
  • Role-based task: Minimizing downtime and ensuring data integrity during migration
  1. 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
Capstone Project (10 Hours): Comprehensive Database Solution Implementation
  1. 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)
  • 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 –

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.

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

Enquire Now

    Why Radical Technologies

    Live Online Training

    Highly practical oriented training
    Installation of Software On your System
    24/7 Email and Phone Support
    100% Placement Assistance until you get placed
    Global Certification Preparation
    Trainer Student Interactive Portal
    Assignments and Projects Guided by Mentors
    And Many More Features
    Course completion certificate and Global Certifications are part of our all Master Program

    Live Classroom Training

    Weekend / Weekdays / Morning / Evening Batches
    80:20 Practical and Theory Ratio
    Real-life Case Studies
    Easy Coverup if you missed any sessions
    PSI | Kryterion | Redhat Test Centers
    Life Time Video Classroom Access ( coming soon )
    Resume Preparations and Mock Interviews
    And Many More Features
    Course completion certificate and Global Certifications are part of our all Master Program

    Self Paced Training

    Self Paced Learning
    Learn 300+ Courses at Your Own Time
    50000+ Satisfied Learners
    Course Completion Certificate
    Practical Labs Available
    Mentor Support Available
    Doubt Clearing Session Available
    Attend Our Virtual Job Fair
    10% Discounted Global Certification
    Course completion certificate and Global Certifications are part of our all Master Program

    Skills Covered

    • Database Architecture

    • Database Installation and Configuration

    • Database Creation and Management

    • Backup and Recovery (RMAN)

    • Oracle Networking (Listener, TNS, Oracle Net)

    • Database Security

    • Performance Tuning

    • Patching and Upgrades

    • Multitenant Architecture (12c and 19c)

    • Data Guard (High Availability)

    • Real Application Clusters (RAC)

    • Partitioning and Indexing

    • Scheduler and Job Automation

    • SQL and PL/SQL Programming

    • Database Cloning and Migration

    • Resource Manager

    • Data Pump (Import/Export)

    • Diagnosing and Troubleshooting

    tool covered

    Like the Curriculum ? Let's Get Started

    Why Enroll for Oracle DBA 11G + 12C + 19C Combo ?

    In-Demand Skills

    Boost your database management skills with our ORACLE DBA 11G + 12C + 19C Combo Course Training. Master essential tools, features, and techniques across three Oracle versions, preparing you for real-world challenges. Gain certification, enhance your resume, and accelerate your IT career. Enroll today for expert-led training!

    Career Opportunities

    Unlock diverse career opportunities with our ORACLE DBA 11G + 12C + 19C Combo Course Training. Become an expert in Oracle database management across three versions, boosting your job prospects in IT. Certification ensures a competitive edge in roles like DBA, consultant, and database architect. Enroll now!

    Cloud Adoption

    Accelerate cloud adoption with our ORACLE DBA 11G + 12C + 19C Combo Course Training. Master cloud-ready database management skills across multiple Oracle versions, preparing you for seamless cloud integration. Boost your career with certification and stay ahead in the evolving IT landscape. Enroll today!

    Scalability and Flexibility

    Achieve unmatched scalability and flexibility with our ORACLE DBA 11G + 12C + 19C Combo Course Training. Master database management for all environments, from small businesses to enterprise-level systems. Gain certification, boost your skills, and scale your IT career. Enroll today for flexible, expert-led training!

    Cost Management

    With our ORACLE DBA 11G + 12C + 19C Combo Course Training, you can maximize cost control. Learn to manage Oracle databases efficiently, reducing operational costs while boosting performance. Gain certification to advance your career and enhance your ability to manage resources effectively. Enroll today for expert guidance!

    Security and Compliance

    Ensure top-notch security and compliance with our ORACLE DBA 11G + 12C + 19C Combo Course Training. Learn to safeguard databases across multiple Oracle versions, meeting regulatory standards and protecting data. Get certified to enhance your expertise in security protocols. Enroll now and secure your future in IT!

    Course benefits

    • Comprehensive Knowledge Across Versions

    • Advanced Performance Tuning

    • Cloud-Ready Skills

    • High Availability and Disaster Recovery

    • Security Enhancements

    • Upgrade and Migration Expertise

    • Automation and Operational Efficiency

    • Career Growth and Certification Pathways

    • Troubleshooting Across Versions

    • Hands-On Labs and Real-World Scenarios

    Who Can Apply for Red Hat Linux

    Why Oracle DBA 11G + 12C + 19C Combo?

    Scalability

    Achieve seamless scalability with our ORACLE DBA 11G + 12C + 19C Combo Course Training. Master database solutions that grow with your business, from small to enterprise-level environments. Certification equips you with skills to manage expanding systems efficiently. Enroll today and future-proof your career in IT!

    Flexibility

    Unlock hybrid capabilities with our ORACLE DBA 11G + 12C + 19C Combo Course Training. Learn to seamlessly manage on-premise and cloud databases across multiple Oracle versions. Certification equips you with the skills to handle diverse infrastructures, boosting your IT career. Enroll today for a future-ready skillset!

    Hybrid Capabilities

    SAP FICO Course Training equips you with hybrid capabilities, blending on-premise and cloud solutions for seamless financial management. By enrolling, you'll master hybrid SAP FICO systems, enhancing adaptability in diverse environments. Get certified to unlock flexible, future-ready skills in finance today!

    Security and Compliance

    Ensure robust security and compliance with our ORACLE DBA 11G + 12C + 19C Combo Course Training.Master security protocols and regulatory standards across Oracle versions.Certification enhances your ability to protect data and meet compliance requirements,boosting your IT career. Enroll today for expert-led training!

    Cost-Effectiveness

    Maximize cost-effectiveness with our ORACLE DBA 11G + 12C + 19C Combo Course Training. Learn to manage multiple Oracle versions, optimizing performance while reducing operational costs. Certification boosts your skills, offering excellent value for career growth. Enroll today for affordable, expert-led training!

    Innovation

    Embrace innovation with our ORACLE DBA 11G + 12C + 19C Combo Course Training. Stay ahead in database management by mastering cutting-edge features across Oracle versions. Certification equips you with the latest skills, driving growth and success in your IT career. Enroll today to innovate and thrive!

    Global Certification

    • Oracle Database 11g Administrator Certified Associate (OCA)

    • Oracle Database 11g Administrator Certified Professional (OCP)

    • Oracle Database 12c Administrator Certified Associate (OCA)

    • Oracle Database 12c Administrator Certified Professional (OCP)

    • Oracle Database 12c Release 2 Certified Master (OCM)

    • Oracle Database 19c Administrator Certified Professional (OCP)

    • Oracle Certified Master, Oracle Database 19c Administrator (OCM)

    • Oracle Certified Specialist – Oracle Database 19c

    course certificate

    Red Hat Linux Fees in Bangalore

    Online Classroom PREFERRED

    16 jul

    TUE - FRI
    07.00AM TO 09.00
    AM LST (GMT +5:30)
    Radical

    20 jul

    SAT - SUN
    10.00AM TO 01.00
    PM LST (GMT +5:30)
    Radical

    20 jul

    SAT - SUN
    08.00PM TO 11.00
    PM LST (GMT +5:30)
    Radical

    ₹ 85,044

    Online Classroom PREFERRED

    Online

    01 Feb

    Weekend

    07:30 PM TO 08:30 PM IST (GMT +5:30)

    Online

    16 Feb

    Weekend

    11:00 AM TO 01:00 PM IST (GMT +5:30)

    Oracle Dba 11g 12c 19c Combo Training & Certification In Bangalore
    Highly Experienced Certified Trainer with 10+ yrs Exp. in Industry
    ENROLL NOW

    Discount Voucher

    "Register Now to Secure Your Spot in Our Featured Course !"

    BOOK HERE

    career services