uncategorised

★★★★★

(2,095 ratings) 50,000+ Student

ORACLE DBA 12C UPGRADE TRAINING IN BANGALORE

Oracle Database 12c includes exciting new features such as the Oracle Multitenant option, Oracle Active Data Guard Far Sync, information lifecycle management enhancements and new data types just to name a few. Customers wishing to take advantage of these and other new features will often need to upgrade their existing databases from older versions to Oracle Database 12c.

Radical Technologies

50,000+ English 10 weeks Weekdays / Weekends Classroom / Online / Corporate

Online / Classroom

ORACLE DBA 12C UPGRADE TRAINING IN BANGALORE

IT Training Programme

Duration 10 weeks

Batch Type Weekdays / Weekends

Mode of Training Classroom / Online / Corporate

Locations Pune, Bangalore, Kochi

Language English

Certification Globally Recognized

Call Now

100% placement assistance

Enquire Now

Get course fees, batch dates & a callback

We never share your details.

What you'll learn

Understand core concepts and architecture from the ground up

Get hands-on with the tools used by working professionals

Build real-world projects you can add to your portfolio

Learn industry best practices and coding standards

Practice with real datasets and real-world scenarios

Prepare for certification and technical interviews

Work on collaborative, team-based exercises

Apply performance tuning and optimization techniques

Understand how the technology fits into a larger ecosystem

Complete assignments reviewed by mentors

Programme Overview

16 sections covering the complete curriculum — a single, progressive learning arc.

10 weeks

Training Duration

Core Modules

176

Total Lessons

4.6★

Average Rating

50K+

Students Trained

Foundations & Core Concepts

Get hands-on with the fundamentals and architecture — the building blocks for everything that follows.

Fundamentals Architecture Setup

Hands-On Practical Training

Work through real exercises and assignments designed to mirror what you will do on the job.

Practicals Assignments Labs

Real-World Projects

Apply what you have learned to end-to-end projects that go straight into your portfolio.

Projects Portfolio Case Studies

Advanced Techniques

Go beyond the basics with advanced concepts, integrations and production-grade practices.

Advanced Integration Best Practices

Ecosystem Integration

Understand how this technology connects with the broader tools and platforms used in the industry.

Ecosystem Tools Platforms

Performance & Interview Prep

Master optimization techniques and prepare for the technical interview questions employers actually ask.

Optimization Interview Prep Certification

Who is this programme for?

Whether you're already writing code, working with data, or supporting applications today — this programme is built to take you into a uncategorised role.

Software Developers

Engineers who want to add this skill set to their toolkit

Analysts & Consultants

Professionals moving into a more technical, hands-on role

IT Professionals

System admins and support engineers upskilling into a new domain

Fresh Graduates

CS/IT graduates aiming for a job-ready technical role

Course Curriculum

16 sections • 176 lessons • 10 weeks

Jump to Section

Total Duration

10 weeks

100% Practical · Unlimited Doubt Sessions

01 Basics of Multitenant Container Database (CDB) / Configuring and Creating CDB and PDBs

Basics of Multitenant Container Database (CDB)

Benefits of the multitenant architecture

Differences between the root container and pluggable database containers

Structure of the root

Structure of Pluggable Database (PDB)

CDB_xxx and DBA_xxx views

Impacts in Security, Data Guard, Oracle GoldenGate, Oracle Streams, XStream, and Scheduler

Configuring and Creating CDB and PDBs

Tools: DBCA and SQL*Plus

Configuration and creation of CDB

Exploring the Structure (CDB_xxx views and EM)

Tools used: SQL Developer, DBCA and SQL*Plus and EM Database Express

Create a new PDB from PDB$SEED

Create a PDB from a non-CDB

Clone a PDB into the same CDB or into another CDB using DB links

Plug in an unplugged PDB

02 Managing CDB and PDBs / Managing Tablespaces, Common and Local Users, Privileges and Roles

