ORACLE 19C DBA

 Learn 12c/19c Oracle DBA ✅ OCA trainer, 10+yrs exp ✅ 45 Hrs Live sessions, ✅ Online Support 24*7 ✅ Material & Real-time Scenarios ✅ Certification Guidance.

5 Rating (9,875 Reviews)
5/5

TRAINER

10+ yrs exp

DURATION

2 Months

RECORDINGS

45 Hrs

MATERIAL

Reading and LAB guide

Online Support

Support 24*7 Available

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

Who should go for this training? The following professionals can go for this course:

  • Administrator
  • Architect
  • Database Administrator

What are the pre-requisites for this Course?

Oracle SQL and Linux Basics

COURSE OVERVIEW

  • 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 cronjob.
  • 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.

OUR KEY HIGHLIGHTS

Unique Benefits included in this training

UPCOMING BATCHES

SELF-PACED LEARNING

This Course Includes:

14,999/-

OUR INSTRUCTOR

Ankush Thavali
Ankush Thavali
Oracle Certified Master, 10+ yrs exp
Read More
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.

DEMO VIDEO

CERTIFICATION GUIDENCE

FAQ

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

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.

COMBO OFFERS

Pay less and learn more with our best combo courses. Avail more discount on multiple top trending technologies

RELATED COURSES

TESTIMONIALS

Concise and straight forward training with real time scenario
Concise and straight forward training with real time scenario
9 months ago
Read More
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
Excellent training, awesome trainer.
Excellent training, awesome trainer.
9 months ago
Read More
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
 Best Oracle dba training for freshers
Best Oracle dba training for freshers
9 months ago
Read More
I was searching for a good oracle dba training,So I came across Ankush Sir you tube channel from there I got to know about him. Joining the classes really help me out to know the basics and to get the hands-on experience. Sir is very interactive when comes to teaching and explains every thing in a every simple way . Sir Is always available to clear up the doubts. So we you all are looking for a training go get yourself enroll for it . Priya Pal
Excellent training, awesome trainer.
Excellent training, awesome trainer.
9 months ago
Read More
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
Best Oracle dba training for freshers
Best Oracle dba training for freshers
9 months ago
Read More
I was searching for a good oracle dba training,So I came across Ankush Sir you tube channel from there I got to know about him. Joining the classes really help me out to know the basics and to get the hands-on experience. Sir is very interactive when comes to teaching and explains every thing in a every simple way . Sir Is always available to clear up the doubts. So we you all are looking for a training go get yourself enroll for it . Priya Pal
Google Ratings
Google Ratings
Read More
Facebook Ratings
Facebook Ratings
Read More
Twitter Ratings
Twitter Ratings
Read More