Oracle Database Administrator Certification Training

Oracle Database Administrator Certification Training

Course Duration : 30 Hours
Certification : Yes
Assignments : Yes
Interview Questions : Yes
Resume Preparation : Yes

Oracle dba Administration is performing several important tasks planning, design, implementation, operations of a Database. Thus the role of the administration is important of the Oracle dba. HKR Trainings providing you oracle database administration certification training to make expert in dba administration. you will create a master path in administration database career.

Upcoming Batch for Instructor-led Oracle Database Administrator Certification Training

Set your convenient time for this training; choose from different modes of training Call/Email Now!

Training Content


Understanding the database development lifecycle Construct database queries using SQL
Design databases by based on techniques of modeling and normalization
Learning techniques, which is required for data security, privacy, fraud detection and backup and recovery


Who Should Attend

• Software developers • Tech leads • Programmers • Consultants • Database administrators • System analysts


Prerequisites For Oracle Database Administrator Certification Training

• Knowledge of Linux operating system • Understanding of relational database concepts • Knowing of SQL language

Curriculum for Oracle Database Administrator Certification Training

Oracle Database 12c New and Enhanced Features Objectives
Oracle Database in 11g Release
High-Performance Systems

New Multitenant Architecture: Benefits Other Benefits of Multitenant Architecture
Multitenant Container Database
Separating SYSTEM and User Data
Naming the Containers
Provisioning a Pluggable Database
Basics of Multitenant Container Database and Pluggable Databases
Interacting Within Multitenant Container Database
Exploring CDB Architecture and Structures

Steps to Create a Multitenant Container Database Creating a Multitenant Container Database Using SQL*Plus
Exploring CDB and PDB Structures
Create New PDB from PDB
Cloning PDB within the Same CDB
Plugging a Non-CDB into a CDB
Dropping a PDB (optional)
Plug Unplugged PDB in to CDB

Starting Up a CDB Instance Mounting a CDB
Opening a CDB
Opening a PDB
Closing a PDB
Shutting Down a CDB Instance
Creating after Startup Trigger to Open All PDBs
Changing PDB Mode
Changing PDB Mode with SQL Developer
Instance Parameter Changes and its Impact on PDBs

Creating Permanent Tablespaces in a CDB Assigning Default Tablespaces
Creating Local Temporary Tablespaces
Assigning Default Temporary Tablespaces
Users, Roles, and Privileges
Local Users, Roles, and Privileges
Creating a Local User
Common Users
Creating a Common User
Common and Local Schemas / Users
Common and Local Privileges
Granting and Revoking Privileges
Creating Common and Local Roles
Granting usual or Local Privileges / Roles to Roles
Granting usual and Local Roles to Users
Granting and Revoking Roles
Creating Shared and Non-Shared Objects

Whole CDB Backup User-Managed Hot CDB Backup
Partial CDB Backup
Whole PDB Backup
Partial PDB Backup
SQL PDB Hot Backup (optional)
SQL Control File Backup (optional)

Media Failure: CDB or PDB Temp File Recovery Media Failure: PDB Temp File Recovery
Media Failure: Control File Loss
Media Failure: Redo Log File Loss
Media Failure: Root SYSTEM or UNDO Data File
Media Failure: Root SYSAUX Data File
Media Failure: PDB SYSTEM Data File
Media Failure: PDB Non-SYSTEM Data File
Media Failure: PITR Flashback CDB Special Situations Creating a control file backup script

Enabling Heat Map. Automatic Data Optimization – Creating a TIER Policy
Automatic Data Optimization – Creating a COMPRESS Policy
Cleanup ADO Policies and Heat Map Statistics
Moving Data File Online
In-Database Archiving and Temporal Validity
Archiving Challenges
Archiving Solutions
In-Database Archiving: HCC
Archiving Challenges and Solutions
In-Database Archiving
Session Visibility Control
Disable Row-Archival
PERIOD FOR Clause Concept
Filtering on Valid-Time Columns

