Offline/ Online Course
Education Images
Learn with Ankush

Oracle DBA 19c Training

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

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

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

    • 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

        Shape Images Shape Images
        Classroom Training

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

        Shape Images Shape Images
        Online Training

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

        Shape Images Shape Images
        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 DateBatch ModeStart Time (IST)Duration
        10/10/2023Online8:00 pm45 days

        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.

        Certificate Image

        Get a Certificate

        Get Recognised with the Course Completion Certificate

        • Image Icon

          5000+ Get Award

        • Image Icon

          10K+ Zero to career

        OUR KEY HIGHLIGHTS

        Unique Benefits included in this training

        • BEST TRAINER : OCM Certified, 10 Yrs exp and delivered more than 40 batches
        • QUALITY CONTENT : More content including advance features covered better in Industry
        • BEST PRICE : Affordable and best competitive price in the market
        OUR STUDENTS REVIEWS

        How learners like you are achieving their goals

        Clint Images

        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.

        Clint Images
        Bertino
        Clint Images

        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.

        Clint Images
        Kiran Dalvi
        Clint Images

        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.

        Clint Images
        TARUN KUMAR
        Clint Images

        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.

        Clint Images
        Nasreen Fatima
        Clint Images

        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.

        Clint Images
        Goutham

        Our Students Work At

        Our Alumni work at eminent Big data companies and progressive Startups

        • Brand Image
        • Brand Image
        • Brand Image
        • Brand Image
        • Brand Image
        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

        Testimonial Images

        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.

        The next success story is yours....