TRAINING CATALOGUE

Oracle Database Administration

  • Database Configuration and Management
  • Database Objects
  • SQL and PL/SQL
  • Network and Connection Management
  • Monitoring and Management Tools
  • Data Backup and Restore
  • Performance Tuning
  • Security Management
  • Data Migration and Migration
  • High Availability and Disaster Recovery

Oracle Database Backup & Recovery

  • Backup Strategies
  • Physical Backup Techniques
  • Logical Backup Techniques
  • Using RMAN (Recovery Manager)
  • Data Recovery Scenarios
  • Restore and Recovery with RMAN
  • Point-in-Time Recovery (PITR)
  • Flashback Technologies
  • Backup and Recovery Performance

Oracle Database Patch & Upgrade

  • Patch and Upgrade Terminology
  • Patch Management
  • Oracle Patch Types and Categories
  • Patch Application Processes
  • Oracle Database Upgrade Planning
  • Pre-Upgrade Preparations
  • Upgrade Methodologies
  • Oracle Database Upgrade Tools
  • Post-Upgrade Checks and Tests
  • Rollback Strategies

Oracle RAC, ASM & Grid Infrastructure

  • Grid Infrastructure Components
  • Oracle ASM Architecture
  • Grid Infrastructure & ASM Installation and Configuration
  • Oracle RAC Architecture
  • Oracle RAC Installation and Configuration
  • Clusterware Management and Monitoring
  • RAC and ASM Performance Tuning
  • RAC and ASM Security Management
  • Error Diagnosis and Resolution

Oracle Data Guard Administration

  • Oracle Data Guard Architecture
  • Data Guard Installation and Configuration
  • Physical and Logical Standby
  • Data Guard Broker Usage
  • Data Synchronization and Replication
  • Switchover and Failover Processes
  • Data Protection Modes
  • Performance Tuning and Optimization
  • Data Guard Monitoring and Management
  • Disaster Recovery Scenarios and Planning

Oracle Exadata Administration

  • Oracle Exadata Architecture
  • Exadata Hardware and Software Components
  • Exadata Installation and Configuration
  • Storage Cell Management
  • Smart Scan and Smart Flash Cache
  • Image and Firmware Updates
  • Performance Optimization
  • Exadata Management Tools and Techniques
  • Exadata Security Management
  • Backup and Restore Strategies
  • High Availability and Disaster Recovery
  • Exadata Fault Diagnosis and Resolution

Oracle Database PL/SQL Programming

  • PL/SQL Programming Architecture
  • Data Types and Variables
  • Control Structures
  • Loops and Conditional Statements
  • Subprograms: Procedures and Functions
  • PL/SQL Packages
  • Error Handling and Exceptions
  • PL/SQL Triggers
  • Dynamic SQL and PL/SQL
  • Performance Tuning and Optimization
  • Security and Authorization
  • Advanced Applications with PL/SQL

Oracle Database Security

  • Oracle Database Security Components
  • User Management and Authorization
  • Use and Management of Roles
  • Database Object Security
  • Encryption Methods
  • Data Masking Techniques
  • Database Auditing and Monitoring
  • Virtual Private Database (VPD) Usage
  • Database Vault Usage
  • Transparent Data Encryption (TDE)
  • Oracle Label Security (OLS)
  • Firewall Configuration
  • Security Policies and Practices
  • Security Audits and Reporting

Oracle Database Performance Tuning

  • Database Performance Monitoring and Measurement Tools
  • Indexing Strategies and Optimization
  • Database Statistics and Statistics Collection
  • Memory Management and Optimization
  • Disk I/O Management and Optimization
  • Database Parameter Settings and Configuration Improvements
  • Parallel Processes and Performance Impacts
  • Cache Management and Usage
  • Diagnostic Packages and Performance Troubleshooting
  • Real Application Testing and Performance Validation

Linux System Administration for DBA

  • Linux Operating System Fundamentals
  • Basic Linux Command Line (CLI) Usage
  • File and Directory Management
  • User and Group Management
  • System Logs (Logs) and Monitoring Tools
  • Basic Network Management and Settings
  • Disk Management and File Systems
  • Package Management and Software Installation
  • Basic Security and Access Controls
  • System Performance Monitoring and Tuning
  • Basic Debugging and Troubleshooting
  • Automatic Jobs and Management (Cron)
  • Shell Scripting Fundamentals

SQL Programming

  • SQL Basics and Introduction
  • Data Query (SELECT)
  • Data Insertion (INSERT)
  • Data Update (UPDATE)
  • Data Deletion (DELETE)
  • Advanced SELECT Statements
  • Subqueries and Joins (JOIN)
  • GROUP BY, HAVING
  • Arrays (ARRAYS) and Usage
  • Data Types and Operators
  • SQL Functions and Procedures
  • Dynamic SQL and Parameters
  • Error Handling and Exceptions

SQL Performance Tuning

  • SQL Performance Optimization Fundamentals
  • Data Modeling and Normalization
  • Data Indexing and Optimization
  • Writing and Optimizing SQL Queries
  • Collecting and Using SQL Statistics
  • DML Performance Optimizations
  • JOIN Operators and Performance Impacts
  • Parallel Queries and Performance Optimizations
  • Database Monitoring Tools and Usage
  • SQL Plan Management and Optimization

PostgreSQL Database Administration

  • Understanding PostgreSQL Architecture
  • PostgreSQL Database Installation and Configuration
  • Database Object Management (Tables, Indexes, Views)
  • Data Backup and Restore Operations
  • PostgreSQL Security Management (User Management, Access Controls)
  • Performance Tuning and Optimization
  • SQL and PL/pgSQL Programming
  • High Availability and Disaster Recovery Strategies
  • PostgreSQL Monitoring and Management Tools

PostgreSQL Database Backup & Recovery

  • Backup Strategies
  • WAL Concept and Recovery
  • PostgreSQL Point-in-Time Recovery (PITR)
  • Using pg_dump and pg_dumpall
  • Backing up with pg_basebackup
  • Backing up with pg_backrest
  • Backing up with barman
  • Managing and Storing Backup Files
  • Planning and Automating Backup Strategies
  • Restore Scenarios and Applications

PostgreSQL Replication and High Availability

  • PostgreSQL Replication Basics
  • Streaming Replication and Asynchronous Replication
  • Standby Server Installation and Configuration
  • Data Flow Between Servers
  • Replication Slot Concept and Usage
  • Replication and Load Balancing
  • Point-in-Time Recovery (PITR) Applications
  • Patroni Installation and Configuration
  • Etcd Usage and Configuration
  • Patroni Error Scenarios and Solutions

PostgreSQL Database Security

  • User Management and Authorization
  • Data Encryption and Security
  • Database Access Controls (GRANT and REVOKE)
  • SSL/TLS Certificates and Secure Connections
  • Audit and Log Management
  • PostgreSQL Extensions and Security
  • Debugging and Vulnerabilities
  • Database Firewall Applications
  • Data and Security Policies

PostgreSQL Database Performance Tuning

  • Database Statistics
  • Writing and Optimizing SQL Queries
  • Indexing Strategies and Optimizations
  • Data Modeling and Normalization
  • Disk I/O Management and Optimization
  • Memory Management and Caching
  • Parallel Query Management and Performance Optimizations
  • PostgreSQL Performance Monitoring Tools
  • Using Logs and Diagnostic Data in Performance Management