Types of Auditing Audit Trail Implementation
Oracle Database 12c Auditing
Enabling Unified Auditing
Auditing Data Pump Export
Auditing RMAN Backups
Unified Audit Implementation
Security Roles
Security SYS Auditing 9-21
Simplicity Audit Policy 9-22
Creating the Audit Policy
Creating the Audit Policy with Object-Specific Actions

New Administrative Privileges New Administrative Privilege SYSBACKUP
New Administrative Privilege SYSDG
New Administrative Privilege SYSKM
OS Authentication and OS Groups
Password Authentication for SYSBACKUP
Password Authentication for SYSDG
New System Privilege PURGE DBA_RECYCLEBIN 10-19
Creating Policies Database and Role Analysis
Creating Policies Context Analysis
Analyzing and Reporting
SYSTEM and OBJECT Used Privileges
Used Privileges Results
Compare Used and Unused Privileges

Full Transportable Export/Import Overview Full Transportable Export/Import Usage
Full Transportable Export/Import Example
Plugging a Non-CDB into CDB Using Data Pump
Plugging a Non-CDB into CDB Using Replication
Transporting a Database over the Network Example
Disabling Logging for Oracle Data Pump bring in Overview
Disabling Logging for Oracle Data Pump Import Usage
Disabling Logging for Oracle Data Pump bring in Command-Line Examples
Exporting Views as Tables Overview
Exporting Views as Tables Usage
Exporting Views as Tables Command-Line Examples
Specifying the Encryption Password
Compressing Tables during Import
SQL*Loader and External Table Enhancements

Backing Up and Restoring Very Large Files RMAN Duplication Enhancements
Duplicating an Active Database
What Is New?
The NOOPEN Option
Duplicating Pluggable Databases
Recovering Databases with Third-Party Snapshots
Transporting Data across Platforms
Data Transport
Transporting Database Process Steps
Transporting Tablespace Process Steps
Table Recovery
Recovering Tables from Backups
Specifying the Recovery Point-in-Time
Process Steps of Table Recovery

Standby Databases Far Sync Instances
Oracle Data Guard Services
Configuration of Far sync Instance
Supported protection modes for Far sync instances
Configuring Redo Transport services
Cascading redo transport destinations
Cascading Physical standby database
Cascading multiple Physical standby's
Apply services
Data guardUpgrade using SQL apply
Oracle Datagurad Scenario's
Downgrading database in Data guard Configuration
Creating standby using rman

Modes of Training

Self Paced
Self Paced
Get previous live recorded training videos access and learn.
Fast Track
Fast Track
Start and Complete training in fast mode and implement.
Get training only on weekends as per your convenient.
Instructor LED Live Training.
Instructor LED Live Training
Get live training with real time expert.
Corporate Training
Corporate Training
Get training for your employees for new skills.
One-One Training
One-One Training
Don’t like to get training in a batch get specialised 1-1 training.

Trainings Features

Instructor LED Sessions
Instructor LED Sessions
Get Live Instructor LED interactive Sessions.
Total training will be followed by practical assignments for practical understanding.
Lifetime access
Lifetime access
We give a life time access to the recorded videos of your training.
After Completion of training you will receive a course completion certificate from HKR Trainings.
Convenient Timing
Convenient Timing
3Select convenient timing to get trained.
Real time Examples
Real time Examples
While training in progress get real time scenarios with examples for clear understanding.


Each and every class is recorded so if you missed any class you can review the recordings and clarify any doubts with the trainer in next class.

Yes, we don’t assure 100% placement assistance. We are tied up with some corporate companies so when they have a requirement we send your profiles to them.

Yes, we provide demo before starting any training in which you can clear all your doubts before starting training.

Our trainers are real time experts who are presently working on particular platform on which they are providing training.

You can call our customer care 24/7

Max of the students get satisfied with our training, if you are not then we provide a specialised training in return.


Clients Reviews

Certification Process

After Completion of training you will receive a course completion certificate from HKR Trainings which adds a value to your carrier and this is the entry to build a carrier with this certificate.