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.
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
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.
Yes. All the training sessions are LIVE Online Streaming using either through WebEx or GoToMeeting, thus promoting one-on-one trainer student Interaction.
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…
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.