Oracle DBA Course Overview

MindMajix’s Oracle DBA training is designed to grow your skills and ability to leverage all the Oracle DBA opportunities in the industry.  Our best in-field instructors offer practical guidance and real-world expertise needed to become a successful Oracle Database Administrator. From the fundamentals to advanced features, you'll explore everything you need to know about Oracle database versions 12c or 19c, including development, management, security, high availability, and data warehousing. Sign up for this online interactive Oracle DBA online course to sharpen your skills, increase your job security, and stand out at the workplace. You can enroll for the Oracle DBA Course in either Previous version 12C or New version 19C.

Oracle DBA Training
demo play

Course Coverage

Course Includes

Live Training

50 Hours of Sessions

Lab Sessions

30 Hours of Labs

Flexible Schedule

Flexible Schedules

FREE Demo on Request

FREE Demo on Request

24/7 Lifetime Support

24/7 Lifetime Support

One-on-One Doubt Clearing Sessions

One-on-One Doubt Clearing

Certification Assistance

Certification Oriented Curriculum

Two Real-time Project Use cases

Real-time Project Use cases

Request for more information

Oracle DBA Course Content

Our subject matter experts developed the curriculum for this Oracle DBA 12c / 19c course to delve in-depth while meeting the industry benchmarks. Whether you're a novice or an experienced person interested in learning more, our step-by-step course modules are designed in such a that helps you get a better understanding of Administering the Oracle Database.

Note: You can register for either the 19c version or the 12c version separately.

Oracle DBA 12C Curriculum

Duration: 50 Hours

1. Introduction to Oracle Database Administrator

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

2. Basics of Multi Container Database and Pluggable Databases

  • 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

3. Creating a Multi Container Database and Pluggable Databases

  • 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$SEED
  • With FILE_NAME_CONVERT
  • Without FILE_NAME_CONVERT
  • Cloning PDB within the Same CDB
  • Plugging a Non-CDB into a CDB
  • Dropping a PDB (optional)
  • Plug Unplugged PDB in to CDB

4. Managing Multi Container Databases and Pluggable Databases

  • 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

5. Managing Tablespaces and Users in CDB and 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 Common or Local Privileges / Roles to Roles
  • Granting Common and Local Roles to Users
  • Granting and Revoking Roles 
  • Creating Shared and Non-Shared Objects

6. Backup, Recovery, Flashback CDB and PDBs

  • 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)

    Activities

  • 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

7. Heat Map, Automatic Data Optimization and Online Datafile Move

  • 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 
  • ORA_ARCHIVE_STATE column 
  • Session Visibility Control 
  • Disable Row-Archival 
  • PERIOD FOR Clause Concept 
  • Filtering on Valid-Time Columns

8. Auditing

  • 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
  • DBMS_FLASHBACK_ARCHIVE

9. 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

10. Oracle Data Pump, SQL*Loader, and External Tables

  • 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 
  • SQL*Loader and External Table Enhancements

11. Recovery Manager New Features

  • 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

 

Oracle DBA 19C Curriculum

Duration: 25 Hours

1. Exploring the Oracle Database Architecture

  • Oracle Database Architecture Overview
  • Oracle ASM Architecture Overview
  • Process Architecture
  • Memory structures
  • Logical and physical storage structures
  • ASM storage components

2. Installing your Oracle Software

  • Tasks of an Oracle Database Administrator 19c
  • Tools Used to Administer an Oracle Database 19c
  • Installation: System Requirements
  • Oracle Universal Installer (OUI)
  • Installing Oracle Database Software

3. Creating an Oracle Database

  • Planning the Database
  • Using the DBCA to Create a Database
  • Password Management
  • Creating a Database Design Template
  • Using the DBCA to Delete a Database

4. Managing the Oracle Instance

  • Start and stop the Oracle database and components
  • Use Oracle Enterprise Manager
  • Access a database with SQLPlus
  • Modify database installation parameters
  • Describe the stages of database startup
  • Describe database shutdown options
  • View the alert log
  • Access dynamic performance views

5. Manage the ASM Instance

  • Set up initialization parameter files for ASM instance
  • Start up and shut down ASM instances
  • Administer ASM disk groups

6. Managing Database Storage Structures

  • Storage Structures
  • How Table Data Is Stored
  • Anatomy of a Database Block
  • Space Management in Tablespaces
  • Tablespaces in the Preconfigured Database
  • Actions with Tablespaces
  • Oracle Managed Files (OMF)

