Industry-Oriented Training | ⭐ Hands-On Practical Labs
Oracle 19c Database Administration Training
Learn how to install, configure, manage, and maintain Oracle databases using Oracle 19c Database Administration tools and techniques. This training provides practical knowledge of database architecture, storage management, backup & recovery, performance tuning, and Oracle database security.
4.8
Course Duration:40h+
Course level:Beginner to Advanced
What I will learn?
- Understand Oracle 19c database architecture and storage structures
- Install and configure Oracle Database software and create databases
- Manage CDB and PDB in multitenant architecture
- Configure Oracle network environment and listeners
- Manage tablespaces, users, privileges, and roles
- Perform backup and recovery using RMAN
- Implement logical and physical database backups
- Monitor performance and troubleshoot database issues
About Course
The Oracle 19c Database Administration Training at Aalok Institute is designed for professionals and students who want to build strong skills in Oracle database management and administration.
This course covers the core responsibilities of a Database Administrator (DBA) including database installation, configuration, storage management, security, backup & recovery, and performance monitoring.
Students will learn how to work with Oracle Multitenant architecture (CDB & PDB), Oracle network configuration, database storage management, and RMAN backup strategies used in enterprise environments.
Through hands-on practical sessions and real-time scenarios, learners will gain experience in managing production-level Oracle databases.
After completing this training, students will be able to install, configure, manage, and troubleshoot Oracle databases confidently.
Career Opportunities After Oracle DBA Training
This course prepares learners for roles such as:
• Oracle Database Administrator (DBA)
• Oracle Database Engineer
• Oracle System Administrator
• Database Infrastructure Engineer
• Oracle Support Engineer
• Database Operations Specialist
Course Curriculum
- Oracle Database Architecture Overview
- Process Architecture and Memory structures
- Logical and physical storage structures
- Benefits of the multitenant architecture
- Differences between the root container and pluggable database containers
- Structure of the root
- Structure of Pluggable Database (PDB)
- CDB_xxx and DBA_xxx views
- Tasks of an Oracle Database Administrator
- Tools Used to Administer an Oracle Database
- Installation: System Requirements
- Oracle Universal Installer (OUI)
- Installing Oracle Database Software
- Planning the Database
- Using the DBCA to Create a Database
- Password Management
- Using the DBCA /Drop a Database
- Tools: DBCA and SQLPlus
- Configuration and creation of CDB
- Exploring the Structure (CDB_xxx views and EM)
- Tools used: SQL Developer, DBCA and SQLPlus
- Create a new PDB from PDB$SEED
- Create a PDB from a non-CDB
- Clone a PDB into the same CDB or into another CDB using DB links
- Plug in an unplugged PDB
- Connect to CDB as administrator
- Connect to a PDB using a service name
- Start up a CDB / Shut down a CDB
- Open / Close a PDB (SQL*Plus, srvctl, EM)
- Open / Close all PDBs
- Triggers ON PLUGGABLE DATABASE
- Change PDB state
- Start and stop the Oracle database and components
- Access a database with SQLPlus
- Modify database installation parameters
- Describe the stages of database startup
- Describe database shutdown options
- View the alert log
- Access dynamic performance views
- Use Netca,Netmgr,Manual to create and configure the Listener
- Start and stop the listener
- Setting up tnsnames.ora/listener.ora/sqlnet.ora on Non-Default/Default path
- Troubleshooting listener related connectivity issue
- Use tnsping to test Oracle Net connectivity
- Identify when to use shared servers and when to use dedicated servers
- Storage Structures
- Create permanent tablespaces in the root and PDBs
- Manage common and local schemas and users in the root and PDBs
- Manage system and object privileges to common and local grantees granted "commonly" or "locally"
- Manage common and local roles granted "commonly" or "locally"
- Online Datafile Movement
- Storage Structures
- How Table Data Is Stored
- Anatomy of a Database Block
- Actions with Table space like create/drop/offline/online
- Space Management in Tablespace
- Adding/Resizing Data files
- Renaming/Relocating Data file
- Oracle Managed Files (OMF)
- Monitor and administer undo
- Configure undo retention
- Guarantee undo retention
- Identify the importance of checkpoints, redo log files, and archived log file
- Configure ARCHIVELOG mode
- Adding/Dropping Redolog Members/ Groups
- Changing Archive Destinations
- Database User Creation/Management
- Predefined Administrative Accounts
- Benefits/Creation of Roles and Predefined Roles and Roles Management
- Describe the basics of database backup, restore and recovery
- List the types of failure that may occur in an Oracle Database
- Identify the importance of checkpoints, redo log files, and archived log file
- Configure ARCHIVELOG mode
- Data export/import with different Levels Using datapump utility
- Real Time Scenarios like Schema/Tables Refresh Using datapump utility
- Create consistent database backups
- Back your database up without shutting it down / Hot Backup
- Recovery Manager Features and Components
- Connection Types with RMAN and Additional RMAN Command Line Arguments
- Channel Allocation and Control Options
- Using RMAN to connect to target database in default NOCATALOG mode
- Configuring Persistent Settings for RMAN
- Recovery Catalog Creation for RMAN
- RMAN Command Overview like list/report/crosscheck/catalog
- Backup Constraints and Options
- Parallelization of Backup Sets
- Configure/Monitor the Flash Recovery Area for RMAN Backups
- Create Full and incremental backups
- Compressed Backups
- Tags for Backups and Image Copies
- Backing Up Archived Redo Log Files
- Removing expired backup using RMAN
- Recover from loss of a spfile file using RMAN
- Recover from loss of a control file using RMAN
- Recover from loss of a data file using RMAN
- Restoring Archived Redo Log Files
- Full Database Restore and Recover Using RMAN
- Incomplete/ Point-in-time recovery Using RMAN
- Real Time Scenarios like DB Cloning Using RMAN Backup
• Migration Planning
• Migration Workflow
• Database Migration Tools
• RMAN Migration
• Data Pump Migration
• Automated Migration Methods
- Brief overview of Tuning methodology
- General tuning concepts
- Session Management
- Gathering Statistics/Statistics Management
- Index Creation and Rebuilding Indexes
- Coalesce/Shrinking tables/indexes
Checking Locks/Dead Locks/Blockings Sessions - Checking Waitevents and Long Running Queries
- Generating Statspack/AWR/ASH/ADDM Reports
- Conclusion Q & A
Requirements
- Basic knowledge of databases or SQL
- Basic understanding of operating systems
- Laptop/Desktop with internet connection
- Interest in learning Oracle database administration
Course Includes
- 40+ Hours of Practical Training
- Hands-on Oracle Database Administration Practice
- Real-time Database Administration Scenarios
- Oracle Backup & Recovery Implementation
- Certification Guidance
- Resume Preparation Support
- Course Completion Certificate
Oracle 19c Database Administration Training
Benefits Obtained :
- Live Online & Offline Classes
- PDF Study Materials & Notes Provided
- Real-Time Hands-On Practice
- Course Completion Certification
Why Join Aalok Institute for Oracle DBA Training?
- Industry-Experienced Trainers
- Real-Time Database Administration Scenarios
- Hands-on Practical Sessions
- Small Batch Size for Personal Attention
- Online and Classroom Training Options
- Job-Oriented Curriculum
Our training program focuses on real-world database administration skills that companies require today.
Who Should Join This Course?
This course is ideal for:

Freshers looking to build a career in database administration
Become an Oracle Database Administrator
Learn to install, configure, manage, and secure Oracle 19c databases used in enterprise environments.
Gain practical DBA skills that help you manage high-performance and secure database systems.