All Courses

Module 1: Introduction Module 2: Performance Tuning Basics Module 3: Performance Tuning Tools Module 4: MySQL Server Tuning Module 5: MySQL Query Cache Module 6: InnoDB Module 7: MyISAM Module 8: Other MySQL Storage Engines and Issues Module 9: Schema Design and Performance Module 10: MySQL Query Performance Module 11:…

Introduction to MySQL Connectors and APIs Using Connectors Prepared Statements Handling Errors and Warnings Building Database-Driven Web Applications Tables and Views Working with Strings Working with Numeric and Temporal Data Transactions Optimizing Queries Stored Routines Triggers and Scheduled Events Reporting Spatial Data JSON Data Document Store NoSQL Conclusion

Module 1: Database Rolling Upgrade Using Transient Logical Standby Module 2: ASM Filter Driver Module 3: Flex ASM Module 4: Policy-Based Cluster Management, Policy-Managed Database and Oracle Multitenant Architecture Module 5: Flex Clusters Module 6: Oracle Database In-Memory Module 7: Application Continuity Module 8: Global Data Services Module 9: Oracle…

Module 1: Introduction Module 2: Exploring the Oracle Database Architecture Module 3: Oracle Software Installation Basics Module 4: Installing Oracle Database Software Module 5: Creating an Oracle Database by Using DBCA Module 6: Oracle Database Management Tools Module 7: Managing the Database Instance Module 8: Configuring the Oracle Network Environment…

Module 1: Introduction Module 2: Understanding Security Requirements Module 3: Choosing Security Solutions Module 4: Implementing Basic Database Security Module 5: Securing Data on the Network Module 6: Using Basic and Strong User Authentication Module 7: Configuring Global User Authentication Module 8: Using Proxy Authentication Module 9: Using Privileges and…

Module 1: Introduction Module 2: Introduction to PL/SQL Module 3: Writing Anonymous PL/SQL blocks Module 4: Declaring PL/SQL Variables 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: Grid Infrastructure Overview and Review Module 2: RAC Databases Overview & Architecture Module 3: Installing and Configuring Oracle RAC Module 4: Oracle RAC Administration Module 5: Managing Backup and Recovery for RAC Module 6: RAC Backup and Recovery Module 7: RAC Global Resource Management and Cache Fusion Module…

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…