All Courses

Module 1: Oracle Secure Backup Overview Module 2: Installing Oracle Secure Backup Module 3: Securing Domain and Data Module 4: Configuring RMAN for Oracle Secure Backup Module 5: Performing RMAN Backups and Restores Module 6: Backing Up File-System Data with Oracle Secure Backup Module 7: Restoring File-System Backups with Oracle…

Module 1: Oracle Real Applications Clusters Overview Module 2: Installing and Configuring Grid Infrastructure Module 3: Installation and Configuration of the Clustered Database Module 4: Managing a RAC Database in a Solaris Environment

Module 1: Oracle Grid Infrastructure Module 2: Installation and Upgrade Enhancements Module 3: Oracle Restart Module 4: ASM Enhancements Module 5: Storage Enhancements Module 6: Data Warehouse and Partitioning Enhancements Module 7: Oracle SecureFiles Module 8: Security and Networking Enhancements Module 9: SQL Performance Analyzer Module 10: SQL Plan Management…

Module 1: Grid Infrastructure Concepts Module 2: Grid Infrastructure Installation and Configuration Module 3: Administering Oracle Clusterware Module 4: Managing Oracle Clusterware Module 5: Oracle Clusterware High Availability Module 6: Troubleshooting Oracle Clusterware Module 7: Administering ASM Instances Module 8: Administering ASM Disk Groups Module 9: ASM Files, Directories, and…

Module 1: Oracle Database 11g: Introduction to Database Security and Solutions Module 2: Oracle Database 11g: Database Security Module 3: Oracle Database 11g: Database Auditing Module 4: Oracle Database 11g: Basic User and Strong Authentication Module 5: Oracle Database 11g: Enterprise User Security and Proxy Authentication Module 6: Oracle Database…

Module 1: Introduction Module 2: Overview of Oracle Spatial Concepts Module 3: Creating Spatial Layers Module 4: Defining Collection Geometries Module 5: Associating Spatial Layers with Coordinate Systems Module 6: Loading Spatial Data Module 7: Validating and Debugging Geometries Module 8: Using the Oracle Application Server MapViewer Module 9: Indexing…

Module 1: Introduction to Oracle Data Guard Module 2: Creating a Physical Standby Database by Using SQL and RMAN Commands Module 3: Oracle Data Guard Broker: Overview Module 4: Creating a Data Guard Broker Configuration Module 5: Creating a Physical Standby Database by Using Enterprise Manager Grid Control Module 6:…

Module 1: Introduction to Oracle Data Guard Module 2: Creating a Physical Standby Database by Using SQL and RMAN Commands Module 3: Oracle Data Guard Broker: Overview Module 4: Creating a Data Guard Broker Configuration Module 5: Creating a Physical Standby Database by Using Enterprise Manager Grid Control Module 6:…

Module 1: Introduction to Oracle Audit Vault and Database Firewall Module 2: Planning the Oracle Audit Vault and Database Firewall Implementation Module 3: Installing the Audit Vault Server Module 4: Configuring the Audit Vault Server Module 5: Configuring Oracle AVDF and Deploying the Audit Vault Agent Module 6: Networking and…

Module 1: Introduction Module 2: Database Vault Overview Module 3: Analyzing Privileges 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: Auditing with Database Vault Reports Module 10: Implementing Best Practices

Module 1: Introduction Module 2: Using Basic and Strong User Authentication Module 3: Configuring Global User Authentication Module 4: Using Proxy Authentication Module 5: Encryption Concepts and Solutions Module 6: Using Built-In Encryption in Applications Module 7: Using Transparent Data Encryption (TDE) Module 8: Database Storage Security Module 9: Introduction…

Module 1: Introduction Module 2: Understanding Security Requirements Module 3: Choosing Security Solutions Module 4: Implementing Basic Database Security Module 5: Configuring Network Security Module 6: Discovering Basic Configuration Issues

