KITS Online Training Institute provides best Oracle DBA 12c Online Training by our highly professional certified trainers. Database administrators (DBAs) use specialized software to store and organize data. Each database requires at least one database administrator (DBA) to administer it. Because an Oracle database system can be large and can have many users often this is not a one person job. In such cases, there is a group of DBAs who share responsibility. We are delighted to be one of the best leading IT online training with best experienced IT professionals and skilled resources. We have been offering courses to consultants, companies so that they can meet all the challenges in their respective technologies and  also we are offering other courses like Oracle SOA 12C.

Oracle DBA 12C Course Content


  1. Introduction
  • What is DBA?
  • Why a Company needs a DBA?
  • Roles & Responsibilities of DBA
  • Identify the oracle product
  • Oracle Architecture
  • Physical and Logical Phase of Database
  1. Installing oracle database 12c software
  • System requirements.
  • Redhat Linux Installation
  • Install software with the Oracle Universal Installer on Linux Platform
  • Identify System Requirements
  • Optimal Flexible Architecture (OFA)
  • Discuss Oracle Base
  • Discuss Oracle Home
  • Prerequisite Checks and Fixup Utility
  1. Container and Pluggable Database Architecture
  • Describe the multitenant architecture
  • Describe the root and pluggable database containers
  • Differentiate the root from a pluggable database
  • Explain pluggable database plugging
  • List impacts in various areas
  • Initialization Parameter Files
  • Starting Up Oracle Databases
  • Shutting Down Oracle Databases
  • Opening and Closing PDBs
  • Working with the Automatic Diagnostic Repository (ADR)
  • Querying Dynamic Performance Views
  1. CDB and PDB Creation
  • Methods and Tools to Create PDBs
  • Creating PDBs from Seed with SQL*Plus
  • Cloning PDBs with SQL*Plus
  • Unplugging and Pluggin In PDBs with SQL*Plus
  • Dropping PDBs with SQL*Plus
  • Configure and create a CDB, Create a PDB from PDB$SEED
  • Plug or clone a non-CDB into a CDB
  • Clone a local or remote PDB into a CDB
  • Unplug and plug a PDB from one CDB to another CDB
  • Explore the instance and structure of PDBs
  • Migrate a pre-12.1 non-CDB database to CDB
  1. Managing Tablespaces and Users in CDB and PDBs
  • How Table Data is Stored
  • Creating Tablespaces in SQL*Plus
  • Altering and Dropping Tablespaces in SQL*Plus
  • Viewing Tablespace Information in SQL*Plus
  • Implementing Oracle Managed Files
  • Moving and Renaming Online Data Files in SQL*Plus
  • Permanent & temporary tablespaces in CDB and PDBs
  1. Managing Storage Space
  • Oracle Database Space Management Features
  • Block Space Management
  • Row Chaining and Migration
  • Free Space Management Within Segments
  • Types of Segments
  • Allocating Extents
  • Understanding Deferred Segment Creation
  • Space-Saving Features
  1. Managing UNDO Data
  • Undo Data: Overview
  • Transactions and Undo Data
  • Storing Undo Information
  • Comparing Undo Data and Redo Data
  • Managing Undo
  • Local Undo Mode Versus Shared Undo Mode
  • Configuring Undo Retension
  • Categories of Undo
  1. Administering User Security
  • Creating Users
  • Granting Privileges
  • Creating and Granting Roles
  • Revoking Privileges and Roles
  • Creating and Assigning Profiles
  • Authenticating Users
  • Assigning Quotas to Users
  • Applying the Principal of Least Privilege
  • Common and local users, roles and privileges
  • 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
  1. Configuring the Oracle Network Environment
  • Oracle Net Services
  • How Listeners Work
  • Configuring Listeners for Dynamic Service Registration
  • Configuring Listeners for Static Service Registration
  • Configuring Local Naming for Connections
  • Testing Oracle Net Connectivity with tnsping
  • Configuring Communication Between Databases
  • Dedicated Versus Shared Server Configurations
  1. Moving Data (DATAPUMP)
  • Moving Data: General Architecture
  • Oracle Data Pump: Overview
  • Oracle Data Pump: Benefits
  • 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 Import Overview
  • Disabling Logging for Oracle Data Pump Import Usage
  • Disabling Logging for Oracle Data Pump Import 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
  1. Backup and Recovery Concepts
  • DBA Responsibilities
  • Categories of Failure
  • Understanding Instance Recovery
  • Understanding Types of Backups
  • Comparing Complete and Incomplete Recovery
  • Duplicating a Database ( Database Cloning )
  • Use Table Recovery
  • Backup and Recovery Concepts
  • Perform basic backup and recovery
  • Configure and manage RMAN settings, Configure FRA
  • Describe the use of the RMAN recovery catalog, Create Catalog
  • Register a database in the RMAN recovery catalog
  • Perform full and incremental backups
  • Configure Block Change tracking, Perform incremental level backups
  • Recover an incremental level 0 backup with level 1 incremental
  • Perform automated TSPITR, Perform table recovery from backups
  • Perform CDB and PDB backups
  • Recover CDB and PDB from essential file loss
  • 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
  1.  Using Flashback Technologies
  • Describe Flashback Database architecture
  • Understand flashback technologies from various types of errors
  • Configure your database to use flashback technologies
  • Perform flashback query, version query, transaction backout
  • Perform flashback table, recyclebin, flashback data archive
  1. Patching Activity
  • Database Patch Management Introduction
  • Applying Interim and Patch set Patches
  • Patch History & Documentation
  1. Monitoring and Tuning Database Performance
  • SQL Tuning Process
  • Oracle Optimizer
  • Optimizer Statistics
  • SQL Plan Directives
  • Adaptive Execution Plans
  • SQL Tuning Advisor
  • SQL Access Advisor
  • SQL Performance Analyzer
  • Managing Performance Activities
  • Performance Planning Considerations
  • Database Maintenance
  • Automatic Workload Repository (AWR)
  • Automatic Database Diagnostic Monitor
  • Performance Monitoring
  • Performance Tuning Methodology
  • Database Server Statistics and Metrics