7. Administering User Security

  • Database User Accounts
  • Predefined Administrative Accounts
  • Benefits of Roles
  • Predefined Roles
  • Implementing Profiles

8. Configuring the Oracle Network Environment

  • Use Enterprise Manager to create and configure the Listener
  • Enable Oracle Restart to monitor the listener
  • Use tnsping to test Oracle Net connectivity
  • Identify when to use shared servers and when to use dedicated servers

9. Managing Data Concurrency

  • Data Concurrency
  • Enqueue Mechanism
  • Resolving Lock Conflicts
  • Deadlocks

10. Managing Undo Data

  • Data Manipulation
  • Transactions and Undo Data
  • Undo Data Versus Redo Data
  • Configuring Undo Retention

11. Implementing Oracle Database Auditing

  • Describe DBA responsibilities for security
  • Enable standard database auditing
  • Specify audit options
  • Review audit information
  • Maintain the audit trail
  • Manage optimizer statistics
  • Manage the Automatic Workload Repository (AWR)
  • Use the Automatic Database Diagnostic Monitor (ADDM)
  • Describe and use the advisory framework
  • Set alert thresholds
  • Use server-generated alerts
  • Use automated tasks

12. Performance Management

  • Performance Monitoring
  • Managing Memory Components
  • Enabling Automatic Memory Management (AMM)
  • Automatic Shared Memory Advisor
  • Using Memory Advisors
  • Dynamic Performance Statistics
  • Troubleshooting and Tuning Views
  • Invalid and Unusable Objects

13. Performing Database Backups using RMAN

  • Backup Solutions: Overview
  • Oracle Secure Backup
  • User-Managed Backup
  • Terminology
  • Recovery Manager (RMAN)
  • Configuring Backup Settings
  • Backing Up the Control File to a Trace File
  • Monitoring the Flash Recovery Area
  • Opening a Database
  • Data Recovery Advisor
  • Loss of a Control File
  • Loss of a Redo Log File
  • Data Recovery Advisor
  • Data Failures
  • Listing Data Failures
  • Data Recovery Advisor Views

14. Working with Support

  • Use the Enterprise Manager Support Workbench
  • Work with Oracle Support
  • Log service requests (SR)
  • Manage patches

15. Using the RMAN Recovery Catalog

  • Identify situations that require RMAN recovery catalog
  • Create and configure a recovery catalog
  • Synchronize the recovery catalog
  • Create and Use RMAN stored scripts
  • Back up the recovery catalog
  • Create and use a virtual private catalog

16. Configuring Backup Specifications

  • Configure backup settings
  • Allocate channels to use in backing up
  • Configure backup optimization

17. Using RMAN to Create Backups

  • Create image file backups
  • Create a whole database backup
  • Enable fast incremental backup
  • Create duplex backup and back up backup sets
  • Create an archival backup for long-term retention
  • Create a multisection, compressed and encrypted backup
  • Report on and maintain backups

18. Performing User-Managed Backup and Recovery

  • Recover from a lost TEMP file and redo log group
  • Recover from the loss of password file
  • Perform user-managed complete and incomplete  database recovery
  • Perform user-managed and server managed backups
  • Identify the need for backup mode
  • Back up and recover a control file

19. Using RMAN to Perform Recovery

  • Perform complete recovery from a critical or noncritical data file loss using RMAN
  • Perform the incomplete recovery using RMAN
  • Recover using incrementally updated backups
  • Switch to image copies for fast recovery
  • Restore a database onto a new host
  • Recover using a backup control file
  • Using RMAN to Duplicate a Database
  • Creating a duplicate database
  • Using a duplicate database

20. Monitoring and Tuning RMAN

  • Monitoring RMAN sessions and jobs
  • Tuning RMAN
  • Configure RMAN for Asynchronous I/O

21. ASM TOPICS

  • Database Architecture and ASM
  • Describe Automatic Storage Management (ASM)
  • Set up initialization parameter files for ASM and database instances
  • Start up and shut down ASM instances
  • Administer ASM disk groups
  • Storage Fundamentals
  • ASM Concepts
  • Preparing ASM Storage
  • ASM Instance setup
  • ASM disk group failure groups (Redundancy)
  • Managing Diskgroups
  • Backing up Diskgroups
  • Monitoring Diskgroups
  • Creating a Database on ASM
  • Managing Database on ASM
  • Basic architecture
  • Storage concepts

