top of page
Login
Image by Pat Whelen

Perfect career with perfect training

Administer Multi-Terabyte Database Easily

Administer container databases along with database backup & recovery.

Sessions and Duration

  • 3 weeks training starting July 15, 2024

  • From Monday to Friday


Timings:

  • 04:00 pm - 05:00 pm IST (Indian Standard Time)

  • 06:30 am - 07:30 am EST (Eastern Standard Time)

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

Oracle 21c DBA For Freshers

Oracle 21c DBA For Freshers

Single monitoring tool for all your Oracle deployments

Learn to deploy, test, manage, operate and setup OEM in a Linux environment.

Sessions and Duration

  • Starting Jun 24, 2024 - One week training

  • From Monday to Saturday


Timings:

  • 04:00 pm - 05:00 pm IST (Indian Standard Time)

  • 06:30 am - 07:30 am EST (Eastern Standard Time)

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

Oracle Enterprise Manager 13c

Oracle Enterprise Manager 13c

Switch Roles, Tune Data Guard and Setup Broker

Data Guard Broker automates failover operation for you and also takes care of all the standby databases by transmitting redo entries.

Sessions and Duration

  • Starting May 20, 2024 - One week training

  • From Monday to Saturday


Timings:

  • 04:00 pm - 05:00 pm IST (Indian Standard Time)

  • 06:30 am - 07:30 am EST (Eastern Standard Time)

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

Oracle 19c Data Guard

Oracle 19c Data Guard

Host Oracle Database on Top of ASM Diskgroups

Gain the expertise you need to master the latest features and capabilities of Oracle's most advanced database technology.

Sessions and Duration

  • 1 week training starting April 22, 2024

  • From Monday to Friday


Timings:

  • 04:00 pm - 05:00 pm IST (Indian Standard Time)

  • 06:30 am - 07:30 am EST (Eastern Standard Time)

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

Oracle 19c ASM Administration

Oracle 19c ASM Administration

Notification Message!

bottom of page