Oracle DBA 19c Training

Modules covered in The Ultimate Oracle DBA Program

After Years Of Experience And Research, This Ultimate Oracle DBA Masters Program (Cloud Focused) Is Curated By Me To Help You Crack Top Product Based Companies

Module 1

Basic SQL & Linux

Module 2

Oracle 19C Architecture

Module 3

Oracle 19C Database Installation

Module 4

Oracle Multitenant Architecture

Module 5

Backup (RMAN, Export-import)

Module 6

ASM management

Module 7

Database Patching activity

Module 8

Dataguard

Module 9

OEM

A Curriculum that prepares you to thrive in the Industry as an Expert Oracle DBA

Download Syllabus

COURSE OVERVIEW

What will you learn?

All Core Oracle DBA Concepts
Learn about the Oracle Database Architecture.
Create and manage an Oracle Database Instance.
Dataguard
ASM – Automatic Storage Management
Shell Scripting – Automation
Fundamental Performance Tuning
Oracle Patching
Oracle Upgradation
Oracle Enterprise manager Tool
Manage security within a multitenant container database and regular and application pluggable databases

The following professionals can go for this course:

Administrator
Any degree bachelor ( IT or Non-IT)
Database Administrator

What are the pre-requisites for this Course?

Oracle SQL and Linux Basics.

Course Content

ENROLL NOW

Understand HDD partitioning
Package download and Installation

Installation of configuration of DNS
Installation and configuration of DHCP

Download Oracle database software
Install and configure 19c Oracle Database Software .
Database Installation using Silent Mode

Creating 19C Database manually

Thorough understanding of 19C architecture

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

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

Understanding multitenant architecture.
Overviews of Pluggable databases.
Installation of Pluggable database with different way.

Configuring and maintaining listeners.
SQL Developer Installation.
Understand how to connect SQL Developer with Oracle 19C database.

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

Defining backup strategy.
Complete understanding of RMAN and conventional backups.

Cloning database using rman

Different types of Patches.
How to apply patch to database.

Upgrade Database from 12C to 19C

Configure physical standby database.
Understanding Active and snapshot standby database.

Understanding crontab.
Writing basic scripts.

Understand how generate AWR / ADDM / ASH reports.

Taking logical backups using expdp.
Data pump usage and scenarios

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.
Backups using Oracle Recovery Manager
Recovery using Oracle recovery manager.
Database Cloning using RMAN.
Tablespace Point in time recovery.
Incomplete recovery .
Database and Instance Metrics.
Reacting to Performance Issues.

Server Generated Alerts.
Thresholds.
Setting Thresholds.

Index Rebuild.
Stats gather.
Generate AWR reports / ADDM reports / ASH report.
Blocking in SQL statement.

Frequently asked Interview question will cover after end of session.

Will take mock interview and also provide solution which will help to crack interview

MODES OF TRAINING

Classroom Training

Lives interactive sessions delivered in our classroom by our expert trainers with real-time scenarios.

Online Training

Learn from anywhere over internet, joining the live sessions delivered by our expert trainers.

Self-Pace Training

Learn through pre-recorded video sessions delivered by experts with your own pace and timings

For Coporate Training, We provide customized content and delivered by industry experts with complete practical demonstration, discussions and exercises based on practical use cases.

UPCOMING BATCHES

Batch Date	Batch Mode	Start Time (IST)	Duration
10/10/2023	Online	8:00 pm	45 days

ENQUIRE NOW

ONLINE TRAINING

Even if you have a career gap, we offer job assistance.
Any non-IT person can begin a career as an Oracle DBA.
24*7 dedicated online support team to help you.
Lectures Delivered by our experts having 10+ years exp.
45+ (Online / Offline) Sessions.
3 months access for Recorded videos.
Technical support through chat & email
100% practical Oriented CLasses.
Real-time projects and certificate guidance
Oracle Certification exam Assistance.
Get Certificate on course completion

Course Fee

For Students accessing the course from India

Course Fee: ₹49,999
Launch Discount: ₹10,000

Offer Price: ₹39,999*
*Valid for limited period

3 & 6 Months No Cost EMI available on all major Credit Cards.

For Students accessing the course from outside India

Course Fee: $599
Launch Discount: $100

Offer Price: $499*
*Valid for limited period

3 & 6 Months No Cost EMI available on all major Credit Cards.

OUR STUDENTS REVIEWS

How learners like you are achieving their goals

Highly recommended training, covered so many topic, to set student ready for job. The instructor is very concise, patient and knowledgeable on the real time scenarios. provides many tools for all to succeed. Great Price $$$. 99.99999% satisfied.

Bertino

I was searching for a software course to start a career in IT sector. I am not from an it background so one of my friend told me about Oracle DBA and recommend Ankush sir for training. Joining the classes really help me to know about the basics and to get the hands-on-experience. Awesome Trainer and extremely helpful he explain things in a simple way and also give real time training. Thank you sir or your very valuable training.

Kiran Dalvi

Ankush Sir is the best trainer of oracle DBA. The way of teaching of ankush sir is great he is giving real time training , I have no word to say about ankush sir. He is the best trainer on earth.

TARUN KUMAR

Awesome Trainer and extremely helpful he explains things in a simple way and also gives real time training unlike other trainers. Would 100% recommend him.

Nasreen Fatima

A very knowledgeable person whom you can rely on anytime. Ankush sir is always ready to help with any of our queries and also will not let go of any issue until its fixed. Highly recommended for everyone. Thank you so much for your efforts sir.

Goutham

Our Students Work At

Our Alumni work at eminent Big data companies and progressive Startups

FAQ

Have a Question with
this Course?

This entire course content and our trainer helps you to get expertise and clear the certification program easily

Team will provide you meeting details as soon as you make the payment

After purchasing the product need you any support you can be share with us with sending mail to info@learnomate.org.

Every session will be recorded. Recording access will be available for three months

We will do setup on personal laptop. Expecting student to have their personal laptop.

Yes. We do provide the step-by-step document which you can follow and if required our technical team will assist you.

Our Teacher

Source of Inspiration

Ankush Thavali Sir

Oracle DBA Trainer Pune, MH, India

Ankush Thavali Sir is the best trainer of Oracle DBA. The way of teaching of Ankush sir is great. He is giving real time training . He makes things simple and understandable. He is up to date with advanced IT skills. He spent his past 10 years as Oracle DBA with skills into DBA Support. High Availability Design & Implementations, Technical Solutions, Automation using Scripting, Database Designing & as a Corporate Trainer too. He worked with many MNC's like infosys, cognizant, wipro, LTI & having 10+ Years of experience With deep technical knowledge. Now he is CEO at Learnomate Technologies. Ankush thavali sir has implemented many real time projects on advance Database areas. His certification list includes, The Oracle Certified Associate (OCA). He is an expertise in OS Administrations, Virtualizations/VMWare and Oracle Database 8i/9i/10g/11g & 12c,19c, RAC, Data Guard, ASM, Oracle Exadata, Oracle Performance Tuning, Golden Gate, Oracle Security & many more advance technologies.