Managing CDB and PDBs

Connect to CDB as administrator

Connect to a PDB using a service name

Start up a CDB

Open / Close a PDB (SQL*Plus, srvctl, EM)

Open / Close all PDBs

Shut down a CDB

Preserve or discard the PDBs open mode when the CDB restarts

Change PDB state

Managing Tablespaces, Common and Local Users, Privileges and Roles

Create permanent tablespaces in the root and PDBs

Manage common and local schemas and users in the root and PDBs

Manage system and object privileges to common and local grantees granted “commonly” or “locally”

Manage common and local roles granted “commonly” or “locally”

03 Managing Backup/Recovery/Flashback / Online Datafile Move and Automatic Data Optimization

Managing Backup/Recovery/Flashback

Backup a whole CDB

Backup a PDB

Recover CDB from redo log files, control files, undo datafiles loss

Recover PDB from PDB datafiles loss

Flashback at CDB level

Explain the two methods of migration

Online Datafile Move and Automatic Data Optimization

Data classification in 12c : tablespace, group, object, row levels

Configure heat map

Automatic movement and compression

Compression levels and types

Policy declaration: simple declarative SQL extension

Customized automated action execution with user-defined function

Execution in scheduled maintenance windows and by MMON

Customized schedule with DBMS_ILM package

04 In-Database Archiving / Auditing Enhancements

In-Database Archiving

Challenges of old data in tables and 11g solutions

In-database archiving new solutions

Use ROW ARCHIVAL clause to enable row lifecycle state for applications

Set ROW ARCHIVAL VISIBILITY for session level visibility control

Use predicate on ORA_ARCHIVE_STATE column

Temporal Validity versus Temporal History (Transaction Time of FDA)

New clause of CREATE / ALTER TABLE to set a Temporal Validity: PERIOD FOR

New SQL temporal data type

Auditing Enhancements

Review of 11g R2 audit trail implementation

Overview of the Unified Audit Trail

Enabling the Unified Audit Trail

Creating a separate tablespace for the unified audit trail

Granting the AUDIT_ADMIN role to a user for audit trail configuration and management

Configuring the Unified Audit Trail to set a tolerance level for loss of audit records

Creating audit policies

05 Privileges Enhancements / Oracle Data Redaction

Privileges Enhancements

Implementing Separation of Duty for Database Administration Tasks

Using Database Privilege Analysis

Overview of Database Privilege Analysis

Granting the CAPTURE_ADMIN role to enable management of privilege captures

Creating and starting/stopping privilege captures

Viewing privilege profile data

Querying DBA_PRIV_CAPTURES

Explaining the purpose of the default ORA$DEPENDENCY profile

Oracle Data Redaction

Overview of Oracle Data Redaction

Types of Masking Policies

Administering the EXEMPT REDACTION POLICY system privilege to enable a user to view unmasked values

Managing Masking Policies

Best practices for defining policy expressions

Understanding Masking of Statements Containing Subqueries

Viewing Information About Masking Policies by Querying REDACTION_POLICIES and REDACTION_COLUMNS

06 General RMAN New Features and FDA Enhancements / Monitoring DB Operations

General RMAN New Features and FDA Enhancements

Making Database Connections With RMAN

Using the SYSBACKUP Privilege

Using SQL, DESCRIBE Command, Duplication Operation with the NOOPEN option

Backing up and Restoring Very Large Files

Creating Multisection Backups

Transporting Data Across Platforms

Prerequisites and Limitations

Transporting Data: Processing steps

Monitoring DB Operations

Overview

Use cases

Current Tools

Define a DB operation

Monitoring: Bracketing an Operation

Monitoring the Progress of Operations

DB Operation Tuning

DB Operation Active Report

07 Real-Time ADDM and Compare Period Advisor / ADR and Network Enhancements

Real-Time ADDM and Compare Period Advisor

