All Courses
Topics Covered:
- Introduction to SQL & Linux
- Oracle 19C Architecture
- Oracle 19C Database Installation
- Database Upgrade 12c to 19c
- Oracle Multitenant Architecture
- User Management
- Tablespace Management
- Export/Import/Datapump
- RMAN Backup & Restoration
- Oracle DataGuard
- Performance Tuning
- Shell Scripting
- Database Monitoring [OEM]
- Database Patching
- Real Time Scenarios
Rs 14999 Book Demo
Topics Covered:
- Introduction to Grid Infra And Clusterware
- Oracle Clusterware Architecture
- Grid Infrastructure Installation
- ASM Overview & Architecture
- Administering ASM Instances
- Administering ASM Disk Groups
- RAC Databases Overview & Architecture
- Installing And Configuring Oracle RAC
- Oracle RAC Administration
- Managing Backup And Recovery For RAC
- Managing Cluster Nodes
- Upgrade Patch Grid Infra And Oracle RAC
- Multitenant Architecture And RAC DB
- Database Monitoring [OEM]
- Real Time Scenarios
Rs 14999 Book Demo
Topics Covered:
- Introduction to Oracle GoldenGate & Different Architectures
- Installing Oracle Golden Gate 19c
- Upgradation of Goldengate – 12c to 19c
- Oracle GoldenGate Replication setup – Prerequisites & Configuration
- OGG process Data Flow, Troubleshooting techniques
- Oracle GoldenGate Parameter files
- Performing Initial Load & Strategize troubleshooting issues
- Zero Downtime Upgradation & Migration and Data filteration in OGG
- DDL Replication
- Bidirectional Replication & Auto CDR
- Performance of Oracle Goldengate
- Oracle Goldengate Security
- Troubleshoot Goldengate Issues
- Oracle GoldenGate Veridata
- Real Time Scenarios
Rs 14999 Book Demo
Oracle Performance Tuning 19c DBA
Topics Covered:
- Introduction to Oracle Database Performance Tuning
- Introduction to Oracle Database Performance Tuning Tools
- Wait Events
- Managing Automatic Workload Repository (AWR)
- Using Automatic Database Diagnostic Monitor (ADDM)
- Using Active Session History (ASH)
- SQL Tracing
- Handling Enqueue Waits
- Handling Latch and Mutex Contention
- Tuning SGA
- Handling Row Migration and Row Chaining
- Diagnosing Table Fragmentation
- Introducing In-Memory Column Store
- Monitoring OS Performance using Linux Utilities
- Real Time Scenarios
Rs 14999 Book Demo
Oracle Database Admin I: 1Z0-082 – 19c
Topics Covered:
- Understanding Oracle Database Architecture
- Managing Database Instances
- Managing Users, Roles and Privileges
- Managing Storage
- Moving Data (SQL*Loader, Datapump)
- Accessing an Oracle Database with Oracle supplied Tools
- Configuring Oracle Net Services
- Managing Tablespaces and Datafiles
- Managing Undo
- Oracle Database: Introduction to SQL
- 1Z0-082: Exam Examples
- 1Z0-082: Exam dumps
Rs 9999 Book Demo
Oracle Database Admin II: 1Z0-083 – 19c
Topics Covered:
- Create & Manage CDBs and Regular PDBs
- Backup and Duplicate
- Upgrading and Transporting CDBs and Regular PDBs
- Manage Application PDBs
- Manage Security in Multitenant databases
- Recovery and Flashback
- Backup Restore and Recovery Strategies and Terminology
- Using Flashback Technologies
- Duplicating a Database
- Configuring and Using RMAN
- Performing Recovery
- RMAN Troubleshooting and Tuning
- Install & Patch Grid Infrastructure and Oracle Database
- Creating an Oracle Database by using DBCA
- Oracle Restart
- Upgrade the Oracle Database
- Install Grid Infrastructure for a Standalone server
- Using Availability,Diagnosibility Database Enhancements
- Monitoring and Tuning Database Performance
- Tuning SQL Statements
- 1Z0-083: Exam Examples
- 1Z0-083: Exam dumps
Rs 14999 Book Demo