User Batch

From Beginner to PRO

About Oracle DBA -

DBA stands for Database Administration. Oracle DBA are experts that manages Oracle database server.
About Oracle DBA Certification Course -

Learn from Basics to Adv DBA topics on Linux with projects and job placement support to become an Oracle DBA Expert in short duration.
100% Placement Support -
End-to-end placement support with early placement initiation during training (eligibility-based), continuous expert guidance and a simple placement process powered by our dedicated placement team and strong hiring network of 1000+ companies to help you get the best job opportunities and placement faster. Check company list below.
Trainer -
Exp. Professional from Industry
Any Pre-requisites -

None! Anyone can learn from IT or non IT as no programming involved.

Inquire / Book Demo

Syllabus

Introduction

Linux Installation

Setting up a VM (Virtual Machine)
Understand HDD partitioning
Primary Verses Extended Partitioning
Physical Volumes / Logical Volumes / Luns

Understanding RAID / Storages / DNS / DHCP / iscsi utilities

Different levels of Raid
Installation of configuration of DNS.
Installation and configuration of DHCP
tgtd and iscsi utilities

Installing Oracle Software

Install and configure 19c and 21c Oracle Database Software

Creating databases (manual)

Creating Database manually

19c Architecture

Thorough understanding of 19c architecture

Oracle Administration and management

Starting databases
Understanding control files / redo log files / archive files
Understanding Server parameter file and password files
Automatic memory management
Different components in SGA and PGA

Tablespaces / segments / extents and blocks

Dictionary managed versed locally managed tablespaces
Automatic Segment space management
Understanding Segments / extents and blocks
Block utilization parameters
Understanding row chaining and migration
Different block Sizes

19c Multitenant Database concepts and new features

Understanding multitenant architecture
Overviews of Pluggable databases

Oracle networking and shared process overview

Configuring and maintaining listeners
Configured Dispatchers and Shared servers
Understanding tnsnames.ora / sqlnet.ora and Ez Connect

ASM overview and benefits

Complete Overview of ASM
Understand the need of ASM
ASM instance parameters

RMAN and conventional Backup / Recovery

Defining backup strategy
Complete understanding of RMAN and conventional backups

Rman and Conventional Cloning

Cloning database using conventional methods
Cloning database using rman

Applying patches

Different types of Patches
How to apply patch to database

Database upgrade

Upgrade Database from 12c to 19c
Coverting 19c noncdb to 19c pluggable database

Physical and logical Standby/ Data guard

Configure physical standby database
Understanding logical and snapshot standby database

AWR reports / ADDM reports / ASH report

Understand how to read the AWR / ADDM / ASH reports

Sql loader / external tables

Using sql loader to load data into tables
External tables and its benefits

Partitioning concepts

Understanding different types of partitioning
Creating and altering partitions

expdp / impdp backups

Taking logical backups using expdp
Data pump usage and scenarios

Loss

Loss of a Control File
Loss of a Redo Log File
Loss of a Data File in NOARCHIVELOG Mode
Loss of a Noncritical Data File in ARCHIVELOG Mode
Loss of a System-Critical Data File in ARCHIVELOG Mode

Oracle Recovery Manager

Oracle Recovery Catalog maintenance
Oracle Recovery Catalog maintenance
Recovery using Oracle recovery manager
Database Cloning using RMAN
Tablespace Point in time recovery
Incomplete recovery

Duration

Regular - 2 to 2.5 months
Bootcamp - 8 to 10 days

Fees

Rs. 30000 (installments)
Rs. 27500 (1 time)
Note - Fees in INR. International students please convert fees in your currency. Free Demo available. To book, contact us..

Google Reviews

Jaison Jose
Zaheen Parkar

Attended oracle dba course , i am satisfied with the training module and the flexi timing also the content was appropriate as per the syllabus. Very knowledgeable and experienced instructor who explain the concept as per industry standard requirements and latest technology is being taught. Tutor creates Very friendly environment which makes the sessions exciting and Not boring.
Kalpesh Mhatre

Recently done with my oracle dba course and it was nice we got a good and experience trainer, he is very friendly and whenever we had a doubt he used to explain us many times. The course is pretty big and smoothly all the concept were covered. Thank you quickxpert :)
Swapna Shinde

This is my feedback about the course SAP HR. I has joined the course last year. I attending the online lectures at home. 1 or 2 hours batches In a week. I would like to thank you Mr. Sunil Mane sir. Is teaching and explaining a very good. Thank you sir once again
AMOL PALAV

Took DBA course. In detailed explanation of topics with test cases and topic wise notes. Highly recommend. Training done on latest version of orcale database.

Book Demo

Trending Courses

Cyber Security

Digital Marketing

JAVA

.NET

Python

Testing

Data Analyst

Data Science

Web Dev.

Full Stack Developer

MERN & FSD

Cloud - AWS & Devops

Oracle SQL & DBA

Salesforce

Courses

Training Programs

Cyber Security Course in User Batch - Fees, Placements, Best Training Institute, Online Classes Available