All Courses

Introduction Retrieving Data using the SQL SELECT Statement Restricting and Sorting Data -Using Single Row Functions to Customize Output Using Conversion Functions and Conditional Expressions Reporting Aggregated Data Using the Group Functions Displaying Data From Multiple Tables Using Joins Using Subqueries to Solve Queries Using the SET Operators Managing Tables…

Module 1: CDB Basics Module 2: CDB and Regular PDBs Module 3: Application PDBs and Application Installation Module 4: PDB Creation Module 5: CDB and PDB Management Module 6: Storage Module 7: Security Module 8: Backup, Recovery, and Flashback Module 9: Performance Monitoring Module 10: Resources Allocation Module 11: Data…

Module 1: Oracle ASM Module 2: Overview Oracle ASM Instance Administration Module 3: Flex ASM Module 4: Administering ASM Disk Groups

Module 1: Enterprise Manager and Other Tools -Basics of Multitenant Module 2: Container Database (CDB) Module 3: Configuring and Creating CDB and PDBs -Managing CDB and PDBs Module 4: Managing Tablespaces, Common and Local Users, Privileges and Roles Module 5: Managing Backup / Recovery / Flashback Module 6: Online Datafile…

Module 1: Oracle ASM Overview Module 2: Oracle ASM Instance Administration Module 3: Flex ASM Module 4: Administering ASM Disk Groups Module 5: Administering ASM Files, Directories, and Templates Module 6: Flex ASM Disk Group Module 7: Administering ASM Files, Directories, and Templates Module 9: ACFS/ADVM Enhancements Module 10: Oracle…

Module 1: Introduction Module 2: Exadata Database Machine Overview Module 3: Exadata Database Machine Architecture Module 4: Key Capabilities of Exadata Database Machine Module 5: Exadata Database Machine Initial Configuration Module 6: Exadata Storage Server Configuration Module 7: I/O Resource Management Module 8: Recommendations for Optimizing Database Performance Module 9:…

Module 1: Introduction to Clusterware Module 2: Oracle Clusterware Architecture Module 3: Cluster Configuration Options Module 4: Grid Infrastructure Pre-Installation Tasks Module 5: Grid Infrastructure Installation Module 6: Managing Cluster Nodes Module 7: Traditional Clusterware Management Module 8: Policy-Based Cluster Management Module 9: Patching Grid Infrastructure Module 10: Monitoring and…

Module 1: Introduction Module 2: Overview of Database Vault Module 3: Configuring Database Vault Module 4: Configuring Realms Module 5: Defining Rule Sets Module 6: Configuring Command Rules Module 7: Extending Rule Sets Module 8: Configuring Secure Application Roles Module 9: Viewing Database Vault Reports Module 10: Implementing Best Practices

Module 1: Overview of Oracle Database Administration Module 2: Installing the Database and Creating the Database Module 3: Using Oracle Enterprise Manager Database Control and SQL-Based Management Tools Module 4: Configuring the Oracle Network Environment Module 5: Managing the Oracle Instance Module 6: Managing Database Storage Structures Module 7: Administering…

Module 1: Introduction to Partitioning Module 2: Implementing Partitioned Tables Module 3: Implementing Partitioned Indexes Module 4: Maintenance of Partitioned Tables and Indexes Module 5: Partitioning Administration and Usage Module 6: Partitioning and Workload Types

Module 1: Single Instance High Availability Module 2: The RAC One Node Database Module 3: Administering Oracle RAC One Node Module 4: Implementing Oracle RAC One Node

Module 1: Oracle Grid Infrastructure Concepts Module 2: Oracle Clusterware Architecture Module 3: Grid Infrastructure Pre-installation Tasks Module 4: Grid Infrastructure Installation Module 5: Adding and Removing Cluster Nodes Module 6: Administering Oracle Clusterware Module 7: Upgrading and Patching Grid Infrastructure Module 8: Troubleshooting Oracle Clusterware Module 9: Making Applications…