Emergency Monitoring

Real time ADDM

Use cases

Goals

Define Workload dimensions

Reported items

Root Causes

Requirements for a report

ADR and Network Enhancements

ADR file types

New File types

New File locations

New command for ADRCI

Improve performance by Compression

Setup Compression

08 In-Memory Column Store / In-Memory Caching

In-Memory Column Store

In-Memory Database option goals and benefits

Row format and columnar format

New SGA component:

IMCU synchronization

Deployment and behaviors

Compression ratio

New dictionary tables and added columns

New statistics: IM %

In-Memory Caching

Setting up Full Database In-Memory Caching

Using Full Database In-Memory Caching

Explaining the two buffer replacement algorithms of Automatic Big Table Caching

Configuring Automatic Big Table Caching with PARALLEL_DEGREE_POLICY and DB_BIG_TABLE_CACHE_PERCENT_TARGET initialization parameters

Using Automatic Big Table Caching

09 SQL Tuning / Resource Manager and Other Performance Enhancements

SQL Tuning

Adaptive Execution Plans

SQL Plan Directives

Statistics Gathering Performance Improvements

Histogram Enhancements

Enhancements to Extended Statistics

Adaptive SQL Plan Management

Resource Manager and Other Performance Enhancements

Manage resources between PDBs

Manage resources within a PDB

Manage resources with CDB and PDBs plans

Manage runaway queries

Control the in-memory database repopulation resource consumption

Automated maintenance tasks

Current Architecture: Unix multiprocess / one thread, NT/Windows one process / multithread

New Architecture: Multiprocess / MultiThread

10 Index and Table Enhancements

Multiple indexes on the same set of columns as long as some characteristic is different

Create table with INVISIBLE columns

Support for invisible columns

Describe online redefinition supports

Explain LOCK timeout during FINISH_REDEF_TABLE

Describe the Advanced Row Compression

Using the following DDL statements in an online manner

11 L1 Tasks

1. Basic user account management (creating, modifying, and deleting users).

2. Password resets and account unlocks.

3. Basic file system navigation and management (creating, deleting, and modifying files and directories).

4. Basic troubleshooting of network connectivity issues.

5. Basic software installation and package management (installing and updating software packages).

6. Viewing system logs and checking for errors or warnings.

7. Running basic system health checks (CPU, memory, disk space).

8. Restarting services or daemons.

9. Monitoring system performance using basic tools (top, df, free).

10. Running basic commands to gather system information (uname, hostname, ifconfig).

12 L2 Tasks

1. Intermediate user account management (setting permissions, managing groups).

2. Configuring network interfaces and troubleshooting network connectivity issues.

3. Managing file system permissions and access control lists (ACLs).

4. Performing backups and restores of files and directories.

5. Installing and configuring system monitoring tools (Nagios, Zabbix).

6. Analyzing system logs for troubleshooting purposes.

7. Configuring and managing software repositories.

8. Configuring and managing system services (systemd, init.d).

9. Performing system updates and patch management.

10. Monitoring and managing system resources (CPU, memory, disk I/O).

13 L3 Tasks

1. Advanced user account management (LDAP integration, single sign-on).

2. Configuring and managing network services (DNS, DHCP, LDAP).

3. Configuring and managing storage solutions (RAID, LVM, NFS).

4. Implementing and managing security policies (firewall rules, SELinux).

5. Implementing and managing system backups and disaster recovery plans.

6. Configuring and managing virtualization platforms (KVM, VMware).

7. Performance tuning and optimization of system resources.

8. Implementing and managing high availability solutions (clustering, load balancing).

9. Automating system administration tasks using scripting (Bash, Python).

10. Managing system configurations using configuration management tools (Ansible, Puppet).

14 L1-L2 Transition Tasks

