Corvit Systems Peshawar offers a comprehensive Oracle Database Administrator (DBA) course designed to equip students with essential skills to manage, secure, and maintain Oracle databases. This hands-on course, taught by industry expert Sir Noor Hassan, covers everything from the basics of multitenant architecture to advanced backup, recovery, and performance tuning strategies using Oracle 19c.
Trainer: Sir Noor Hassan (Oracle Certified Professional)
Duration: 2.5 Months
Fees: Rs. 24,000
Oracle Database 19c New and Enhanced Features
Objectives
Challenges
Oracle Database in 11g Release
High Performance Systems
New Multitenant Architecture: Benefits
Other Benefits of Multitenant Architecture
Multitenant Container Database
Separating SYSTEM and User Data
Naming the Containers
Provisioning a Pluggable Database
Basics of Multitenant Container Database and Pluggable Databases
Interacting Within Multitenant Container Database
Exploring CDB Architecture and Structure
Steps to Create a Multitenant Container Database
Creating a Multitenant Container Database Using SQL*Plus
Exploring CDB and PDB Structures
Create New PDB from PDB$SEED
Starting Up a CDB Instance
Mounting a CDB
Opening a CDB
Opening a PDB
Closing a PDB
Shutting Down a CDB Instance
Creating after Startup Trigger to Open All PDBs
Changing PDB Mode
Instance Parameter Changes and its Impact on PDBs
Creating Permanent Tablespaces in a CDB
Assigning Default Tablespaces
Creating Local Temporary Tablespaces
Assigning Default Temporary Tablespaces
Users, Roles, and Privileges
Local Users, Roles, and Privileges
Creating a Local User
Common Users
Creating a Common User
Common and Local Schemas / Users
Common and Local Privileges
Granting and Revoking Privileges
Creating Common and Local Roles
Granting Common or Local Privileges / Roles to Roles
Granting Common and Local Roles to Users
Granting and Revoking Roles
Whole CDB Backup
User-Managed Hot CDB Backup
Partial CDB Backup
Whole PDB Backup
Partial PDB Backup
SQL PDB Hot Backup
SQL Control File Backup
Full Transportable Export/Import Overview
Full Transportable Export/Import Usage
Full Transportable Export/Import Example
Transporting a Database over the Network Example
Exporting Views as Tables Overview
Exporting Views as Tables Usage
Exporting Views as Tables Command-Line Examples
Compressing Tables during Import
SQL*Loader and External Table Enhancement
Objectives
Connecting to the Database Instance
Oracle Net Services: Overview
Defining Oracle Net Services Components
Tools for Configuring and Managing Oracle Net Services
Oracle Net Listener: Overview
The Default Listener
Establishing Oracle Network Connections
Name Resolution
Establishing a Connection
Creating Database Services
RMAN Features and Components
The sysbackup Privilege
RMAN Commands
Connect to RMAN
Specify the Location of RMAN Output
Start Up and Shut Down a Target Database Using RMAN
Issue SQL Commands in RMAN
Create a Recovery Catalog
Register a Database
Unregister a Database
Control File Information
Set Retention Policies
Configure Control File Autobackups
Channel Allocation
Types of RMAN Backup
Recovery Manager Commands
Performing Backups
Closed and Open Backups
Incremental Backups
Fast Incremental Backups using Block Change Tracking
Oracle Suggested Backup
Validate Backups
Listing Backups
Change the Availability Status of Backups and Copies
Catalog Backups Made with Operating System Commands
Generate Backup Reports and Lists
Cross Check Backups and Copies
Delete Backups
Update the Repository after Backup Deletion
Drop Database and Archival Backups
Import and Export the Recovery Catalog
Use Data Dictionary Tables
Restore and Recover
Instance Failure and Crash Recovery
Media Failure
An Overview of Complete Recovery
An Overview of Point in Time Recovery
Recovery with RESETLOGS
Perform Complete Recovery in Archivelog Mode
Use the Flash Recovery Area for Fast Recovery
Identify the Database Files to Restore and Recover
Perform Incomplete Recovery (PITR)
Restore and Recover a tablespace
Restore and Recover Datafiles
Recover a Datafile Not Backed Up
Restore the Server Parameter File
Restore the Control File
Re-create the Password File
Handling Redo Log File Loss
Trusted institute with a solid reputation in IT and database training
Oracle Certified Professional (OCP) instructor – Sir Noor Hassan
Comprehensive coverage of Oracle DBA 19c, including CDB, PDB, RMAN, and Net Services
100% practical, hands-on training with real-time database management experience
Updated course content aligned with industry standards and certification requirements
Modern lab environment and real-world scenarios for effective learning
Focus on backup, recovery, performance tuning, and security
Affordable fee structure with flexible class timings
Guidance for certification and job preparation
Excellent track record of student success in the field of database administration
Spaces are limited — Don’t miss out on this opportunity.
Location: Main university road jehangir abad city tower plaza office No 201 block B second floor Corvit systems Peshawar
Expert IT & Tech Courses at Corvit Systems Peshawar – Build your future.
© 2025 Corvit Systems Peshawar. All rights reserved.
Stay updated with the latest courses, new batch timings, admission info, and special announcements from CORVIT SYSTEMS PESHAWAR.