Module 1: Oracle Database 11g Release 2: Installation and Oracle Restart Module 2: Oracle Database 11g Release 2: ASM, Storage and Partitioning Enhancements Module 3: Oracle Database 11g Release 2: Oracle Partitioning and Security Features Module 4: Oracle Database 11g Release 2: Using Change Management Solutions Module 5: Oracle Database…

Module 1: Review of Linux Basics Module 2: Preparing Linux for Oracle Module 3: Installing Oracle on Linux Module 4: Managing Storage on Linux Module 5: Using Oracle ASM on Linux Module 6: Automating Oracle on Linux Module 7: Optimizing Linux for Oracle Module 8: Additional Linux Tips for DBAs…

Introduction Managing Storage HA: Using the DRA and Flashback HA: RMAN and Data Guard Security: New Features Intelligent Infrastructure Datawarehousing Enhancements Additional Performance Enhancements

Module 1: Introduction to Oracle Database Firewall Module 2: Installing Oracle Database Firewall Module 3: Configuring Oracle Database Firewall Module 4: Configuring Policies Module 5: Creating Advanced Configuration Policies Module 6: Reporting Module 7: Stored Procedure Auditing Module 8: User Role Auditing Module 9: Configuring and Using Local Monitoring Module…

Module 1: Oracle Streams: Overview Module 2: Configuring Simple Streams Replication Module 3: Customizing Streams with Rules Module 4: Capture Process: Concepts and Manual Configuration Module 5: Instantiation Module 6: Propagation Concepts and Manual Configuration Module 7: Apply Concepts and Manual Configuration Module 8: Transformations Module 9: Apply Handlers Module…

Module 1: Introduction Module 2: Data Warehousing, Business Intelligence, OLAP, and Data Mining Module 3: Defining Data Warehouse Concepts and Terminology Module 4: Business, Logical, Dimensional, and Physical Modeling Module 5: Database Sizing, Storage, Performance, and Security Considerations Module 6: The ETL Process: Extracting Data Module 7: The ETL Process:…

Module 1: Exploring the Oracle Database Architecture Module 2: Installing your Oracle Software Module 3: Creating an Oracle Database Module 4: Managing the Oracle Database Instance Module 5: Manage the ASM Instance Module 6: Configuring the Oracle Network Environment Module 7: Managing Database Storage Structures Module 8: Administering User Security…

Module 1: Introduction Module 2: Using Recovery Manager (RMAN) and Enterprise Manager Module 3: Configuring for Recoverability Module 4: Using the RMAN Recovery Catalog Module 5: Backup Concepts and Strategies Module 6: Creating Backups Module 7: Restore and Recovery Concepts Module 8: Using Data Recovery Advisor Module 9: Performing Recovery…

Module 1: Introduction to Oracle Audit Vault Module 2: Installing the Oracle Audit Vault Server Module 3: Installing the Oracle Audit Vault Collection Agent Module 4: Configuring Oracle Audit Vault Module 5: Managing Audit Settings Module 6: Configuring for Alerts and Reports Module 7: Using Oracle Audit Vault Reports Module…

Module 1: Oracle Database 11g Release 2: Database Architecture and Recovery Operations Module 2: Oracle Database 11g Release 2: The RMAN Catalog and Creating Backups Module 3: Oracle Database 11g Release 2: Performing Restore and Recovery Tasks Module 4: Oracle Database 11g Release 2: Using, Monitoring and Tuning RMAN Module…

Module 1: Introduction Module 2: Monitoring With Basic Tools Module 3: Using Automatic Workload Repository Module 4: Identifying the Problem Module 5: Identifying Problem SQL Statements Module 6: Influencing the Optimizer Module 7: SQL Plan Management Module 8: Change Management Module 9: Using Metrics and Alerts Module 10: Using AWR…

Module 1: Grid Infrastructure: Overview Module 2: RAC Concepts Module 3: Installing and Configuring Oracle RAC Module 4: Oracle RAC Administration Module 5: Managing Backup and Recovery for RAC Module 6: Global Resource Management Concepts Module 7: RAC Database Monitoring and Tuning Module 8: Managing High Availability of Services Module…