Oracle DBA Training

  • (5.0)
  • 2985 Ratings
  • Learners : 3010
Watch Demo Video

Trusted By Companies Worldwide & 3,50,850+ Learners

Course Overview

MindMajix Oracle DBA Training: Become Job Ready in Oracle DBA by learning Oracle Database 11g/12c core architectural & database administration concepts, Enterprise Manager tools, configuring CDB & PDBs, Auditing Enhancements & SQL Tunning, User Management, RMAN, DB backup & recovery, and In-Memory Caching, etc. You will also get an exposure to industry based real-time projects in various verticals.
30 hours of Instructor Led Oracle DBA Training
Lifetime Access to Recorded Sessions
Real World use cases and Scenarios
Practical Approach
24/7 Support
Expert & Certified Trainers

Immersive Learning

When you learn at Mindmajix, you can always rely on team of experts to provide guidance and support, whenever you need it.

30 Hrs

Lecture

Instructor-Guided Lessons and Activities

Learn key objectives through expert-led lectures, discussions, and exercises.

20 Sessions

Labs & Exercises

Hands-on practice on Tools

Practice new skills and dive deeper into the day’s key topics

15 Mins After Each Session

Doubts Clarifications

Q & A Session.

Wrap up the session with clarification on concepts and labs, if needed.

See What You'll Learn

Oracle Database 12c New and Enhanced Features
Objectives 
Challenges 
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$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

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 Common or Local Privileges / Roles to Roles
Granting Common 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)
 
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
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
DBMS_FLASHBACK_ARCHIVE
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 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

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

Mindmajix offers advanced Oracle DBA interview questions and answers along with Oracle DBA resume samples. Take a free sample practice test before appearing in the certification to improve your chances of scoring high.

Have any queries regarding course curriculum, speak to our course advisor

Connect with Advisor

Modes of Training

For Individuals
For Corporates

Our Course in Comparison

  • Features
  • Setup Demos at your Convenient Time
  • 1-1 Training
  • Batch Start Dates
  • Customize Course Content
  • LifeLong Access to LMS
  • 24*7 Support
  • EMI Option
  • Group Discounts
  • Mindmajix
  • At your Convenience
  • Other Virtual Live Classes
  • Fixed

Loved by Users

Upcoming Batches

  • Weekday

    Mar 21 (2 hrs a day)

    7:00 AM IST
    Enroll Now & Avail 15% off →
  • Weekend

    Mar 23 (2 hrs a day)

    7:00 AM IST
    Enroll Now & Avail 10% off →
  • Weekend

    Mar 24 (2 hrs a day)

    7:00 AM IST
    Enroll Now & Avail 10% off →
  • Weekday

    Mar 26 (2 hrs a day)

    7:00 AM IST
    Enroll Now & Avail 15% off →
  • Weekday

    Mar 28 (2 hrs a day)

    7:00 AM IST
    Enroll Now & Avail 15% off →
  • Weekend

    Mar 30 (2 hrs a day)

    7:00 AM IST
    Enroll Now & Avail 10% off →
Schedules Doesn't Suit You ?

Our Team can set up a batch at your convinient time.

Let us know

Oracle DBA Certification Pass Guranteed!

Upon successful completion of the program, you will be awarded a Certificate from Mindmajix for Oracle DBA Training.

Complete Your Course

Successfully complete your course and let the community know about your achievement.

Become Certified

Trainer will cover all the topics related to Certification.

Impress Your Employer

Don’t just show off your achievement to the community, use it to advance in your career.

FAQ's!

Have questions? We’ve got the answers. Get the details on how you can grow in this course.

Our trainers have relevant experience in implementing real-time solutions on different queries related to different topics. Mindmajix verifies their technical background and expertise.

We record each LIVE class session you undergo through and we will share the recordings of each session/class.

Trainer will provide the Environment/Server Access to the students and we ensure practical real-time experience and training by providing all the utilities required for the in-depth understanding of the course.

If you are enrolled in classes and/or have paid fees, but want to cancel the registration for certain reason, it can be attained within 48 hours of initial registration. Please make a note that refunds will be processed within 30 days of prior request.

The Training itself is Real-time Project Oriented.

There are some Group discounts available if the participants are more than 2.

As we are one of the leading providers of Live Instructor LED training, We have customers from USA, UK, Canada, Australia, UAE, Qatar, NZ, Singapore, Malaysia, India and other parts of the world. We are located in USA. Offering Online Training in Cities like

New York, New jersey, Dallas, Seattle, Baltimore, Houston, Minneapolis, Los Angeles, San Francisco, San Jose, San Diego, Washington DC, Chicago, Philadelphia, St. Louis, Edison, Jacksonville, Towson, Salt Lake City, Davidson, Murfreesboro, Atlanta, Alexandria, Sunnyvale, Santa clara, Carlsbad, San Marcos, Franklin, Tacoma, California, Bellevue, Austin, Charlotte, Garland, Raleigh-Cary, Boston, Orlando, Fort Lauderdale, Miami, Gilbert, Tempe, Chandler, Scottsdale, Peoria, Honolulu, Columbus, Raleigh, Nashville, Plano, Toronto, Montreal, Calgary, Edmonton, Saint John, Vancouver, Richmond, Mississauga, Saskatoon, Kingston, Kelowna, Hyderabad, Bangalore, Pune, Mumbai, Delhi, Dubbai, Doha, Melbourne, Brisbane, Perth, Wellington, Auckland etc…

Oracle DBA 12c (Oracle Database Administration) is responsible for the design, implementation, support and maintenance of databases in everyday enterprises. Oracle DBA role ensures security, performance and efficient availability of data to users and customers. From this course, you get a clear picture of

Creating backups with RMAN.
Managing Oracle Database & Software.
The Oracle Instance.
Storage Parameters.
The Oracle Network Environment (SAP).
Different Startup & Shutdown Modes.
Related Jobs and Positions in the Industry.
Oracke 11g Concepts.

Oracle 12c DBA Course deals with the performance of the capacity planning, installation, configuration, performance monitoring, security, troubleshooting, as well as backup and data recovery for creating and maintaining all databases.

As such there are no prerequisites for learning Oracle DBA. However, with a number of opportunities in the field, the following job roles will get benefited from this course:

Oracle Database Administrators
Oracle Network Administrators
Oracle Application Developers
Application Administrators
Database Users
Aspirants aiming for a career in the prospective field.

An in-depth knowledge of an Oracle DBA 12c / 11g project ensures all the critical components are well-covered. With this knowledge, you can increase your visibility and enhance your efficiency in drawing real connections among different components of DBA. We will also provide the complete Oracle dba material & oracle dba 12c / 11g training videos covering all the aspects of this project.

There are three levels of certification for Oracle DBA which are known as Associate, Professional and Master levels. The detailed information is available here. For passing these certification exams, an in-depth understanding of all the Oracle DBA concepts is recommended. The learning path and the project Mindmajix comes up with will be exactly in line with the certification program which enables you to clear Oracle DBA certification exam with greater ease and secure a job in top multinationals.

Have More Questions. Reach our Support Team

Contact us

Join a Demo Session

See if this course is a fit for you by joining us for an online info session. You’ll meet our team, get an overview of the curriculum and course objectives, and learn about the benefits of being a student at Mindmajix

Attend a Demo Session | Meet the Expert Who Can Kickstart Your Career in Oracle DBA

By providing us with your details, We wont spam your inbox.