Module 1: PL/SQL Basics

• PL/SQL block structure

• Variables and data types

• Conditional statements (IF, CASE)

• Loops (WHILE, FOR)

• Exception handling (TRY-CATCH)

​

Module 2: SQL in PL/SQL

• Embedding SQL in PL/SQL

• Cursors in PL/SQL

• Implicit vs. explicit cursors

• Cursor attributes and operations

​

Module 3: PL/SQL Procedures

• Creating and executing procedures

• Input and output parameters

• Calling procedures from SQL and PL/SQL

Module 4: PL/SQL Functions

• Creating and executing functions

• Returning values from functions

• Calling functions from SQL and PL/SQL

Module 5: PL/SQL Triggers

• Introduction to triggers

• Trigger types (BEFORE, AFTER, INSTEAD OF)

• Trigger syntax and execution

• Trigger examples and use cases

Module 6: PL/SQL Packages

• Understanding packages

• Creating and using packages

• Package specifications and bodies

• Access control and encapsulation

Module 7: Dynamic SQL in PL/SQL

• Dynamic SQL concepts

• EXECUTE IMMEDIATE statement

• Dynamic SQL examples

• Security considerations

Module 8: Error Handling and Debugging

• Error handling best practices

• DBMS_ERRLOG and EXCEPTION_INIT

• Debugging tools and techniques

• Profiling and performance tuning

Module 1: Oracle 21c Architecture

• LRU Algorithm & User Connection

• SQL Parsing, DML & DDL Processing

• Oracle Background Processes

• Oracle Database Files

Module 2: Oracle 21c Installation

• Oracle 21c Pre-requisites

• Install / Deinstall Oracle 21c

• Silent vs GUI Installation

Module 3: Create Multi-Tenant Database

• Standalone vs Multi-Tenant

• CDB vs PDBs

• Create 21c Container Database

• Multi-Tenant Startup / Shutdown Modes

• Switching Conainers

Module 4: Instance Administraiton

• Oracle Memory Management

• Oracle Metadata

• Sizing Oracle Instance

Module 5: Storage Administraiton

• Database Archive Log Mode

• Oracle Storage Structures

• Multi-Tenant Tablespace Administration

• Oracle Data Files Administration

• Database Capacity Planning

Module 6: User Administraiton

• Database Users & Namespaces

• User Roles & Permissions

• Multi-Tenant Users

• Grant & Revoke User Permissions

Module 7: Network Administration

• Oracle Listener & TNS

• Remote User Connectivity

• Automate Listener Startup

Module 8: Oracle Data Pump

• Export Table / Schema / Full Database

• Import Table / Schema / Full Database

• Data Pump Performance Tuning

Module 9: Oracle Backup & Recovery

• Export Table / Schema / Full Database

• Import Table / Schema / Full Database

• Data Pump Performance Tuning

• RMAN FULL Backup & Recovery

• RMAN Incremental Backup & Recovery

• Automate RMAN Backups

Module 10: Oracle Performance Tuning

• What Slows Down Database?

• Database Locks & Deadlocks

• Database Indexes

• FULL Table Scan vs Index Scan

• Oracle Execution Plan

• Oracle AWR, ADDM & ASH Reports

Module 11: Oracle Multi-Tenant Administration

• Clone PDB from Another PDB

• Pluggin & Un-plugging PDB

• Oracle Migration Methods

Module 12: Oracle 21c Project Work

Module 1: Architecture

• OEM Architecture

• OEM Environment

• OEM Deployment

Module 2: Configure OEM

• Configure Repository Database

• Install OEM 13.5

• Get familiar with OEM Dashboard

Module 3: OEM Administration

• OEM Start Stop

• Add / Remove Targets

• Administaring OEM Agent

• Administer HOST

• Administer Listener

• Administer Database

• Administer Credentials

Module 4: OEM DB Administration

• CDB / PDB Monitoring

• Clone DB via OEM

• Upgrade DB via OEM

Module 5: OEM Monitoring

• OEM Monitoring Templates

• Setup Metric Templates

• Notifications & Email Server

Module 6: Project Work

• Setup physical standby via OEM

• OEM Software Library

Module 1: Architecture

• Oracle High Availability

• Data Guard Architecture

• Data Guard Important Terms

• Setup Primary Server

Module 2: Setup Physical Standby

• Primary Database Changes

• Configure Redo Transport

• Create Physical Standby

• Playing with Log Shipping

• Data Guard Protection Modes

Module 3: Data Guard Administration

• Data Guard Networking

• Perform Switchover

• Perform Failover

• Switch to snapshot standby

• Switch to active data guard

• RMAN in Data Guard

Module 4: Setup Data Guard Broker

• Configure Data Guard Broker

• Switchover in Broker

• Failover in Broker

• FSFO - Fast Start Fail Over

Module 5: Project Work

• Convert Physical Standby to Logical Standby

• Final Assignment - Configure Cascading DR

Module 1: Architecture

• Understand ASM Components

• Single Instance vs RAC ASM

• Setup Cloud Server Pre-requisites

• ASM Stripping and Mirroring

Module 2: Setup 19c Grid + ASM

• Prepare Storage for ASM

• Download and Install 19c Grid

• Setup ASM Diskgroups

• Prepare Diskgroups for Database

Module 3: Create ASM Database

• DBCA Create Database on ASM

• Create ASM Tablespaces

• Manage FRA on ASM

Module 4: Administer ASM Instance

• Manage ASM Instance via SQL* PLUS

• Understand ASM Utilities

• Monitor ASM Diskgroups

• Add Disks to Diskgroups

• Create New Diskgroups

Module 5: Project Work

• Move Non-ASM Database to ASM
  Move Non-ASM Tablespace to ASM
  Move Non-ASM Datafile to ASM