All Courses

Introduction Exadata Overview Exadata Architecture Exadata Configuration Exadata Performance Monitoring and Maintenance Exadata and I/O Resource Management Optimizing Database Performance with Exadata Database Machine Overview and Architecture Database Machine Configuration Migrating Databases to Database Machine Bulk Data Loading with Database Machine Backup and Recovery with Database Machine Monitoring and Maintaining…

Essbase Overview Designing Applications and Databases Designing Data Descriptor Dimensions Optimizing Data Descriptor Dimensions Developing Dimension Designs Creating Basic Dimension Build Rules Files Creating Advanced Dimension Build Rules Files Loading Data Getting Started with Smart View Creating Reports with Smart View Data Storage and Calculation Creating Calculation Scripts Controlling the…

Online Analytical Processing Overview Data Transformation Multidimensional View of Information Dimensional Modeling Data Cubes Dimension Hierarchies OLAP Solutions Essbase architecture, components, and production cycle Aggregate Storage and Block Storage Outlines Load Rules Calculation Scripts Aggregations Reporting in Smart View Block Storage Data Structure Data Blocks and the Index System Block…

Financial Reporting Overview Oracle’s Enterprise Performance Management System Financial Reporting Functionality and Architecture Financial Reporting Data Sources Navigating Reports in EPM Workspace Navigating EPM Workspace Previewing Reports and Snapshots Setting Preferences Integrating Reports into Microsoft Office Applications Creating Basic Reports Reporting Studio Overview Report Creation Overview Creating Reports Adding Grids…

Introduction to Smart View Multi-Dimensional Analysis Overview Smart View Architecture Smart View Excel User Interface Connecting to Data Sources Creating Ad Hoc Analysis Reports Creating Ad Hoc Grids Performing Ad Hoc Operations in Multiple Cells Creating Member Selections Associating Data Sources with Worksheets Creating Multiple Grids on One Worksheet Creating…

Product Overview Oracle’s Enterprise Performance Management System Oracle Business Intelligence Suite Enterprise Edition Plus Oracle Hyperion Product Components Hyperion Interactive Reporting Architecture Viewing Documents Opening and Saving Documents Navigating Documents Refreshing Data and Organizing Sections E-mailing and Printing Documents Viewing Reports in Other Applications Querying Data Sources Querying Overview Requesting…

Introduction Basic Tuning Diagnostics Using Automatic Workload Repository Defining the Scope of Performance Issues Using Metrics and Alerts Using Baselines Using AWR-Based Tools Real-Time Database Operation Monitoring Monitoring Applications Identifying Problem SQL Statements Influencing the Optimizer Reducing the Cost of SQL Operations Using SQL Performance Analyzer SQL Performance Management Using…

CDB Basics CDB and Regular PDBs Application PDBs and Application Installation PDB Creation CDB and PDB Management Storage Security Backup and Duplicate Recovery and Flashback Performance Monitoring Resources Allocation Data Movement Upgrade methods

Introduction and Configuration Introduction Getting Started Configuring for Recoverability Using the RMAN Recovery Catalog Backup Backup Strategies and Terminology Performing Backups Improving Your Backups Using RMAN-Encrypted Backups Recovery Diagnosing Failures Restore and Recovery Concepts Performing Complete Recovery Performing Point-in-Time Recovery Performing Additional Recovery Operations Additional Technologies Using Flashback Technologies Using…

Oracle Database Overview Oracle Database Introduction Oracle Database Architecture Overview Oracle Database Instance Configurations Oracle Database Memory Structures Process Structures Database Storage Architecture Logical and Physical Database Structures Container and Pluggable Database Overview Installing Oracle Grid Infrastructure for a Standalone Server Overview of Oracle Grid Infrastructure for a Standalone Server System…

Introduction Oracle Database Architecture Introduction to Oracle Database Cloud Service Creating DBCS Database Deployments Accessing an Oracle Database Managing DBCS Database Deployments Managing Database Instances Understanding Oracle Net Services Administering User Security Creating PDBs Creating Master Encryption Keys for PDBs Creating and Managing Tablespaces Managing Storage Space Managing Undo Data…

Introduction Oracle Database Architecture Introduction to Oracle Database Cloud Service Creating DBCS Database Deployments Accessing an Oracle Database Managing DBCS Database Deployments Managing Database Instances Understanding Oracle Net Services Administering User Security Creating PDBs Creating Master Encryption Keys for PDBs Creating and Managing Tablespaces Managing Storage Space Managing Undo Data…

