Live online batches across IST, EST & GST — learners in 189+ countries
+91 769-409-5404
Home› Courses› Oracle› Oracle 12c DBA
Oracle Upskill with BISP Powered By AI

Oracle 12c DBA

In this new course, students will learn about the new and enhanced features and options of Oracle Database 12c. Expert instructors will teach you how these features and options increase security, manageability, and performance. In this cou…

4.8  ·  Rated by learners Certificate of completion
Duration
30 Hours
Mode
Live + Recorded
Level
Beginner → Pro
Language
English / Hindi

AI practice, included with this course

Rehearse the interview and test yourself before the real thing.

AI powered

AI mock interview

Answer role-based questions out loud, then read the report on how you did. Five attempts come with the course.

Unlocked on enrolFree5 AI mock interviewsEach one scored, with a written report you can actually act on.Included in the course fee

AI MCQ assessment

A fresh 40-question assessment is written each time you start — 200 questions across the module, with the reasoning behind every answer.

Unlocked on enrolFree5 practice assessments40 questions each, 200 across the module — every answer explained.Included in the course fee

Scores and reports

Every attempt is kept in your dashboard, so you can see which topics improved and which still need work.

Unlocked on enrolFreeYour progress, trackedEvery attempt kept, so you can see exactly what improved.Yours from day one
Available in your student dashboard as soon as you enrol — no extra charge, nothing to install.

Course overview

About the Oracle 12c DBA program.

In this new course, students will learn about the new and enhanced features and options of Oracle Database 12c. Expert instructors will teach you how these features and options increase security, manageability, and performance. In this course, you will be introduced to the Oracle Database Cloud Service. It will train DBA’s how Oracle12c Optimize database workloads, lower IT costs and deliver a higher quality of service by enabling consolidation onto database clouds.

Why learn with BISP

Trusted by professionals across 30+ countries.

Industry trainers

Certified consultants with 12+ years of real project experience.

Hands-on practice

Real-time scenarios & live project modules, not just slides.

Placement support

Resume building, mock interviews & job referrals.

Certification

BISP certificate + full guidance for official exams.

Course curriculum

Designed by real-time industry professionals around current job roles.

Download curriculum (PDF)
11 modules 81 topics
01 What you learn: 15 topics
  • Understanding Multitenant Architecture
  • Configuring Containers and Pluggable Databases
  • Managing Storage Structure
  • Using New Oracle 12c RMAN features
  • Backups of CDBs and PDBs
  • Manage the Oracle multitenant container databases and pluggable databases.
  • Configure the Heat Map and use Automatic Data Optimization.
  • Online Datafile Movement
  • Understand the new Temporal capabilities as well as In-Database Archiving with Row-archival.
  • Enforce security with the Unified Auditing, the new administrative privileges, Privilege Analysis, and Data Redaction.
  • Database In-Memory option, and Full Database In-Memory Caching and the Automatic Big Table Caching features.
  • Benefit from optimizer enhancements such as Adaptive Execution Plans and SQL Plan Directives, Real-Time ADDM and Compare Period ADDM.
  • Use enhanced features of Resource Manager in multitenant container databases and pluggable databases.
  • Understand how and when to use enhancements in Data Pump, partitioning, and SQL.
  • Gain an understanding of the Oracle Database Cloud Service.
02 Architecture Overview 9 topics
  • Overview of Oracle Database 12c
  • Oracle Database Instance Configurations
  • Connecting to the Oracle Database Instance
  • Oracle Database Memory Structures and Process Architecture
  • Database Storage Architecture
  • Basics and Advantages of Multitenant Architecture
  • Pluggable databases and container databases
  • Difference between 11g and 12c
  • Dictionary Views 12c (CDB_XXX, DBA_XXX, ALL_XXX etc.)
03 Installation and Database Creation 8 topics
  • 12c Installation
  • Database Creation using DBCA (CDB and PDB)
  • Configuration and creation of CDB
  • Create a PDB from a non-CDB
  • Create a new PDB from PDB$SEED
  • Cloning of PDB
  • PDB Snapshot Clone
  • View the Alert Log File
04 Startup and Shutdown of Database 7 topics
  • Start up a CDB
  • Describe the stages of database startup
  • Open / Close a PDB (SQL*Plus)
  • Shut down a CDB
  • Change PDB state
  • Shutdown Types
  • Alert Log Files and Trace files
