When you learn at Mindmajix, you can always rely on team of experts to provide guidance and support, whenever you need it.
Instructor-Guided Lessons and Activities
Learn key objectives through expert-led lectures, discussions, and exercises.
Hands-on practice on Tools
Practice new skills and dive deeper into the day’s key topics
After Each Session
Q & A Session.
Wrap up the session with clarification on concepts and labs, if needed.
Oracle Database 12c New and Enhanced Features
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
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
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
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
Transporting Database Process Steps
Transporting Tablespace Process Steps
Recovering Tables from Backups
Specifying the Recovery Point-in-Time
Process Steps of Table Recovery
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
Data guardUpgrade using SQL apply
Oracle Datagurad Scenario's
Downgrading database in Data guard Configuration
Creating standby using rman
Have any queries regarding course curriculum, speak to our course advisorConnect with Advisor
Upon successful completion of the program, you will be awarded a Certificate from Mindmajix for Oracle DBA Training.
Successfully complete your course and let the community know about your achievement.
Trainer will cover all the topics related to Certification.
Don’t just show off your achievement to the community, use it to advance in your career.
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.
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
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 TeamContact us
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.