Course Category: Oracle

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…

Module 1: Introduction Module 2: Retrieve Data using the SQL SELECT Statement Module 3: Restricted and Sorted Data Module 4: Usage of Single-Row Functions to Customize Output Module 5: Conversion Functions and Conditional Expressions Module 6:Aggregated Data Using the Group Functions Module 7: Display Data From Multiple Tables Module 8:…

Module 1: Introduction Module 2: Oracle Database Exadata Express Cloud Service Module 3: Overview of Collections Module 4: Using Collections in PL/SQL Module 5: Manipulating Large Objects Module 6: Working with JSON Data Module 7: Using Advanced Interface Methods Module 8: Performance and Tuning Module 9: Improving Performance with Caching…

Module 1: Introduction to MySQL Module 2: MySQL Server and Client Module 3: Database Basics Module 4: Designing Your Database Module 5: Data Types Module 6: Creating Databases and Tables Module 7: Modifying Databases and Tables Module 8: Querying Table Data Module 9: Modifying Table Data Module 10: Functions Module…

Module 1: Introduction Module 2: Introduction to SQL Tuning Module 3: Using Application Tracing Tools Module 4: Understanding Basic Tuning Techniques Module 5: Optimizer Fundamentals Module 6: Generating and Displaying Execution Plans Module 7: Interpreting Execution Plans and Enhancements Module 8: Optimizer: Table and Index Access Paths Module 9: Optimizer…

Module 1: What Is a Java Program? Module 2: Creating a Java Main Class Module 3: Data In the Cart Module 4: Managing Multiple Items Module 5: Describing Objects and Classes Module 6: Manipulating and Formatting the Data in Your Program Module 7: Creating and Using Methods Module 8: Using…

Module 1: Introduction Sample HR Schema Oracle Cloud Overview Oracle Database Editions, Options, and Management Packs Module 2: Oracle Database Architecture Automatic Storage Management (ASM) Overview Oracle Database Instance Configurations Oracle Database Memory and Process Structures Connecting to the Database Instance Logical and Physical Database Structures Multitenant Architecture Oracle Database…