Best Oracle Dba Training Institute
Learners 1000+
-
Best Oracle Dba Course to Learn in Classroom / Online Format from Best Oracle Dba Training Institute QuickXpert Infotech known for Quality Training in Reasonable Fees and Placements!
-
About Oracle DBA -
DBA stands for Database Administration. Oracle DBA are experts that manages Oracle database server.
-
About Oracle DBA Certification Course -
Learn from Basics to Adv DBA topics on Linux with projects under our expert trainers to become an Oracle DBA Expert in short duration.
-
Duration -
2 to 2.5 months - Get Fees
Trainer -
Exp. Professional, Trained Lots of Students!
-
Any Pre-requisites -
None! Anyone can learn from IT or non IT as no programming involved.
Upcoming Batch -
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
Why get Trained from us ?
Training From Experts
Personal Attention
80% Practical
Study Material
Course Completion Certificate
Live Projects /
Case Studies
Interview Preparation
Best Placement Service
