Master Oracle Cloud Infrastructure (OCI) | New Batch Starting from 21st October, 2024 @ 8pm IST | Register for Free Demo

Know More
Offline/ Online Course
Education Images
Learn with Ankush

Oracle DBA 19c Training

Master Oracle DBA Course in Pune with Learnomate Technologies top-notch training. Our expert-led courses cover everything from basic database concepts to advanced management techniques. Gain hands-on experience with RMAN, Data Guard, and SQL tuning. Start your journey with us and become a certified Oracle DBA professional today!

Schedule A Call Join WhatsApp Group
Video Images

Next Bach Starts:

October 14, 2024

Days to go

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

Register Now!

Please enable JavaScript in your browser to complete this form.

Enroll now in our expert-led online courses.

Trainer - Ankush Thavali

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.
CONTACT US

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

Image
Image
Image
Image

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

Client Image - Arya Tandale

It was a wonderful experience for me. Thank you Learnomate Technologies for this great free sql and Linux course

Client Image - Arya Tandale
Arya Tandale
Client Image - Anjali Pingle

Nice teaching. Ankush sir teaches very well and it's easy to understand the topic

Client Image - Anjali Pingle
Anjali Pingle
Client Image - Amit Nandi

Learnomate technology is the best platform to gain and explore knowledge about Oracle DBA. First i saw their video from YouTube and then i enrolled core dba training and after that i also enrolled rac.

Client Image - Amit Nandi
Amit Nandi
Client Image - Jogu Darani

I recently completed course at learnomate tecnologies and I am thrilled with the experience. The institute offers a wide range of courses tailored to current industry demands.

Client Image - Jogu Darani
Jogu Darani
Client Image - Rahul Kamle

Learnomate Technology is a best training institute, I recommend those who wants to start their career in IT industry for fresher as well as non technical people. Thank you Ankush sir for your support and guidance.

Client Image - Rahul Kamle
Rahul Kamle

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 [email protected].

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.
Education Images Education Images
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.

Register for Offline/ Online Training

Please enable JavaScript in your browser to complete this form.
x
Oracle DBA 19c Training
Schedule A Call

The next success story is yours....

Contact Us Now

Copyright © 2023 LearnoMate All Rights Reserved