icon Join Our New AWS Training Batch – Starting 10th November 2025! ENROLL NOW

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 and 100+ interview questions. Gain hands-on experience with RMAN, Data Guard, and SQL tuning. Start your journey with us and become a certified Oracle DBA professional today!

📺 Want to see how we teach? Head over to our YouTube channel for insights, tutorials, and tech breakdowns: 👉 www.youtube.com/@learnomate

🌐 To know more about our courses, offerings, and team: Visit our official website: 👉 www.learnomate.org

Oracle DBA 19c Training

COURSE OVERVIEW

Data Analytics is the process of examining raw data to uncover patterns, trends, and insights. It uses techniques like statistical analysis, machine learning, and visualization to drive decision-making, helping organizations optimize operations, predict outcomes, and enhance business strategies.

Oracle DBA 19c Training

Syllabus

  • 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

Our Upcoming Batch

Student with laptop
Data Science and AI Course
Filling Fast

Get Industry-Ready With Itvedant

  • Enroll For 1 Course & Get Access To All Courses.
  • In-Depth Curriculum With Only 20 Seats Per Batch.
  • Integrated Internship & 2 Global Certifications
  • Practice On HackerRank & LeetCode
  • Corporate Visits & Dedicated 6-Month On-Job Support.

Certificates

Obtaining Your
Certification

Upon successful completion of any course at Ethhive, participants receive a certificate attesting to their proficiency in the respective subject matter. These certificates serve as tangible evidence of the skills acquired during the training, enhancing the credibility of individuals in the job market and validating their expertise to potential employers. Ethhive certificates are recognized for their industry relevance and are highly regarded by leading organizations, providing a competitive edge to certificate holders.

The validation process ensures that the certifications are earned through rigorous learning and assessment methods, reflecting real-world application and mastery of the concepts taught. With Ethhive certificates, individuals can showcase their commitment to continuous learning and professional development, opening doors to new career opportunities and advancement prospects. Students can have option for IBM Certificate also.

Ethhive Certificate 1
Ethhive Certificate 2
IBM Certificate Option