05 Configuring the Oracle Network Environment 3 topics
  • Use Enterprise Manager to create and configure the Listener
  • Use testing to test Oracle Net connectivity
  • Identify when to use shared servers and when to use dedicated servers
06 Managing Data Concurrency 3 topics
  • Data ConcurrencyEnqueue Mechanism
  • Resolving Lock Conflicts
  • Deadlocks
07 Managing Tablespaces, Common and Local Users, Privileges, and Roles 5 topics
  • Create permanent tablespaces in the root and PDBs
  • Roles and Privileges (dba_sys_privs and dba_tab_privs)
  • Manage common and local schemas and users in the root and PDBs
  • Manage system and object privileges to common and local grantees granted
  • Manage common and local roles granted commonly or locally
08 Backup & Recovery in Multitenant Databases 11 topics
  • Backups
  • Recovery
  • Handling redo log failures
  • Control File recovery
  • Recovery use cases
  • Point In Time Recovery
  • Using the RMAN Recovery Catalog
  • Tracking and Storing Backup Information
  • Setting up a Recovery Catalog
  • Backup and Recovery Reporting
  • Restoring from Autobackup: Server Parameter File and Control File
09 Moving Data 4 topics
  • Describe ways to move data
  • Create and use directory objects
  • The general architecture of Oracle Data Pump
  • Use Data Pump export and import to move data
10 Using Flashback Technology 7 topics
  • Flashback Technology: Overview and Setup
  • Using Flashback Technology to Query Data
  • Flashback Table
  • Flashback Transaction Query
  • Flashback Drop and the Recycle Bin
  • Configuring Flashback Database
  • Performing Flashback Database Operations
11 Performance Tuning 9 topics
  • Tuning Basics
  • Wait for Events, Class, and Statistics
  • System Statistics Dictionary Views
  • Invalid and Unusable Objects
  • Index Scans and Type of Index Scans
  • Parallelism and parallel_degree_policy
  • Statistics and Histograms
  • Cursor Sharing and Bing Peeking
  • AWR and ADDM reports

Course details

Who it is for, what you need, and how it is delivered.

Who should learn Oracle 12c DBA?

• Database Administrator worked on 9i/10g or 11g • Systems Administrator • Oracle Certified Associates or Oracle Certified Professionals (OCA or OCP)

Prerequisites

Basic knowledge of database.

Delivery methodology

We are using an experiential delivering methodology that blends theoretical concepts with hands-on practical learning to ensure a holistic understanding of the subject or course.

Class delivery

Live Interactive classes with expert

Certificate of completion

Earn an industry-recognised BISP Trainings certificate when you finish the course.

BISP Trainings Certificate of Completion
  • Verifiable certificate with a unique ID
  • Shareable on LinkedIn & your resume
  • Recognised by our hiring partners

Frequently asked questions

Everything you need before you enroll.

Can I attend a demo session before enrollment?

Yes. You may attend a demo class before enrollment for training quality evaluation, and interact one-to-one with the trainer for any specific requirement.

Can you schedule training as per my availability?

Yes. We discuss it with the trainer and schedule the training at a convenient time for you.

What if I miss a class?

You get the recorded session. You may also retake the whole training multiple times within a 6-month period with the same trainer.

Is there live project training?

Yes. The curriculum includes real-time scenarios and live project modules, with the trainer explaining every topic end-to-end.

How can I pay for the course?

Enroll securely via the payment gateway on this page using card, UPI or net-banking. EMI options are available.

More queries?

Call us at +91 769-409-5404 & +1 678-701-4914, or write to support@bisptrainings.com.

Case studies & learning PDFs

Free Oracle resources to explore.

PDFAn Overview of Oracle Hyperion Planning PDFBasics of Hyperion Essbase PDFBUILDING FINANCIAL DATA MODEL_ODI 11g CASE STUDY PDFBuilding Financial Report and Dashboard Using OBIEE-Guide PDFCalculating the Tax Inclusive Amount for income and expense_Case Study PDFCalculating the Tax Inclusive Amount for income and expense-Essbase case study

Relevant courses

Learners who took this also explored these.

Oracle Fundamentals and PL SQL for beginners

Oracle Fundamentals and PL SQL for beginners

₹25,000View →
Oracle 12c Administration

Oracle 12c Administration

₹25,000View →
Oracle SQL Ad Training

Oracle SQL Ad Training

₹25,000View →

Not sure if this course is right for you?

Book a free 1-on-1 counselling call and get a personalised learning roadmap.

Book free trial →