Highlights of Oracle DBA 12C Online training:-

*  Very in depth course material with Real Time Scenarios for each topic with its Solutions for Oracle DBA 12C Online Trainings.

*  We Also provide Case studies  for Oracle DBA 12C Online Training.

*  We do Schedule the sessions based upon your comfort by our Highly Qualified Trainers and Real time Experts.

*  We provide you with your recorded session for further Reference.

* We also provide Normal Track, Fast Track and Weekend Batches also for Oracle DBA 12C Online Training.

* We also provide Cost Effective and Flexible Payment Schemes.

What is Oracle DBA?

Oracle DBA is the Relational Database management system. The main aim of Oracle DBA is data storing, managing and retrieve information efficiently and deliver with high performance. It is also called RDBMS.

Types of Oracle Users:

  • Database Administrators
  • Security Officers
  • Network Administrators
  • Application Developers
  • Application Administrators
  • Database Users

Database Administrators:

Database Administrator (DBAs) use the specialized software package to store and organize information. The role could embrace capability designing, installation, configuration, information style, migration, and performance observation, security, troubleshooting, additionally as backup and information recovery.

Each Database needs a minimum of one database administrator (DBA) to administer it. As a result of changes in Oracle DB system may be massive and might have several users, usually, this can be not a 1 person job. In such cases, there’s a bunch of DBAs Who share responsibility.

oracle dba 12c online training

What are the Features of Oracle 12C?

oracle dba 12c online training

What Are The Responsibilities Of A Database Administrator?

As the data center grows with the growth in business, so do the challenges. An administrator is faced with challenges that include:

  • Monitoring high levels of performance and availability of applications
  • Identifying and resolving problems quickly and effectively
  • Enabling IT professionals to use resources effectively, thereby reducing costs
  • Aligning IT with business priorities to ensure that businesses are agile enough to meet the changing needs

Why will we learn Oracle DBA?

 Oracle has maintained the lead in the industry with a large number of trend-setting products.

Some of the marquee areas in the Oracle Database 12c release are the following:

  • Private Database Cloud
  • Defense in Depth included Oracle Data Redaction, Real Application Security
  • Information Lifecycle Management (ILM), which includes hot/cold data classification, declarative compression and tiering, In-database Archiving and Valid-Time Temporal
  • Flex Clusters

What will we learn after completion of Oracle DBA Course?

  • Learn to install Oracle database/client binaries
  • Create Oracle databases.
  • Configure network
  • Query data using structured query language and perform DDL, DML and DCL operations
  • Configure backups and perform recovery using recovery manager
  • Work with a recovery catalog
  • Work with Oracle database parameters
  • Work with tablespaces, database objects etc.
  • Managing Users/Schemas
  • Managing profiles, roles, and grants
  • Learn how to work with RDBMS to store and retrieve data

What are the Prerequisites for Oracle DBA Training?

Our Experienced trainers will teach from basics, if you have a basic idea of Data warehousing concepts is an added advantage for this course.

Course Finished Certificate:

After finish, the course we provide Oracle DBA course finished certificate of kits technologies looks like

oracle dba 12C online training


Contact For More Information On Oracle DBA 12c Training      oracle dba 12c online training enquiry

Oracle DBA 12C Online Training Overall rating: ★★★★☆ 4.4 based on 438 reviews.
5 1

oracle dba 12c online training enquiry

Oracle DBA Video By Tahera

DBA Demo Video By Rupali

oracle dba 12c online training enquiry

Write A Review 

Review Title
Review Content

Abinitio Training

I Have joined for Course with Kits Technologies course.I am completely confident enough in my subject. I never thought Abinitio is SO BIG and huge!!!Loved learning it for about few week and quite happy now. Thanks Kits Team
- Ramesh


Sccm training done in a good way
- Phani

Oracle DBA Online Training

I have completed AWS Online Training From KITS Online Trainings. my trainer such a knowledgeable person. He taught a concepts easy and understandable manner. I am getting day by day update and easy understanding. Thank for the wonderful opportunity
- John

Best Training Instittue

Very nice material and course video available for your reference anytime. I repeatedly watched videos to learn required knowledge. Anyone would definitely miss out the physical presence inside the class while attending the course . I had lot of disturbance at home while class was going on and it didn't give me any seriousness about subject as I didn't see anyone looking at me if I am listening! This factor, someone is looking at me would definitely make me concentrate subject. Also 4 (four) hours of coaching online and very less interaction with people around makes very less impressive learning
- Rajesh

My Favourite Training Instittue

My learning with KITS Online Trainings was Golden Gate and SAP Basis training and exam preparation It’s been a worthwhile learning experience - the course was easier to understand than and helped memory retention. Also the online support team were so kind and helpful-when i ran out of time and my exam was a month away they extended my access for extra 30 days. Success all the way
- mandeep

sql server dba

I am Srinivas bolla. I took SQL Database Administrator Online training in Kits online trainings. actually I don’t have knowledge about IT sector, When I was approach Kits online trainings. They gave me well support and training. I learnt a lot from them very well experienced faculty.. very much satisfied for the training. I am happy to say my topics are very clear now. I have no doubt about SQL DBA am very thankful to the whole team of Kits online trainings for providing a Excellent training..
- Srinivas

Other Related Courses