Oracle DBA Online Training

Course Duration : 30 Hrs
Learners : 1300
Reviews : 4.9

KITS Oracle DBA Online Training imparts you to gain the skills and the knowledge required to install, configure, and administer the Oracle Databases. Through this course, you will master in creating and maintaining a backup and the recovery strategy

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.

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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
Database Patch Management Introduction
Applying Interim and Patch set Patches
Patch History & Documentation
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

Self-Paced

  • Learn at your convenient time and place
  • Grab the practical exposure of the course through high-quality videos
  • Learn from basic to advanced level of the course led by real-time instructors

Online

  • Get a live demonstration of every topic by our experienced faculty
  • Get LMS Access of every session after the completion of the course
  • Gain the stuff to get certified

Corporate

  • Can enroll for Self paced, Live (or) the class mode of training
  • Engage in online training lecture by an industry expert at your facility
  • Learn as a full day schedule with discussions, exercises, and practical use cases
  • Design your own syllabus based on the project requirements
The trainer is a real-time expert and has a significant amount of technology
Irrespective of your class attendance, every session will be recorded. Soon after the completion of the class, you can able to access the videos
During the course, the trainer will provide the environment to execute the practical's.
Once you contact us, our support team will offer you great discounts.
Yes! we do accept the fee in installments, depending on the mode of training you take.
We offer the best training on different modes like self-paced, one-one, batch as well as corporate training.
Yes! Our support team will take your resumes and forward to the firms for placement assistance
During the course, the trainer will provide the probable certification question to make you certified.
03 December
07:30 AM
14 December
07:00 AM

Click here to Login to add a review.

Through the reference of my friend, I joined the Oracle DBA Course at KITS. I have successfully cleared the certification soon after the course completion.
- George M.Hellar
KITS Oracle DBA Course content was highly qualitative and the trainer covered all concepts.
- Rajesh Chiniwar
I took the best Oracle DBA training from KITS. The trainer has covered the highly qualitative and covered all the concepts. Overall it was a good experience with Kits online training.
- Gerald K Nkwanga
I have recently taken the Oracle DBA Certification training from KITS. The trainer and coordinators are very helpful and knowledgeable about the course content.
-
Excellent training to learn from the basics! I have attended Oracle DBA training at KITS. I thank KITS for the best training.
- Enrique Teran

100% Online Course

Flexible Schedule

Beginner Level To Advance Level

Real-Time Scenarios With Projects

LMS Access

Interview Questions & Resume Guidelines Access