Oracle DBA 19c & 12c - New Features
35 hours
- Multitenant Architecture
- Installation & Configuration
- Creation CDB & PDB
- Upgrade and Patching in Oracle 19c
Oracle GoldenGate 19c
30 hours
- GoldenGate Architecture
- Installation of GoldenGate
- Oracle to Oracle GG Replication
- Bi-Directional Replication
Oracle RAC 19c
40 hours
- Oracle RAC 19c Architecture
- Installation of Oracle RAC 19c
- SRVCTL & CRSCTL Tools
- ASM
Oracle Data Guard 19c
30 hours
- Oracle DG Architecture
- Configure Physical Standby
- Configure DG Broker
- Rolling Upgrade in DG
Oracle DBA 19c
50 hours
- Oracle Database 19c Architecture
- Installation of Oracle DB 19c on OEL 7
- CDB and PDB Databases
- Backup , Restore , Upgrade & Patching
Oracle DB Performance Tuning 19c
30 hours
- Oracle Database Architecture
- Performance Tuning Tools
- Waiting Events , AWR , ADDM , ASH
- Shared Pool , Buffer Cache Tuning
Microsoft SQL DBA
50 hours
- Installation and Configuration
- SQL Server 2017 Basic
- Backup , Restore and Recovery
- SQL Server Security
Oracle SQL Tuning 19c
30 hours
- Query Optimizer
- Execution Plan , Statistics
- Cursor Sharing , SQL Tuning Sets
- SQL Tuning Advisor , Indexes , Hints
Oracle SQL and PL/SQL Programming
30 hours
- SQL Command , Joins , Grouping
- SQL Functions , Set Operations
- Views ,Sequences , Indexes
- PL/SQL Programming