1. Learning basic shell scripting for automation tasks. 2. Understanding file system permissions and ownership. 3. Learning basic networking concepts (IP addressing, routing). 4. Learning how to use package management tools effectively. 5. Familiarizing with common Linux commands and utilities. 6. Understanding basic system architecture and components. 7. Learning basic troubleshooting techniques and methodologies. 8. Familiarizing with basic security principles and best practices. 9. Learning how to interpret system logs and diagnostic output. 10. Understanding the role and importance of system backups and restores.

15 L2-L3 Transition Tasks

1. Advanced scripting and automation techniques (error handling, loops).

2. Understanding advanced networking concepts (VLANs, subnetting).

3. Familiarizing with advanced storage technologies (SAN, NAS).

4. Learning advanced security concepts and techniques (encryption, PKI).

5. Understanding advanced system performance tuning techniques.

6. Learning advanced troubleshooting methodologies (root cause analysis).

7. Implementing and managing virtualization and cloud technologies.

8. Configuring and managing advanced network services (VPN, IDS/IPS).

9. Implementing and managing containerization technologies (Docker, Kubernetes).

10. Understanding enterprise-level IT governance and compliance requirements.

16 L3 Tasks and Beyond

1. Designing and implementing complex IT infrastructure solutions. 2. Architecting and implementing highly available and scalable systems. 3. Developing and implementing disaster recovery and business continuity plans. 4. Conducting security audits and vulnerability assessments. 5. Implementing and managing advanced monitoring and alerting systems. 6. Developing custom automation solutions tailored to specific business needs. 7. Providing leadership and mentorship to junior team members. 8. Collaborating with other IT teams on cross-functional projects. 9. Evaluating new technologies and making recommendations for adoption. 10. Participating in industry conferences, workshops, and training programs.

Tools & Technologies

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

Core Tools

Hands-On Labs

Practical Environment

Industry-Standard Tools

Real-World Setup

Guided Exercises

Skill Building

Sample Datasets

Practice Material

Practice & Projects

Mini Projects

Applied Practice

Assignments

Mentor Reviewed

Doubt Sessions

Live Support

Career Readiness

Resume Building

Career Support

Mock Interviews

Interview Prep

Certification Prep

Global Recognition

Deployment & Delivery

Production Practices

Real-World Ready

Best Practices

Industry Standards

176+

Hands-On Lessons

Core Modules

10 weeks

Training Duration

100%

Practical Training

You don't just learn ORACLE DBA 12C UPGRADE TRAINING IN BANGALORE. You ship it.

Three major projects, each mirroring how production teams actually work — from guided foundations to a portfolio-ready capstone.

PROJECT // 01

Guided Foundation Project

→Requirement Analysis

→Guided Implementation

→Mentor Review

→Iteration

Foundation Beginner

Apply the fundamentals in a structured, mentor-reviewed project

Take the core concepts from the first half of the curriculum and apply them to a realistic scenario, with guidance and feedback from your mentor at every step.

Structured project brief

Step-by-step implementation

Mentor feedback and review

Documented outcome

Stack Core Concepts Best Practices

PROJECT // 02

Applied Practice Project

→Scenario Design

→Independent Build

→Testing & Validation

→Peer Review

Applied Intermediate

Build a more independent project mirroring real production scenarios

Work through a project that combines multiple concepts from the curriculum, closer to how work is actually structured on the job — less hand-holding, more ownership.

End-to-end implementation

Testing and validation

Documentation

Peer/mentor review

Stack Applied Skills Testing

PROJECT // 03

Capstone Project

→Planning

→End-to-End Build

→Review & Refinement

→Presentation

Capstone Advanced

Take a project from requirements to a polished, portfolio-ready deliverable

Your final project — plan, build, test and present a complete solution using everything covered in the curriculum, reviewed by mentors before you graduate.

Complete working solution

Presentation-ready documentation

Mentor sign-off

Portfolio-ready deliverable

Stack Full Curriculum Portfolio

All 3 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

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 Bangalore, 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.