Module 1: Introduction Module 2: Installing Oracle Key Vault Module 3: Working with Endpoints Module 4: Managing Oracle Wallets Module 5: Using Direct TDE with Oracle Database 12c Module 6: Performing Oracle Key Vault Administrative Tasks

Module 1: Introduction Module 2: Using Unified Audit Module 3: Using Fine-Grained Audit Module 4: Introduction to Oracle Audit Vault and Database Firewall (AVDF) Module 5: Planning the Oracle Audit Vault and Database Firewall Implementation Module 6: Installing the Audit Vault Server Module 7: Configuring the Audit Vault Server Module…

Module 1: Introduction Module 2: Using Application Contexts Module 3: Implementing Virtual Private Database Module 4: Implementing Real Application Security Module 5: Implementing Oracle Label Security

Module 1: Introduction to Oracle Audit Vault and Database Firewall Module 2: Performing Administrative Tasks Module 3: Creating Audit Policies for Oracle Databases Module 4: Creating Database Firewall Policies Module 5: Oracle AVDF Reports Module 6: Managing Entitlements Module 7: Creating Alerts

Module 1: Architecture, SQL Tuning, and Optimization Module 2: Indexes, Access Paths, and Join Operations Module 3: Execution Plans and Star Transformations Module 4: Optimizer Statistics, Hints, and Cursor Sharing Module 5: Application Tracing and Automatic SQL Tuning

Module 1: Introduction Module 2: Grouping and Aggregating Data Using SQL Module 3: Hierarchical Retrieval Module 4: Working with Regular Expressions Module 5: Analyzing and Reporting Data Using SQL Module 6: Performing Pivoting and Unpivoting Operations Module 7: Pattern Matching using SQL Module 8: Modeling Data Using SQL Module 9:…

Module 1: Introduction Module 2: PL/SQL Programming Concepts Review Module 3: Designing PL/SQL Code Module 4: Using Collections Module 5: Manipulating Large Objects Module 6: Using Advanced Interface Methods Module 7: Performance and Tuning Module 8: Improving Performance with Caching Module 9: Analyzing PL/SQL Code Module 10: Profiling and Tracing…

Module 1: Introduction Module 2: Working with Oracle Cloud Exadata Express Cloud Service Module 3: Restricting and Sorting Data Module 4: Using Single-Row Functions to Customize Output Module 5: Using Conversion Functions and Conditional Expressions Module 6: Reporting Aggregated Data Using the Group Functions Module 7: Displaying Data from Multiple…

Module 1: Introduction Module 2: Introduction to PL/SQL Module 3: Declaring PL/SQL Variables Module 4: Writing Anonymous PL/SQL blocks Module 5: Using SQL Statements within a PL/SQL Block Module 6: Writing Control Structures Module 7: Working with Composite Data Types Module 8: Using Explicit Cursors Module 9: Handling Exceptions Module…

Module 1: Introduction Module 2: Working with Oracle Database Exadata Express Cloud Service Module 3: Creating Stored Procedures Module 4: Creating Functions and Debugging Subprograms Module 5: Creating Packages Module 6: Working With Packages Module 7: Using Oracle-Supplied Packages in Application Development Module 8: Using Dynamic SQL Module 9: Creating…

Module 1: Introduction Module 2: Working with Oracle Cloud Exadata Express Cloud Service Module 3: Introduction to PL/SQL Module 4: Declare PL/SQL Variables Module 5: Write Anonymous PL/SQL Blocks Module 6: SQL Statements in a PL/SQL block Module 7: Control Structures Module 8: Composite Data Types Module 9: Explicit Cursors…

Module 1: Introduction Module 2: Retrieving Data using the SQL SELECT Statement Module 3: Restricting and Sorting Data Module 4: Using Single-Row Functions to Customize Output Module 5: Using Conversion Functions and Conditional Expressions Module 6: Reporting Aggregated Data Using the Group Functions Module 7: Displaying Data From Multiple Tables…