22. RMAN Topics

  • Backup Strategies
  • FLASH recovery area
  • RMAN Architecture
  • RMAN backup components
  • RMAN catalog and configuration
  • RMAN Commands
  • Monitoring RMAN backups
  • Tuning RMAN jobs
  • Restoring and recovering using RMAN
  • Database cloning using RMAN
  • Troubleshooting RMAN issues
  • Best practices

23. Container Database architecture

  • Creating container databases using DBCA
  • Creating pluggable databases
  • Managing pluggable databases
  • Start and stop of pluggable databases
  • Export and import of PDBS

 

Do you cover Oracle 12c and 19c as a single course?

We offer Oracle 12c and Oracle 19c as two different courses with different prices. And, you can register for a customized curriculum covering both versions at a special discounted price. For further information about the course, please drop us an enquiry, and our Course Advisor will assist you in making your learning hassle-free.

Hands-On Oracle DBA Projects & Assignments

Our Oracle DBA Training course aims to deliver quality training that covers solid fundamental knowledge on core concepts with a practical approach. Such exposure to the current industry use-cases and scenarios will help learners scale up their skills and perform real-time projects with the best practices.

Training Options

Choose your own comfortable learning experience.

Self-Paced Videos

30 hrs of E-Learning Videos

self-paced


  • 30 hours of Oracle DBA Training videos
  • Curated and delivered by industry experts
  • 100% practical-oriented classes
  • Includes resources/materials
  • Latest version curriculum with covered
  • Get lifetime access to the LMS
  • Learn technology at your own pace
  • 24x7 learner assistance
  • Certification guidance provided
  • Post sales support by our community

Live Online

50 hrs of Remote Classes in Zoom/Google meet

online

Batch

Start - End

Time

Weekend

Jul 30 - Aug 14

08:00 PM EST

Weekdays

Aug 02 - Aug 17

07:30 PM EST

Weekend

Aug 06 - Aug 21

08:00 PM EST

Weekdays

Aug 09 - Aug 24

07:30 PM EST


  • + Includes Self-Paced

  • Live demonstration of the industry-ready skills.
  • Schedule your sessions at your comfortable timings.
  • Virtual instructor-led training (VILT) classes.
  • Real-time projects and certification guidance.

Timings doesn't suit you ?Let us know

For Corporates

Empower your team with new skills to Enhance their performance and productivity.

Corporate Training

  • Customized course curriculum as per your team’s specific needs
  • Training delivery through self-Paced videos, live Instructor-led training through online, on-premise at Mindmajix or your office facility
  • Resources such as slides, demos, exercises, and answer keys included
  • Complete guidance on obtaining certification
  • Complete practical demonstration and discussions on industry use cases

Served 120+ Corporates

Oracle Database Administration Certification

Show the world that you have pursued one of the best in the industry.

Shall I appear for Oracle DBA certification exam after completion of Oracle DBA course?

Our Oracle DBA course covers all the topics that are required to clear Oracle DBA certification. Trainer will shareOracle DBA certification guide, Oracle DBA certification sample questions, Oracle DBA certification practice questions.

After completion of Oracle 12c DBA Training, you will be familiar with all the  DBA activities through hands-on activities through labs, study and practice. You can apply for 

1. Oracle Database 12c Administrator Certified Associate Certification - OCA
                           
             Exam: Oracle Database 12c Administration 1Z0-062


2. Oracle Database 12c Administrator Certified Professional Certification- OCP
                           
             Exam: Oracle Database 12c: Advanced Administration 1Z0-063


These certifications differentiate you from the rest of the DBA members in the marketplace by providing a competitive edge in scaling up through various roles in the Organization.

Mindmajix Oracle DBA Training will assist you to establish your credentials in the Oracle Database technology. Our interactive training sessions demonstrating the concepts through real-time examples are helpful for the trainees to learn all the skills required for cracking the certification exam.

MindMajix certificate

Oracle DBA Online Course Reviews

S

Sukanya

Computer Software Professional

I opted for the Oracle DBA Certification training from Mindmajix. The trainer and coordinators are very helpful and knowledgeable about the course content. They are ex

Read more...

A

Abisola

Informatics Senior Analyst