Introduction and Configuration Introduction Getting Started Configuring for Recoverablility Using the RMAN Recovery Catalog Backup Backup Strategies and Terminology Performing Backups Improving Your Backups Using RMAN-Encrypted Backups Recovery Diagnosing Failures Restore and Recovery Concepts Performing Complete Recovery Performing Point-in-Time Recovery Performing Additional Recovery Operations Additional Technologies Using Flashback Technologies Using…

Module 1: Using General Database Overall Enhancements Module 2: Using Security Enhancements Module 3: Using Availability Enhancements Module 4: Using Performance Enhancements Module 5: Using Big Data and Data Warehousing Enhancements Module 6: Using Diagnosability Enhancements Module 7: Sharding Enhancements

Module 1: Introduction Module 2: Architecture and Implementation Options Module 3: Upgrade Paths Module 4: Implementation Planning

Enterprise Manager Ops Center Virtualization Overview About Virtualization and Hypervisors Oracle Virtualization Benefits of Virtualization in Enterprise Manager Ops Center Supported Virtualization Technologies in Enterprise Manager Ops Center Hardware for OVMSS OVMSS Architecture Preparing the Lab Environment Enterprise Manager Ops Center Installation Overview Preparing the Lab Environment, Gathering Required Information…

Ops Center Architecture About Enterprise Manager Ops Center Basic Ops Center Deployment Components Network Ports and Protocols Ops Center’s Subscription Model Ops Center’s Job Process Ops Center’s Infrastructure Stack Plug-in Preparing for Installations Setting Up the Oracle Database Planning Enterprise Controllers, Proxy Controllers, and Assets Choosing Connected or Disconnected Mode…

Introduction Review Concepts and Pre-requisites Major Themes Virtualization with Oracle VM Server Oracle Virtual Machines in the Classroom Explore the RAC Database Repository Explore Oracle Software Installed and Configured Enterprise Manager Deployment Best Practices Simple EM Install versus a Highly Available and Scalable EM EM HA Deployment Best Practices Summary…

Introduction What is Cloud Computing? Private versus Public Clouds Why implement a Private Cloud? How does Oracle Enterprise Manager Cloud Control implement a Private Cloud? Three Clouds The Cloud Management Lifecycle Cloud for self-service users Define a self-service user in the context of IaaS and DBaaS clouds The IaaS Self…

Introduction Course overview Key Challenges for Administrators What Is Enterprise Manager Cloud Control? Built-in and Integrated Manageability Configuration Management This Course in Context Course Schedule Classroom Setup Reviewing Enterprise Manager Core Concepts Review Oracle Enterprise Manager architecture Agent Installation and Target Discovery Describing Different Target Types Monitoring Cloud Control Security…

Introduction Virtualization with Oracle VM Server Oracle VM Server in the Classroom Architecture and Deployment Options Components Compatibility And Differences Between Versions Agent Push Installation Deployment Topologies Single Server Installation Process Upgrade Paths Upgrade Paths Map Grid Control Upgrade Console 12c to 12c Upgrade Utilities A Choice of Two Upgrade…

Course Introduction Oracle NoSQL Database: Overview Planning An Installation Installing and Configuring Nodes Configuring and Deploying A KVStore Modifying a KVStore Securing the Configuration Troubleshooting Oracle NoSQL Database Installation Issues Fixing Hardware Failures Setting Store Parameters Optimizing KVStore Performance General Monitoring Backup and Recovery Managing AVRO Schema Upgrading the Software

Course Introduction Big Data and NoSQL Overview Oracle NoSQL Database: Overview Schema Design Application Specific Requirements Creating Tables Writing Data To Tables Retrieving Table Data Manipulating Data Stored in Key-Value Model Configuring Consistency Configuring Durability Creating Transactions Handling Large Objects Accessing a Secure Store Handling Exceptions

Big Data and NoSQL Database Overview Oracle NoSQL Database Designing a Schema Consistency Durability Credit Card Application and APIs: Overview Administration: Overview Planning the Installation Setting-up the Oracle NoSQL Database Nodes Configuring and Deploying the KVStore Store Parameters Optimizing KVStore Performance Backup and Recovery Troubleshooting Accessing the KVStore Creating Key…