From Beginner to PRO
-
About Oracle DBA Certification Course -
Learn from Basics to Adv DBA topics on Linux with projects and job placement support to become an Oracle DBA Expert in short duration.
-
Any Pre-requisites -
None! Anyone can learn from IT or non IT as no programming involved.
Get Offers & Details
Syllabus
2 to 2.5 months - Attractive Fees
- Setting up a VM (Virtual Machine)
- Understand HDD partitioning
- Primary Verses Extended Partitioning
- Physical Volumes / Logical Volumes / Luns
- Different levels of Raid
- Installation of configuration of DNS.
- Installation and configuration of DHCP
- tgtd and iscsi utilities
- Install and configure 19c and 21c Oracle Database Software
- Creating 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
- Understanding row chaining and migration
- Different block Sizes
- Understanding multitenant architecture
- Overviews of Pluggable databases
- Configuring and maintaining listeners
- Configured Dispatchers and Shared servers
- Understanding tnsnames.ora / sqlnet.ora and Ez Connect
- 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 conventional methods
- Cloning database using rman
- Different types of Patches
- How to apply patch to database
- Upgrade Database from 12c to 19c
- Coverting 19c noncdb to 19c pluggable database
- Configure physical standby database
- Understanding logical and snapshot standby database
- Understand how to read the AWR / ADDM / ASH reports
- Using sql loader to load data into tables
- External tables and its benefits
- Understanding different types of partitioning
- Creating and altering partitions
- 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 Catalog maintenance
- Oracle Recovery Catalog maintenance
- Recovery using Oracle recovery manager
- Database Cloning using RMAN
- Tablespace Point in time recovery
- Incomplete recovery
- Regular - 2 to 2.5 months
- Bootcamp - 8 to 10 days
- Rs. 30000 (installments)
- Rs. 27500 (1 time)
- Note - Fees in INR. International students please convert fees in your currency. Free Demo available. To book, contact us..
Google Reviews
-
Jaison Jose
-
Zaheen Parkar
Attended oracle dba course , i am satisfied with the training module and the flexi timing also the content was appropriate as per the syllabus. Very knowledgeable and experienced instructor who explain the concept as per industry standard requirements and latest technology is being taught. Tutor creates Very friendly environment which makes the sessions exciting and Not boring. -
Kalpesh Mhatre
Recently done with my oracle dba course and it was nice we got a good and experience trainer, he is very friendly and whenever we had a doubt he used to explain us many times. The course is pretty big and smoothly all the concept were covered. Thank you quickxpert :) -
Swapna Shinde
This is my feedback about the course SAP HR. I has joined the course last year. I attending the online lectures at home. 1 or 2 hours batches In a week. I would like to thank you Mr. Sunil Mane sir. Is teaching and explaining a very good. Thank you sir once again -
AMOL PALAV
Took DBA course. In detailed explanation of topics with test cases and topic wise notes. Highly recommend. Training done on latest version of orcale database.