Excellent training! I have attended Oracle DBA training at Mindmajix. The trainer was a real-time industry expert who was very passionate about the subject matter, and

Read more...

S

Learning Oracle DBA at Mindmajix has improved my skills and i am now able to crack the certification. Trainer was superb, Thanks Mindmajix for the wonderful experience.

Our Instructor

Learn from the certified and real time working professionals.

instructor
NameAshwini
Experience12+
Specialized inOracle RAC DBA, Oracle DBA
More DetailsHaving 12+ years of experience working closely with industry, Ashwini is one of the best-certified trainers of MindMajix. She has bagged Oracle RAC DBA, Oracle DBA and can deliver the best technology to our trainees.

Job Assistance Program

Your intent to master next level skills are appreciated

We take pride in being part of 4 lakh plus career transitions worldwide

Post Training - Access to Premium Features

counseling sessions

Career Counseling Sessions

Once you know the skills, we recommended you understand the eligible job roles, scope, and opportunities.

Mock Interviews

Mock Interviews

Explore what the real-time interviews expect from you.

Resume Builder

Custom Resume Builder Access

We got a resume builder to help you prepare the best resume to win the first impression for recruiters.

Community Support

Privileged Community Support

We make sure to address any real-time challenges our alumni face during their careers through our community platform.

Life-Time Self-Paced Videos

Life-Time Self-Paced Videos Access

Applicable for Live-Online learning mode. Provides a set of self-paced videos to recap the subject whenever/wherever you need.

Quizzes To Scale

Quizzes To Scale

Get access to our Quiz from the LMS to scale your knowledge.

Oracle DBA Training Objectives

Oracle DBA Course Objectives

After completing our course, the students will be able to:

  • Learn Oracle Database Architecture
  • Learn how to install Oracle database/client binaries
  • Query data using SQL and perform DDL, DML and DCL operations
  • Configure backups and perform the recovery using the recovery manager
  • Work with Oracle database parameters
  • Managing Users/Schemas, and profiles
  • Learn to work with RDBMS to store and retrieve data
  • According to Gartner- Oracle is the market leader in the relational database with a 48.35% market share 
  • The career opportunities for skilled database administrators are increasing significantly with excellent scope for career growth.
  • The average salary of a Database Administrator is around $112,650 per annum.

The following job roles can enjoy better career opportunities with this training:

  • Software Developers
  • SQL Programmers and Architects
  • Database Analysts and Administrators
  • Project Managers
  • Individuals aspiring for an Oracle DBA career

Anybody interested in this domain can take this training course. Basic knowledge of databases can be beneficial.

oracle dba training

The learners will excel in the following concepts after taking this training:

  • Core database concepts
  • SQL and PL/SQL concepts
  • Database Administrator Functionalities
  • Physical and logical structures of the database 
  • Configuring and managing the Oracle Network
  • Database configuration and programming
  • Database best practices and scripts
  • Installation, harnessing cloud and storage management
industry statistic

Industry Statistics

Jobs / Month

624

Avg. Salary

$ 11,500

Job Roles

  • Oracle Database Administration

9

+ Years of
E-Learning
Experience

10

+ Years of
Experienced
Trainers

120

+ Served
Global
Corporates

470k

+ Students
Careers
Transformed

570

+ Offers
IT/Software
Courses

Oracle DBA Training FAQs

What if I miss the class?

You can access the recording of the missed class through our LMS. We record each training session and upload it after the session to our LMS which can be accessible to the students.

Yes, we got custom training programs to complete the course as you need.

You need good internet connectivity with a mobile/tab/laptop/system installed with Zoom/Meet.

You can access the recorded videos through our LMS after every session.

Yes, you get two kinds of discounts. They are group discounts and referral discounts.

  • A group discount is offered when you join as a group of three or more.
  • When you are referred by someone already enrolled for training, you receive a referral discount.

STILL GOT QUERIES?

Get a Live FREE Demo
  • Explore the trending and niche courses and learning maps
  • Learn about tuition fee, payment plans, and scholarships
  • Get access to webinars and self-paced learning videos

Find Oracle DBA Online Training in Other Cities

To meet the learning needs of people spread across various geographical locations, we are offering our high-quality training services at the location of your choice to ensure you obtain maximum impact for your training investment. Choose your city below.

Bangalore

Other ORACLE COURSES

1/42