Oracle Training - United Kingdom

Oracle SQL Fundamentals Course Outline

Day 1: Oracle SQL Basics & Data Retrieval (8 Hours)

Module 1: Introduction to Oracle SQL and Relational Databases

• What is Oracle Database?
• Oracle RDBMS vs. Other Databases
• Oracle SQL vs. ANSI SQL
• Understanding Tables, Columns, and Data Types in Oracle
• Primary Keys, Foreign Keys, and Constraints in Oracle

Module 2: Using Oracle SQL Tools

• Introduction to SQL*Plus and SQLcl
• Working with Oracle SQL Developer
• Executing Queries in SQL Developer & SQL*Plus
• Common SQL*Plus Commands

Module 3: Retrieving Data with SELECT Statement

• SELECT Statement Basics
• Using WHERE Clause for Filtering
• Sorting Data with ORDER BY
• Removing Duplicates with DISTINCT
• Using Aliases for Column and Table Names

Module 4: Oracle SQL Functions and Expressions

• Single-Row Functions
• Character Functions (UPPER, LOWER, INITCAP)
• Number Functions (ROUND, TRUNC, MOD)
• Date Functions (SYSDATE, CURRENT_DATE, LAST_DAY)
• Conversion Functions (TO_CHAR, TO_NUMBER, TO_DATE)
• Dual Table for Function Testing

Day 2: Data Manipulation, Joins & Aggregation (8 Hours)

Module 5: Using Joins in Oracle SQL

• Introduction to Joins in Oracle
• Types of Joins in Oracle
• Using Equijoins and Non-Equijoins

Module 6: Using Subqueries in Oracle

• Introduction to Subqueries
• Single-Row Subqueries vs. Multi-Row Subqueries
• Using Subqueries in WHERE and FROM Clauses
• Using EXISTS and NOT EXISTS

Module 7: Aggregation and Grouping Data

• Aggregate Functions (AVG, SUM, MAX, MIN, COUNT)
• GROUP BY and HAVING Clause
• Advanced Grouping: ROLLUP, CUBE, GROUPING SETS

Module 8: Data Manipulation in Oracle SQL (DML)

• Inserting Data into Tables (INSERT Statement)
• Updating Existing Data (UPDATE Statement)
• Deleting Records from Tables (DELETE and TRUNCATE)
• Using MERGE for UPSERT Operations
• Controlling Transactions: COMMIT, ROLLBACK, SAVEPOINT

Day 3: Managing Schema Objects & Performance Optimisation (8 Hours)

Module 9: Managing Tables in Oracle SQL (DDL)

• Creating and Altering Tables
• Creating Temporary Tables in Oracle
• Dropping & Truncating Tables

Module 10: Managing Indexes, Views & Synonyms

• Indexes in Oracle
• Views in Oracle
• Synonyms in Oracle

Module 11: Hierarchical Queries in Oracle

• Working with Parent-Child Relationships
• Using CONNECT BY PRIOR for Tree Structures
• Using START WITH for Root Identification

Module 12: Oracle SQL Performance Optimisation

• Understanding Oracle Execution Plans (EXPLAIN PLAN)
• Optimising Queries with Indexing
• Using Hints for Performance Tuning
• Partitioning Large Tables for Performance

Oracle SQL Advanced Training​ Course Outline

Module 1: Access Control

• System Privileges and Roles
• Create Users
• Alter User Details
• Grant and Revoke Object Privileges

Module 2: Retrieve Data Using Subqueries

• ANY, ALL, or SOME Operators
• Correlated Subqueries
• In-Line Views
• Exists Operator
• WITH Clause
• Multi-Column Subqueries
• Insert and Update Using a Query
• Correlated Update and Delete

Module 3: Hierarchical Queries

• Introduction Hierarchical Data
• START WITH and CONNECT BY Clauses
• LEVEL pseudo-column
• Sequencing the Output
• Eliminating Nodes and Branches

Module 4: Enhanced Grouping Features

• Review of Basic Grouping Concepts
• ROLLUP and CUBE Extensions
• GROUPING SETS Extension
• Using the GROUPING and GROUPING_ID Functions

Module 5: Analytic Queries

• Ranking Functions
• NTILE and WIDTH_BUCKET Functions
• FIRST and LAST Value Functions
• Analytic Aggregate Functions
• LEAD and LAG Functions
• LISTAGG Function

Module 6: Manage Large Data Sets

• Multi-Table Inserts
• Merging Data into a Table

Oracle Accounts Payable Training Course Outline

Module 1: Payables Overview

• Payables Workbenches
• Multiple Organisation Access Control

Module 2: Suppliers

• Suppliers Pages Reference
• Reviewing and Adjusting Suppliers

Module 3: Invoices

• Entering Invoices Overview
• Entering Invoices in the Invoice Workbench
• Matched Purchase Orders and Receipts in the Invoice Workbench
• Prepayments
• Credit and Debit Memos
• Entering Foreign Currency Invoices
• Subject to Income Tax Reporting Requirements
• Recurring Invoices
• Quick Invoices
• Payables Open Interface Import
• Approving Invoices
• Taxes on Invoices
• Invoice Notices
• Reviewing Invoices
• Adjusting Invoices
• Assets Integration
• Projects Integration
• Purchasing Integration
• Invoice Window References

Module 4: Expense Reports and Credit Cards

• Expense Reports
• Procurement Card Management
• Credit Card Management
• Managing Credit Card Outstanding Transactions

Module 5: Payments

• Payables and Receivables Netting
• Creating Single Payments
• Refunds
• Creating Foreign Currency Payments
• Bills Payable
• Update Matured Bills Payable Status Program
• Reviewing and Adjusting Payments
• Reconciling Payments with Oracle Cash Management

Module 6: Accounting

• Accounting in Payables
• Posting in Oracle General Ledger
• Reconciling Payables Activity
• How Payables Populates the GL Interface Table

Module 7: Resource Management and Reports

• Purging Records
• Purge Reports
• Submitting Standard Reports, Programs, and Listings
• Supplier Reports
• Income Tax Forms and Reports
• Invoice Reports and Payment Reports
• Receivables and Payables Netting Reports
• Accounting and Reconciliation Reports
• Key Indicators Report
• Notices
• Listings

Module 8: Automatic Interest and Automatic Offsets

• Payment Batches and Quick Payments
• Manual Payments
• Void Payments and Stop Payments
• Automatic Offsets and Invoice Processing
• Automatic Offsets and Payment Processing

Module 9: Invoice, Payment, and Account Default Charts

• Invoice and Invoice Batch Default Hierarchy Chart
• Payment and Payment Batch Default Hierarchy Chart
• Account Default Hierarchy Chart

Oracle Database 19c Administration Training Course Outline

Module 1: Introduction to Oracle Database

• Overview of the Oracle Database
• Overview of the Oracle Cloud
• Relational Database Concepts
• Database Administration Tasks

Module 2: Oracle Database Architecture

• Overview
• Database and Instance
• Oracle Database Memory Structures
• Process Architecture and Structures
• Server and Client Processes
• Oracle Database Storage Architecture
• Connect to the Oracle Database Instance

Module 3: Administer a Database Instance

• Administrative Tools Available to a DBA
• Use SQL*Plus in Oracle to Manage a Database Instance
• Use SQL Developer to Manage a Database Instance
• Overview of the Enterprise Manager Framework
• Access Enterprise Manager Database Express
• Enterprise Manager Cloud Control
• Initialisation Parameter Files

Module 4: Configure the Oracle Network Environment

• Overview of Network Configuration
• Oracle Net Listener Configuration
• Oracle Net Naming Methods
• Tools for Network Configuration
• Client Connections with Net Manager
• Viewing Listener Configuration
• Starting and Stopping the Listener
• Use TNSPING to Test Oracle Net Connectivity
• Connect to the Database
• Configure Net Services with EM

Module 5: Storage Structures

• Overview of Data Storage
• Database Block
• Overview of Tablespaces and Data Files
• Use Enterprise Manager to View the Storage Structure of the Database
• Create and Alter Tablespace Commands
• Temporary Tablespaces
• Create and Manage Datafiles
• Use OMF
• Drop Tablespaces and Datafiles

Module 6: Manage Users

• Predefined Database Administration Accounts
• User Accounts
• Create a User Account
• Change a User's Password
• Manage and Drop a User Account
• Monitor User Information
• Terminate User Sessions
• Create a Schema Only Account

Module 7: Manage Privileges

• Database Access
• Oracle Supplied Roles
• System and Object Level Privileges
• Grant and Revoke Commands
• Create, Alter, and Drop Roles
• Use Predefined Roles

Module 8: Database Auditing

• Overview of Database Security
• Overview of Database Auditing
• Standard Auditing
• Unified Audit Trail
• Separation of Audit Responsibilities
• Configure the Audit Trail
• Specify Audit Options

Module 9: Data Concurrency and Lock Conflicts

• Data Concurrency and Consistency
• Levels of Locking in Oracle
• Methods Used to Acquire Locks
• Possible Causes of Contention
• DML Locks
• Prevent Locking Problems
• Detect Lock Contention
• Resolve Conflicts

Module 10: Undo Management

• Undo Data Overview
• Monitor and Administer Undo
• Configure Undo Retention
• Switch Undo Tablespaces
• Specify the Retention Period
• Guarantee Undo Retention
• Oracle Flashback Query
• View Undo Space Information
• Use the Undo Advisor
• Alter an Undo Tablespace to a Fixed Size

Module 11: Backup and Recovery Configuration

• Oracle Backup Solutions Program
• Oracle Suggested Backup Strategy
• Overview of Database Backup, Recover
• Flashback Technology
• Types of Failure
• Instance Recovery
• Tune Instance Recovery
• MTTR Advisor
• Media Failure
• Configure a Database for Recoverability

Module 12: Proactive Database Maintenance

• Database Maintenance
• View the Alert Log
• Automatic Workload Repository
• Statistic Levels
• Automatic Database Diagnostic Monitoring
• Monitor an Oracle Database
• Use the Advisors
• Set Up Notification Rules

Module 13: Performance Management

• Tuning Information Sources
• Performance Monitoring
• Performance Planning
• Instance Tuning
• Performance Tuning Methodology
• Performance Tuning Data
• Managing Memory
• Manage Private Temporary Tables

Module 14: SQL Tuning

• Overview
• Cancel a SQL Statement in a Session
• Oracle Optimiser
• SQL Plan Directives
• Adaptive Execution Plans
• SQL Advisors
• Implement Automatic Tuning Recommendations

Module 15: Moving Data

• Create Directory Objects
• Data Pump Architecture
• Data Pump Data Dictionary Views
• Use Data Pump to Export and Import Data
• Overview of SQL Loader
• Command Line Parameters
• Record Filtering
• Control File Keywords
• Data Files
• SQL Loader Data Paths
• External Tables

Module 16: Managing Resources with Resource Manager

• Database Resource Manager
• Use the Resource Manager
• Create Resource Plans
• Create Resource Plan Directives
• Allocate Resources for Resource Plans

Module 17: Automate Tasks with the Scheduler

• Introduction to the Scheduler
• Access Rights
• Scheduler Components and Workflow
• Create a Job
• Job Classes
• Use Time Based, Event-Based Schedules
• Create an Event-Based Schedule

Module 18: Manage Space

• Overview of Space Management
• Block Space Management within Segments
• Segment Types
• Allocate Extents and Space
• Row Chaining and Migration
• Create Tables without Segments

Module 19: Oracle Support

• Enterprise Manager Support Workbench
• Register for Security Updates
• Work with Oracle Support
• Log Service Requests
• Manage Patches
• Apply a Patch

Oracle Database 18c Administration Training​ Course Outline

Module 1: Oracle Database Architecture Overview

• Oracle Database Server Architecture
• Oracle Database Instance Configuration
• Connecting to the Database Instance
• Oracle Database Memory and Process Structures
• Logical and Physical Database Structures
• Multitenant Architecture
• Automatic Storage Management (ASM)

Module 2: Oracle Database Cloud Overview

• Understand Features and Tooling
• Automated Database Overview

Module 3: Oracle Database Access

• Introductions to SQL*Plus
• SQL Developer
• Database Configuration Assistant (DBCA)

Module 4: Managing Database Instances

• Initialisation Parameter Files
• Starting Up Oracle Database Instances
• Shutting Down Oracle Database Instances
• Automatic Diagnostic Repository (ADR)
• Alert Log and Trace Files
• Dynamic Performance Views
• Data Dictionary Views

Module 5: Oracle Net Services

• Introduction of Oracle Net Listener
• Naming Methods
• Oracle Net Services Administration Tools
• Comparing Dedicated and Shared Server Configurations

Module 6: User Security for Administrator

• Managing Oracle Database and Cloud Users, Privileges, and Roles
• User Authentication
• Creating and Assigning Profiles
• Assigning Quotas to Users
• Applying the Principle of Least Privilege

Module 7: Create a PDBs in Oracle

• Creating PDBs from Seed
• Cloning PDBs
• Unplugging and Plugging in PDBs
• Dropping PDBs

Module 8: Creating Master Encryption Keys for PDBs

• Encryption in Oracle Database Cloud Service
• Introduction of Transparent Data Encryption (TDE)
• CDB and PDB Master Encryption Keys
• Creating and Activating an Encryption Key

Module 9: Create and Manage Tablespaces

• Table Data Storage
• Creating, Altering and Dropping Tablespaces
• Viewing Tablespace Information
• Oracle Managed Files
• Tablespace Encryption by Default in DBCS

Module 10: Managing Storage Space

• Block Space Management
• Types of Segments
• Deferred Segment Creation
• Reclaimable Unused Space
• Table and Row Compression
• Shrinkable Segments
• Resumable Space Allocation

Module 11: Undo Data and Moving Data Overview

• Transactions and Undo Data
• Storing Undo Information
• Comparing Undo Data and Redo Data
• Comparing Local Undo Mode and Shared Undo Mode
• Configuring Undo Retention
• Temporary Undo
• Understand Moving Data
• Oracle Data Pump
• SQL*Loader
• External Tables
• Migrating to Oracle Database Cloud Service

Module 12: Backup and Recovery Concepts

• Categories of Failure
• Instance Recovery
• Complete Recovery
• Flashback Technology

Module 13: Configure Backup and Recovery

• Monitoring the Fast Recovery Area
• Multiplexing Control Files
• Multiplexing Redo Log Files
• Archived Redo Log Files
• Setting ARCHIVELOG Mode

Module 14: Creating Database Backups

• Backup Terminology
• Using Recovery Manager (RMAN)
• Automatic Backups on Database Cloud Service (DBCS)

Module 15: Monitoring and Tuning Database Strategies

• Performance Planning Considerations
• Automatic Workload Repository (AWR)
• Automatic Database Diagnostic Monitor (ADDM)
• Advisory Framework
• Managing Metric Thresholds and Alerts
• Monitoring Wait Events, Sessions, and Services
• Managing Memory Components

Module 16: SQL Tuning Overview

• SQL Tuning Process
• Oracle Optimiser
• Optimiser Statistics
• SQL Tuning Advisor
• SQL Access Advisor
• SQL Performance Analyser

Oracle 18c DBA Fundamentals​ Course Outline

Module 1: Getting Started with Database Administration

• Types of Oracle Database Users
• Tasks of a Database Administrator
• SQL Statements
• Identifying Your Oracle Database Software Release
• About Database Administrator Security and Privileges
• Database Administrator Authentication
• Creating and Maintaining a Database Password File
• Data Utilities

Module 2: Creating and Configuring an Oracle Database

• About Creating an Oracle Database
• Considerations Before Creating the Database
• Creating a Database with DBCA
• Creating a Database with the CREATE DATABASE Statement
• Specifying CREATE DATABASE Statement Clauses
• Specifying Initialisation Parameters
• Managing Initialisation Parameters Using a Server Parameter File
• Managing Application Workloads with Database Services
• Considerations After Creating a Database
• Cloning a Database
• Dropping a Database
• Database Data Dictionary Views
• Database Configuration Assistant Command Reference for Silent Mode

Module 3: Starting Up and Shutting Down

• Starting Up a Database
• Altering Database Availability
• Shutting Down a Database
• Quiescing a Database
• Suspending and Resuming a Database
• Delaying Instance Abort

Module 4: Managing Processes and Memory

• About
  • Dedicated and Shared Server Processes
  • Database and Proxy Resident Connection Pooling
• Configuring
  • Oracle Database for Shared Server
  • Database Resident Connection Pooling
• Managing
  • Prespawned Processes
  • Processes for Parallel SQL Execution
  • Processes for External Procedures
  • Terminating Sessions
• Process and Session Data Dictionary Views
• What is Memory Management and its Architecture?
• Using Automatic Memory Management
• Configuring
  • Memory Manually
  • Database Smart Flash Cache
• Improving Query Performance
  • Memoptimised Rowstore
  • Oracle Database In-Memory

Module 5: Managing Users and Securing the Database

• Importance of Establishing a Security Policy for Your Database
• Managing Users and Resources
• User Privileges and Roles
• Auditing Database Activity
• Predefined User Accounts

Module 6: Monitoring the Database and Managing Diagnostic Data

• Monitoring
  • Errors and Alerts
  • Performance
  • Quarantined Objects
• Oracle Database Fault Diagnosability Infrastructure
• Investigating, Reporting, and Resolving a Problem
• Viewing Problems with the Support Workbench
• Adding Problems Manually to the Automatic Diagnostic Repository
• Viewing the Alert Log
• Finding Trace Files
• Running Health Checks with Health Monitor
• Repairing SQL Failures with the SQL Repair Advisor
• Repairing Data Corruptions with the Data Recovery Advisor
• Creating, Editing, and Uploading Custom Incident Packages

Module 7: Managing Control Files

• What Is a Control File?
• Guidelines for Control Files
• Creating Control Files
• Troubleshooting After Creating Control Files
• Backing Up Control Files
• Recovering a Control File Using a Current Copy
• Dropping Control Files
• Control Files Data Dictionary Views

Module 8: Managing the Redo Log

• What Is the Redo Log?
• Planning the Redo Log
• Creating Redo Log Groups and Members
• Relocating and Renaming Redo Log Members
• Dropping Redo Log Groups and Members
• Forcing Log Switches
• Verifying Blocks in Redo Log Files
• Clearing a Redo Log File
• Precedence of FORCE LOGGING Settings
• Redo Log Data Dictionary Views

Module 9: Managing Archived Redo Log Files

• What Is the Archived Redo Log?
• Choosing Between NOARCHIVELOG and ARCHIVELOG Mode
• Controlling Archiving
• Specifying Archive Destinations
• About Log Transmission Modes
• Managing Archive Destination Failure
• Controlling Trace Output Generated by the Archivelog Process
• Viewing Information About the Archived Redo Log

Module 10: Managing Tablespaces

• Guidelines for Managing Tablespaces
• Creating Tablespaces
• Consider Storing Tablespaces in the In-Memory Column Store
• Specifying Nonstandard Block Sizes for Tablespaces
• Controlling the Writing of Redo Records
• Altering Tablespace Availability
• Using Read-Only Tablespaces
• Altering and Maintaining Tablespaces
• Renaming Tablespaces
• Dropping Tablespaces
• Managing Lost Write Protection with Shadow Tablespaces
• Managing the SYSAUX Tablespace
• Correcting Problems with Locally Managed Tablespaces
• Migrating the SYSTEM Tablespace to a Locally Managed Tablespace
• Viewing Information About Tablespaces

Module 11: Managing Data Files and Temp Files

• Guidelines for Managing Data Files
• Creating Data Files and Adding Data Files to a Tablespace
• Changing Data File Size
• Altering Data File Availability
• Renaming and Relocating Data Files
• Dropping Data Files
• Verifying Data Blocks in Data Files
• Copying Files Using the Database Server
• Mapping Files to Physical Devices
• Data Files Data Dictionary Views

Module 12: Transporting Data and Managing Undo

• About Transporting Data
• Transporting Databases
• Transporting Tablespaces Between Databases
• Transporting Tables, Partitions, or Subpartitions Between Databases
• Converting Data Between Platforms
• Guidelines for Transferring Data Files
• What Is Undo?
• Introduction to Automatic Undo Management
• Managing Undo Tablespaces
• Migrating to Automatic Undo Management
• Managing Temporary Undo
• Undo Space Data Dictionary Views

Module 13: Using Oracle Managed Files

• About Oracle Managed Files
• Enabling the Creation and Use of Oracle Managed Files
• Creating Oracle Managed Files
• Operation of Oracle Managed Files
• Scenarios for Using Oracle Managed Files

Module 14: Managing Views, Sequences, and Synonyms

• Managing Views
• Managing Sequences
• Managing Synonyms
• Views, Synonyms, and Sequences Data Dictionary Views

Module 15: Managing Automated Database Maintenance Tasks

• About Automated Maintenance Tasks and Maintenance Windows
• Configuring
  • Automated Maintenance Tasks
  • Maintenance Windows
  • Resource Allocations for Automated Maintenance Tasks
• Automated Maintenance Tasks Reference

Module 16: Managing a Distributed Database

• Managing Global Names in a Distributed System
• Creating Database Links
• Using Shared Database Links
• Managing Database Links
• Viewing Information About Database Links
• Creating Location Transparency
• Managing Statement Transparency

Oracle Database 12c: Administration Course Outline

Module 1: Introduction to Oracle Database 12c

• Overview of the Oracle Database 12c
• Oracle Cloud
• Relational Database Concepts
• Database Administration Tasks

Module 2: Oracle Database Architecture

• Overview of the Oracle Database Architecture
• Oracle Database Instance
• Oracle Database Memory Structures
• Process Architecture
• Server and Client Processes
• Oracle Database Storage Structure

Module 3: Administer a Database Instance

• Administrative Tools Available to a DBA
• Starting SQL*Plus and Connecting to the Database
• Creating a Database Connection Using SQL Developer
• Administer the Database Using Enterprise Manager (EM)
• Enterprise Manager Framework
• Enterprise Manager Cloud Control
• Initialisation Parameter Files

Module 4: Configure the Oracle Network Environment

• Network Configuration
• Oracle Net Listener Configuration and Management
• Tools for Configuring and Managing the Oracle Network
• Configure Client Connections with Net Manager
• View Listener Configuration
• Start and Stop the Oracle Listener
• Connect to the Database

Module 5: Storage Structures

• Data Block
• Tablespaces and Datafiles
• Create and Alter Tablespace Commands
• Temporary Tablespaces
• Create and Manage Data Files
• Use OMF
• Drop Tablespaces and Datafiles

Module 6: Manage Users

• Predefined Database Administration Accounts
• User Accounts
• Create a User Account
• User Authentication
• Change User’s Password
• Manage a User Account
• Drop a User Account
• Terminate User Sessions

Module 7: Manage Profiles and Resources

• User Profiles
• Profile Resource Parameters
• Create Profile Command
• Manage Passwords with Profiles
• Control Resource Usage with Profiles

Module 8: Manage Privileges

• Common Roles
• System and Object Level Privileges
• Grant and Revoke Commands
• Create, Modify, and Drop Roles
• Use Predefined Roles

Module 9: Database Auditing

• What is Database Security?
• Introduction to Database Auditing
• Security Compliance
• Unified Audit Trail
• Specify Audit Options

Module 10: Data Concurrency and Lock Conflicts

• Lock Modes in Oracle
• Data Concurrency
• Locking Behaviour
• DML Locks
• Lock Conversion and Escalation
• User-Defined Locks

Module 11: Proactive Database Maintenance

• Database Maintenance
• View the Alert Log
• Automatic Workload Repository
• Statistic Levels
• Automatic Database Diagnostic Monitoring
• Monitor an Oracle Database
• Use the Advisors

Module 12: Performance Management

• Tuning Information Sources
• Designing and Developing for Performance
• Instance Tuning
• Managing Memory

Module 13: SQL Tuning

• What is SQL Tuning?
• Oracle Optimiser
• SQL Plan Directives
• Adaptive Execution Plans
• SQL Tuning Advisor

Module 14: Moving Data

• Create Directory Objects
• Oracle Data Pump Overview
• Data Pump API
• Oracle Database Vault Data Dictionary Views
• SQL Loader
• Control File
• Data Files
• External Tables

Module 15: Automate Tasks with the Scheduler

• Introduction to the Scheduler
• Access Rights
• Scheduler Components and Workflow

Module 16: Managing Resources with Resource Manager

• Database Resource Manager
• Create Resource Plans
• Automated Maintenance Tasks Reference
• Create Resource Plan Directives
• Resource Manager Administration Privileges

Module 17: Manage Space

• Logical Space Management
• Space Management in Data Blocks
• Segment Types
• Allocate and Deallocate Extents
• Row Chaining and Migration

Module 18: Oracle Support

• Enterprise Manager Support Workbench
• Oracle Support Integration
• Service Requests
• Manage and Apply Patches

Oracle Database DBA Performance Tuning & Management Training Course Outline

Module 1: Introduction to Oracle Performance Tuning

• Performance Planning and Scalability
• System Architecture and Components
• Application Design and Deployment
• SQL Tuning Essentials

Module 2: Using Application Tracing Tools

• End-to-End Application Tracing
• Trcsess Utility
• SQL Trace Overview
• TKPROF Usage

Module 3: SQL Optimiser

• Optimiser Operations
• Query Execution Plans
• Joins
• Conditions
• Access Paths

Module 4: Sorts

• Sort Merge Joins

Module 5: Indexes

• Index Characteristics
• Keys and Columns
• Unique vs. Nonunique Indexes
• Advanced Index Types

Module 6: Advanced Indexes

• Types and Categories

Module 7: Sequences and Views

• Creating and Managing Views
• Using and Altering Views
• Creating Sequences

Module 8: Using Hints

• Overview of Optimiser Hints

Module 9: Miscellaneous SQL Tuning

• SQL Tuning Tips
• Virtual Columns
• Bind Variable Usage
• Result Caching

Module 10: Basic Tuning Diagnostics 

• Performance Tuning Tools
• Database Time (DB Time)
• Dynamic Performance Views
• Wait Events

Module 11:  Reducing SQL Operation Costs 

• Identify Invalid Objects
• Manage Extents
• Row Migration

Module 12: SQL Performance Analyse

• An Overview of the SQL Performance Analyser
• Summary of the AWR Compare Periods Report
• About Database Memory Caches and Other Memory Structures
• Data Dictionary Cache Concepts

Oracle Database 12cR2, 18c and 19c New Features for Administrators​ Course Outline

Module 1: Oracle Database Multitenant Architecture Overview

• Oracle Database 12cR2 Architecture Overview
• An Overview of a Container Database (CDB)
• Benefits of Multitenant Architecture
• Root Container
• Pluggable Database Containers
• Structure of the Root Container
• Structure of a Pluggable Database (PDB)
• CDB_xxx and DBA_xxx Views

Module 2: Install the Oracle 12c or 18c Database Software

• Oracle 12 c Installation
• System Requirements and OS Prerequisites
• Set Environment Variables
• Set Permissions to Run Root Configuration Scripts Automatically
• 19c Automated Installation, Configuration
• Install the Oracle Database Software with the Oracle Universal Installer
• Silent Mode Installation
• 19c Image Based Client Installation
• Database Software Deinstallation

Module 3: Create a Database with the Database Configuration Assistant (DBCA)

• Select a CDB or Non-CDB Database
• Create a Database with the DBCA
• Read Only Oracle Homes in Oracle Database 18c/19c

Module 4: Preparation for Upgrade to Oracle Database 18c/19c

• Methods Used to Perform an Upgrade
• Direct Upgrade Supported Releases
• Upgrade Process Overview
• Rolling Upgrade
• Methods of Data Migration
• 19c Simplified Upgrade with Auto Upgrade
• Backup the Database
• Create an Upgrade Test Plan
• Carry out Performance Testing
• Run the Pre-Upgrade Information Tool

Module 5: Perform Upgrades to Oracle Database 18c/19c

• Upgrading to Oracle Database 18c/19c
• Manual Upgrade of an Oracle 12cR1 Database
• Execute Preupgrade.jar
• Upgrade a Database with the Database Upgrade Assistant (DBUA)
• Post Upgrade Checks
• Deprecated Database Features and Parameters
• Common Installation Errors
• Check the /etc/Oratab File
• Check the Database Version
• Enterprise Manager Express Configuration
• Post Upgrade Tasks After a Manual Upgrade
• Migrate to Unified Auditing

Module 6: Migrate Data with Data Pump

• Introduction to Migrate Data with Data Pump
• Transport a Database
• Import Data Using a Data Pump Network Link

Module 7: Enhancements to Database Auditing

• Use Mixed Mode Auditing or Migrate to Pure Unified Auditing
• Audit Top Level User Activities in 19c
• Use Oracle Data Pump to Export and Import the Unified Audit Trail

Module 8: Enhancements to Privileges and Profiles

• Automatically Lock Inactive Accounts
• Schema Only Accounts from 18c
• 19c Privilege Analysis with an Enterprise Edition License
• Create, Start, and Stop Privilege Captures
• Query the DBA_PRIV_CAPTURES View
• Execute the Invokers Rights Privilege with the Inherit Privilege
• Control Definer's Rights Privileges for Database Links

Module 9: New RMAN Features

• 12.2 RMAN Syntax Enhancements
• Enhanced Table Point in Time Recovery from 12.2
• Enhanced REPAIR FAILURE Command
• Table or Partition Recovery Enhancements from 12.2
• Recover a Database after Missing Redo Logs Found
• Simplified Duplicate a Database using TDE

Module 10: Miscellaneous New Features

• Cancel a SQL Statement in a Session from 18c
• Use Private Temporary Tables from 18c
• Miscellaneous Data Redaction Enhancements
• 12.2 INMEMORY_SIZE Parameter
• 12.2 INMEMORY Enhancements

Module 11: SQL and PL/SQL Enhancements

• SQL*Plus Enhancements
• login.sql File
• SQL*Plus Command Line History
• SQL*Plus Performance Settings Options
• SQLcl Command Line Interface
• Longer Object Names
• Globalisation Support at Table and Column Level
• Markup CSV
• New Approximate Functions
• LISTAGG DISTINCT from Oracle 19c
• Remove Duplicates from LISTAGG Results Using DISTINCT
• DBMS_SESSION.SLEEP Replaces DBMS_LOCK.SLEEP from 18c
• Real Time Materialised View Enhancements
• PL/SQL Enhancements
• PL/SQL Scope Enhancements
• Deprecate Pragma for PL/SQL
• Code Coverage Using DBMS_PLSQL_CODE_COVERAGE
• Package White Lists Enhancements

Module 12: Performance Tuning New Features

• Overview of Performance Tuning New Features
• Adaptive Query Optimisation Enhancements
• Optimiser Statistics Advisor Rules, Findings, Recommendations, and Actions
• Expression Statistics Store
• Enhancements to the SQL Performance Analyser
• Configure the Automate SPM Evolve Advisor Task to Run Hourly
• Automatic Resolution of SQL Plan Regression
• Scalable Sequences

Module 13: Big Data and Data Warehouse New Features

• Reduce Cursor Invalidations for DDLs
• Automatic Indexing in 19c with DBMS_AUTO_INDEX
• Real Time Statistics Gathering During DML Operations
• Advanced Index Compression
• Automatic SQL Plan Management
• SQL Statements Terminated by the Resource Manager Quarantined
• COUNT(DISTINCT) Rollup
• Polymorphic Tables Enhancements

Module 14: Partitioning Enhancements

• New Oracle Partitioning Strategies in 12.2
• Automatic List Partitioning
• Multiple Column List Partitioning
• Multiple Column with Automatic List Partitioning
• Interval Sub-Partitioning
• Filter Data During Partition Maintenance Operations
• Convert a Non-Partitioned Table to a Partitioned Table
• Read Only Partitions
• Defer Segment Creation for Sub-Partitioning
• Online MERGE PARTITION and MERGE SUBPARTITION in 18c
• Hybrid Partitioned Tables - Integrate Internal and External Partitions

Module 15: Data Pump Enhancements

• Data Pump Parallel Import and Export of Metadata
• Usage of Wildcards in TRANSPORT_DATAFILES
• New Substitution Variables for Filenames
• Parameter File Contents Written to the Log File
• REMAP_DIRECTORY Parameter
• DATA_OPTIONS Parameter Changes
• Miscellaneous New Data Pump Features

Module 16: SQL*Loader and External Table Enhancements

• In-Memory External Tables
• External MODIFY Clause
• Load XML Documents with the XML TAG Clause

Module 17: Database Diagnostic New Features

• TFA Collector
• Install the TFA Collector
• Manage the TFA Daemon
• Quarantined Objects

Module 18: Data Guard New Features

• 12.2 Data Guard New Features
• Create Scripts with the Broker DGMGRL Command Line Interface
• Automatic Password File Management
• Simple Repair of No Logging Operations
• Active Data Guard Redirection
• Automatically Replicate Restore Points from Primary to Standby
• New Broker VALIDATE Commands
• 19c Data Guard New Features
• Export the Broker Configuration File
• Observe Only Mode to Test Fast Start Failover
• Dynamically Change Fast Start Failover Target Using the Data Guard Broker
• Enhanced Control of Alternative Destinations
• New Broker Commands
• Use RMAN and Enterprise Manager to Create Far Sync Instances
• Multi-Instance Redo Apply
• Keep Buffer Cache at Role Change
• 18c Data Guard New Features

Module 19: Active Data Guard New Features

• 12.2 Active Data Guard New Features
• Use all Standby Instances to Apply Redo
• Data Guard Broker Support for DBMS_ROLLING Upgrades
• Generating AWR Report from Active Dataguard
• Control Login Attempts
• New RECOVER STANDBY DATABASE FROM SERVICE
• Execute DML
• Create Global Temporary Tables

Module 20: Transparent Sensitive Data Protection

• Use Cases for TSDP Policies
• TSDP with Unified Auditing
• TSDP with Fine-Grained Auditing
• Create a TSDP Policy with TDE Column Encryption
• TDE Column Encryption Encrypt Clause Settings Used with TSDP Policies
• TSDP Data Dictionary Views

Module 21: Application Continuity Enhancements

• Server Draining Prior to Stopping or Relocating Services
• Oracle Database Recognition of Request Boundaries
• Transparent Application Continuity
• Application Continuity for Java

Oracle Database 11g Release 2 DBA - Part I Course Outline

Module 1: Installing and Configuring Oracle Database

• Steps for Installing and Configuring the Oracle Database

Module 2: Administering an Oracle Database

• Introduction
• Initialisation Parameter
• Database Limits
• Security
• Using Trace and Alert Files
• Password Management

Module 3: Understanding Network Configuration

• Understanding Network Configuration
  • Oracle Net Listener Configuration
  • Client Connections

Module 4: Creating and Managing Database Storage Structures

• About Database Storage Structures
  • About Control Files
  • About Online Redo Log Files
  • About Archived Redo Log Files
  • About Data Files
• Viewing Database Storage Structure Information
  • Viewing Control File Information
  • Viewing Online Redo Log File Information
  • Viewing Archived Redo Log File Information
  • Viewing Data File Information
  • Viewing Tablespace Information

Module 5: Managing Redo Log Files and Control Files

• Introduction to Redo Log
  • Redo Threads
  • Redo Log Contents
  • How Oracle Database Writes to the Redo Log
• Managing Redo Log Files and Control Files
  • Creating Redo Log Groups and Members
  • Clearing a Redo Log File
  • Redo Log Data Dictionary Views
  • Introduction to Control Files
  • Creating Initial Control Files
  • Troubleshooting After Creating Control Files
  • Backing Up Control Files

Module 6: Managing Schema Objects

• Creating Multiple Tables and Views in a Single Operation
• Analysing Tables, Indexes, and Clusters
• Truncating Tables and Clusters
• Renaming Schema Objects
• Managing Object Dependencies
• Switching to a Different Schema

Module 7: Managing Users, Profiles, Privileges and Roles

• Managing Privileges and Roles
  • Privilege
  • Roles
  • System Privileges
  • About User Roles
  • Roles Affect the Scope of a User's Privileges
  • Managing Object Privileges

Module 8: Managing Undo Data and Temporary Segments

• Managing Undo Data and Temporary Segments
  • Managing Undo Data
  • Undo Data
  • Undo Tablespace
  • Undo Retention
  • Managing Undo Data
  • Viewing Undo Information

Module 9: Monitoring and Resolving Lock Conflicts

• Preparing for Conflict Resolution
• Monitoring Locks

Module 10: Maintaining Database Security

• About User Security
• Creating a New User Account
  • Specifying a User Name
  • Assigning the User a Password

Module 11: Monitoring General Database State and Workload

• Steps to Monitoring General Database State and Workload

Module 12: Oracle Data Pump

• Overview of Oracle Data Pump
• Data Pump Export
• Data Pump Import

Module 13: Backing Up and Recovering the Database

• Introduction
• Tasks of Backup Administration
• Configuring Database
• Configuring Backup Settings0

Oracle Database 11g Release 2 DBA - Part II Course Outline

Module 1: Backup and Disaster Recovery

• Backup and Recovery
  • Overview
  • Backup Strategies
  • Issues in Backup and Recovery
  • Oracle Backup and Recovery Solutions
  • Oracle Backup and Recovery Strategy
  • Backing Up a Database in Windows
  • Restore the Database on Windows

Module 2: Archivelog and Nonarchivelog

• Archivelog and Nonarchivelog
  • Modes
  • Uses for Archived Redo Logs
  • Running a Database in NOARCHIVELOG Mode
  • Advantages of Archiving Filled Groups
  • Redo Log File Use in Archivelog Mode
  • Changing the Database Archiving Mode

Module 3: Managing Memory

• Managing Memory
  • Memory Management
  • Types of Memory Management
• Memory Architecture
• Memory Structures

Module 4: Recovery Manager

• Recovery Manager (RMAN)
  • RMAN Architecture
  • RMAN Environment Structure
  • Methods of RMAN Backup
  • Restoring and Recovering Database Files
  • Preview a Database Restore and Recovery
  • Recovering the Whole Database

Module 5: Flashback Technology

• Overview
• Features
• Configuring Database for Flashback Transaction
• Configuring Database for Automatic Undo Management
• Configuring Database for Oracle Flashback Transaction Query
• Granting Necessary Privileges

Module 6: Reviewing and Diagnosing Databases

• Database Logs

Module 7: Monitoring and Improving Database Performance

• Database Advisors
  • Overview
  • Performance Advisors
  • What Does an Automatic SQL Tuning Advisor Do?
  • Configuring the Automatic SQL Tuning Advisor

Module 8: Controlling Database Resources

• Overview
• Resource Plan
• Resources Manager Administration Privileges
• Types of Resources Managed by the Resource Manager
• Disabling the Resource Manager
• Using Several Resource Allocation Methods

Module 9: Automating Tasks with Scheduler

• Automate Tasks
  • Overview
  • Maintenance Windows
  • Configuring Automated Maintenance Tasks
  • Configuring Resource Allocations for Automated Maintenance Tasks
  • Predefined Maintenance Windows

Oracle Program Training with PL/SQL Course Outline

Module 1: PL/ SQL and Its Components

• PL/SQL Overview
• PL/SQL Elements
• Variable and Constants
• Data Types
• Initialising Variable and Assigning Values
• Generating Output to SQL or SQL Developer

Module 2: Program Logic Essentials

• Statement for Program
• Loops for Program

Module 3: Cursors in PL/SQL Overview

• Introduction to Cursor
• Implicit and Explicit Cursors
• Cursor Operations
• Declaring, Opening, and Closing Cursors

Module 4: EXCEPTIONS and NESTED Blocks

• Exception Section Overview
• Types of Exception
• Named and Unnamed System-Raised Exceptions
• User-Declared Exceptions and Application Errors
• Propagation of Exceptions

Module 5: PL/SQL Records and Index-By Tables

• Records and Index-By Tables Overview
• Declaring Record Types
• Nested Records
• PL/SQL Table Built-in Functions

Module 6: Triggers Overview

• Introduction to Triggers
• DML Triggers
• CREATE TRIGGER Statement
• INSTEAD OF Triggers
• Calling Procedures from Triggers
• DDL Triggers
• Privileges Required for Triggers

Module 7: Procedures Overview

• Introduction to Procedures
• CREATE PROCEDURE Statement
• Procedure Parameters
• Invoking Procedures
• Named Association Parameter Passing
• Definer's Right and Invoker's Rights
• Autonomous Transactions
• Privileges Required for Procedures
• Dictionary Information Concerning Procedures

Module 8: Functions Overview 

• Introduction to Functions
• Deterministic and Parallel-Enabled Functions
• Function Result Cache
• Privileges Required for PL/SQL Statement and Operations

Module 9: Packages Overview 

• Introduction to Package
• Creating a Package
• Overloading
• Forward Declaration
• Wrapping Packages

Module 10: PL/SQL Records and Tables in Packages

• Associated Arrays
• NOCOPY Hint
• Bulk Collection
• Bulk Binding DML Statements

Module 11: Cursor Variables Overview

• Use Cursor Variables
• Fetch Rows Overview
• Cursor Variable Attributes
• Refcursor Datatype

Module 12: Managing Dependencies

• Dependent and Referenced Objects
• Recompilation
• Invalidation and Recompilation
• Local and Remote Dependencies

Module 13: Native Compilation and Compile-Time Warnings

• Introduction of Native Compilation and Compile-Time Warnings
• Automatic Program Sublining
• Data Dictionary Information
• Compiler Warning Categories
• DBMS_WARNING Package

Module 14: Oracle - Supplied Packages Overview

• Introduction to Oracle-Supplied Packages
• Understand Packages Types

​Oracle Database 12c R2: New Features for 12c R1 Administrators Ed 1 Course Outline

Module 1: Application Containers and Applications

• What is Application Root and Application PDBs?
• Application Container
  • Create
  • Manage
  • Install Application
  • Patch Application
  • Upgrade Application
• Impacts in
  • Data Guard
  • Oracle Goldengate
  • Oracle Streams
  • Xstream
  • ADO
  • Heat Maps

Module 2: Security in PDBs

• Create Users in Application Containers
  • Commonly
  • Locally
• Grant Privileges in Application Containers
  • Commonly
  • Locally
• Grant Roles in Application Container
  • Commonly
  • Locally
• Differentiate
  • Common and Local Roles in Application Containers
  • Common and Local Objects in Application Containers
  • Common and Local Profiles in Application Containers
• How to Manage PDB Lockdown Profiles?
• How to Create Unified Auditing Policies Operations in Application Containers?

Module 3: PDBs Creation Using New Methods

• How to Create a PDB from CDB Seed Enhancements?
• Unplug into a PDB Archive File
• Plug Using the Archive File
• How to Create Local UNDO Tablespace at PDB Level?
• What is Hot Cloning?
• Near-Zero Downtime PDB Relocation and Create a Remote Proxy PDB

Module 4: PDBs Recovery and Flashback

• Shut Down a PDB When PDB Datafile is Missing
• Flashback at PDB Level and Flashback a PDB To a Clean PDB Restore Point

Module 5: Performance in PDBs

• View
  • CDB / PDB ADDM Analysis
• Manage
  • SGA and PGA at the PDB Level
• Share
  • Resources Between PDBs

Module 6: Upgrade and Other Operations in PDBs

• Upgrade
  • 12.1.0.2 CDB to 12.2
  • 12.1.0.2 PDB to 12.2 By Using Unplug, Plug, and Upgrade
• Use Cross-Platform Non-CDB or PDB Backup sets to Import Into a CDB

Module 7: Privileges and User Profiles

• What is New 12.2 SYSRAC Administrative Privilege?
• Enhancements of Password File
• External Users Grant Administrative Privileges
• How to Migrate the Password File from Pre-12 or 12.1 to 12.2?
• New System Privilege
  • Inherit any Remote Privileges
  • Object Privilege Inherit Remote Privileges
• Security of Administrative Users Enhancement
• How to Pre-Configure a Maximum Number of Days in the User Profile for Which a User Can Remain Inactive?

Module 8: Unified Auditing

• Audit Policies for All Users to Whom the Role is Granted Directly
  • Create Audit Policies
  • Enable Audit Policies
• How to Capture VPD (Virtual Private Database) Generated Predicates?

Module 9: Data Redaction

• EM GUI New Redaction Format Library
• Redaction Policy Expression and New Redaction Functions

Module 10: Data Encryption

• Encrypt, Decrypt, and Rekey Tablespaces Online
• Specific Tablespaces
  • SYSAUX
  • SYSTEM
  • UNDO
  • Temporary
• How to Complete the Operations with Alter Tablespace Encryption Finish Encrypt, Rekey, and Decrypt?

Module 11: Transparent Sensitive Data Protection

• Use TSDP with
  • Unified Auditing
  • Fine-Grained Auditing (FGA)
  • Transparent Data Encryption (TDE)

Module 12: Availability Enhancements

• Non-Auto-Login Support for Duplicate
  • Use Encrypted Backups Whose Decryption Keys are in a Non-Auto-Login Wallet
• Update and Drop the Catalog Without using DROP CATALOG and UPGRADE CATALOG Commands
• Automate the Two Step Manual Process into One Recovery Operation After Missing Logs Found During RECOVER DATABASE
  • Recrepair FAILURE Command
• Transport Data Across Platforms and Steps to Recover a Table
• What is Online Redefinition Supports?

Module 13: Oracle Data Pump, SQL Loader, and External Tables

• Enhancements of
  • Oracle Data Pump
  • SQL Loader
  • External Table

Module 14: In-Memory Column Store

• Dynamic Parameter in 12.2
  • INMEMORY_SIZE
• Caches Results of Virtual Columns and Frequently Evaluated Expressions For Subsequent Reuse
• How to Optimising Joined Columns by Creating Join Groups?
• Interact with Other Products and Features

Module 15: SQL Tuning

• Enhancement of SQL Performance Analyser
• Enhancement of SQL Plan Management
• Statistics Gathering Performance Improvements
  • Optimiser Statistics Advisor
• How to do SQL Performance Analyser (SPA) Enhancements to Make it Resilient to Certain Workloads Which Can Cause Divergence?
• What are the New Ways of SQL Processing?
• What are the Continuous Adaptive Query Plans?

Module 16: Resource Manager and Other Performance Enhancements

• Manage Session PGA Limit and Reduce Cursor Invalidations for DDLs
• Advanced Index Compression (HIGH)
• What are Real-Time Materialised Views with On Query Computation?
• Describe how to Use ON STATEMENT Refresh When a DML Operation Takes Place on Materialised Views Without the Need to Commit the Transaction?
• What is HCC Data Compression with ADO Row-Level Policy

Module 17: Partitioning

• Auto-List Partitioning and Composite Partitioning
• Multicolumn List Partitioning and Read-Only Partition
• Creation of Defer Subpartition Segment
• How to Filter Data During Partition Maintenance Operations?

Module 18: Manageability

• How to Start and Stop a DBOP by Specifying the Session ID and Serial#?

Module 19: Diagnosability

• Ho to Set a Retention Target to ADR for an Automatic Delete of ADR Files?
• How to Use the Retention Advisor?
• Installation of TFA Collector by Default for RDBMS (With RDBMS Root Scripts)
• Start TFA Collector
• Allow Data Pump Tracing Changes Without Stopping and then Restarting the Job
• MV Refresh Statistics

Module 20: Oracle Database Cloud Services

• What is Oracle Database Cloud Services Console?
• How to Create a Database Deployment Under 12.2?
• Procedure of Database Deployment Backup and Recovery Automatic
• Database Deployments Vs On-Premises Databases
• How to Migrate On-Premises Database to Oracle Database Public Cloud Services?

Module 21: SQL Enhancements

• What is New SQLcl Utility?
• Usage of New 128 Bytes Length for Database Objects
• How to Recall SQL*Plus Commands in the Same Session from Memory?
• How to Use the New VALIDATE_CONVERSION Function

Oracle Cloud Infrastructure Security Professional Training Course Outline

Module 1: Security Introduction

• Shared Security Responsibility Model
• Zero Trust Security
• Security Services Introduction
• Security Design and Controls

Module 2: Identity and Access Management Basic

• IAM
• AuthN
• AuthZ
• Common Policies
• Compartments
• Policy Inheritance and Attachment for Compartments
• Organisation Management

Module 3: Identity and Access Management - Advanced

• Conditional Policies
• Advanced Policies
• Tag-Based Access Control
• Dynamic Groups
• IAM- Federation
• Understanding Sign-In Options

Module 4: Infrastructure Security - Network

• VCN Intro
• Security Lists and NSG
• VCN Connectivity
• VPN Connect
• FastConnect

Module 5: Infrastructure Security - Network - Load Balancer and Certificates

• Load Balancer Concepts
• Public and Private Load Balancer
• Load Balancer Policies, Health Checks
• Load Balancer - SSL Handling
• Certificate Introduction

Module 6: Infrastructure Security - Network - Network Firewall

• OCI Network Firewall
• Network Firewall Policy

Module 7: Infrastructure Security - Compute

• Compute Security Best Practices
• Shielded Instances
• Bastion Host
• OS Management Intro
• Dedicated VM Hosts
• Vulnerability Scanning

Module 8: Infrastructure Security – Storage

• Object Storage Security
• Managing Access and Authentication
• File Storage (Refresher)
• File Storage Security

Module 9: Infrastructure Security – Database

• Database Security
• ADB Security
• Introduction to Data Safe
• Oracle Data Safe in OCI
• Oracle Data Safe- Security Assessment
• Oracle Data Safe: Activity Auditing
• Oracle Data Safe: Data Discovery
• Oracle Data Safe: Data Masking
• Oracle Data Safe: Architecture
• Oracle Data Safe: Target Database Connectivity

Module 10: Key Management - OCI Vault

• Encryption Basics
• Vault Introduction
• Import and Export Keys
• OCI Services Integration with Vault
• Back up and Replicate Vaults and Keys
• Vault Secrets

Module 11: Application Security

• OCI WAF
• WAF Concept

Module 12: Cloud Security Posture Management

• What is Cloud Security Posture Management?
• Cloud Guard - Introduction
• Cloud Guard - Concepts
• Cloud Guard Problems
• Cloud Guard Detector Recipes
• Cloud Guard Responder Recipes
• Cloud Guard Notifications
• OCI Threat Intelligence Service
• Cloud Guard Threat Detector

Module 13: Security Operations

• Managing Security Operations
• Monitoring
• Logging
• Ingesting Logs for Analytics
• Insights with Logging Analytics
• Audit
• Monitoring – Intro to Notification Service
• Event Service

Oracle Cloud Infrastructure DevOps Professional Training Course Outline

Module 1: Introduction to DevOps on OCI

• Overview of DevOps
• Overview of OCI DevOps Services
• OCI DevOps Architecture and Components
• OCI DevOps Tools

Module 2: OCI Container Engine for Kubernetes (OKE)

• Overview of OKE
• Deploying Kubernetes Clusters on OCI
• Managing OKE Clusters
• Deploying Applications on OKE

Module 3: OCI Developer Tools

• Overview of OCI Developer Tools
• Using OCI Developer Tools to Build and Deploy Applications
• Using OCI CLI
• Using OCI SDKs

Module 4: OCI DevOps Services

• Overview of OCI DevOps Services
• Using OCI Pipeline
• Using OCI Artifact Registry
• Using OCI Notifications

Module 5: Automating Infrastructure Deployment with Terraform

• Overview of Terraform
• Terraform Configuration Files and Syntax
• Deploying Infrastructure on OCI with Terraform
• Managing Infrastructure on OCI with Terraform

Module 6: Automating Application Deployment with Ansible

• Overview of Ansible
• Ansible Playbooks and Roles
• Deploying Applications on OCI with Ansible
• Managing Applications on OCI with Ansible

Module 7: Automating Software Delivery Pipelines with Jenkins

• Overview of Jenkins
• Creating Jenkins Pipelines
• Integrating Jenkins with OCI DevOps Services
• Automating the Deployment of Applications on OCI with Jenkins

Module 8: Best Practices for DevOps on OCI

• Security Best Practices
• Optimisation Best Practices
• Cost Optimisation Best Practices
• Disaster Recovery Best Practices

Oracle Cloud Infrastructure Developer Professional Training Course Outline

Module 1: Introduction to Oracle Cloud Infrastructure for Developers

• Overview of Oracle Cloud Services
• Understanding OCI's Architecture
• Setting up a Development Environment
• Introduction to the OCI SDK and APIs

Module 2: Core Developer Services

• Working with Compute and Storage Services
• Leveraging Oracle Container Engine and Functions
• Exploring Oracle API Gateway
• Deploying Applications on OCI

Module 3: Advanced Database Solutions

• Integrating Oracle Autonomous Database
• Developing with Oracle NoSQL Database
• Utilising Oracle MySQL Database Service
• Best Practices for Database Scalability

Module 4: Security and Compliance

• Implementing OCI Identity and Access Management
• Configuring Cloud Security Services
• Understanding Compliance and Data Protection
• Encryption and Key Management Techniques

Module 5: Developer Tools and Technologies

• Using Oracle Visual Builder Studio
• Introduction to Oracle Integration Cloud
• Leveraging Oracle Blockchain Platform
• Developing with Oracle Digital Assistant

Module 6: Microservices and Serverless

• Designing Microservices Architecture
• Building and Deploying Serverless Functions
• Managing Microservices with Kubernetes
• Continuous Integration and Continuous Delivery (CI/CD)

Module 7: Monitoring and Diagnostics

• Implementing Monitoring with OCI Monitoring Service
• Using OCI Logging for Application Insights
• Performance Analysis with OCI Operations Insights
• Setting up Alerts and Alarms

Module 8: Application Scalability and Resiliency

• Strategies for Application Scaling
• Implementing High Availability and Disaster Recovery
• Performance Tuning and Optimisation
• Load Testing and Auto-Scaling

Module 9: Cloud Native Development

• Developing Cloud Native Applications
• Utilising Microservices and Containers
• Implementing DevOps Practices
• Leveraging Open Source Tools and Frameworks

Oracle Cloud Infrastructure Architect Professional Workshop Training Course Outline

Module 1: Oracle Cloud Free Tier Account

• Demo: Oracle Cloud Free Tier Sign-up
• Demo: OCI Console Walk-through
• Demo: Setting up Your Tenancy
• Demo: MFA and Budget Setup

Module 2: OCI Architect Associate Refresher

• Identity and Access Management (Refresher)
• Virtual Cloud Network (Refresher)
• Compute (Refresher)
• Block Storage (Refresher)
• Object Storage (Refresher)
• File Storage (Refresher)
• Database (Refresher)
• Observability and Management (Refresher)
• Security (Refresher)

Module 3: Cloud-Native, Microservices, and Serverless Architecture

• API Gateway: Introduction to API Management
• API Gateway: Networking and Security Policies
• API Gateway: Creating an API
• API Gateway: Validating API Requests
• API Gateway: Authorising Requests
• API Gateway: Using Context Variable
• API Gateway: Transforming API Requests and Responses
• API Gateway: Monitoring APIs
• Container Registry: Fundamentals Review
• Container Registry: OCIR Concepts: Images
• Container Registry: OCIR Concepts: Repositories
• Container Registry: Pushing and Pulling Images
• Container Registry: Image Management
• OKE: Introduction
• OKE: Create Clusters
• OKE: Manage Clusters
• OKE: Understanding and Using Autoscaling Features
• OKE: Cluster Access & Security
• Functions: Intro
• Functions: Service Overview
• Functions: Triggers
• Functions: Use Cases
• Functions: Concepts
• Demo - Functions: Setting the Context: Modernise Legacy Book Store Application
• Demo - Functions: Publishing of Books Catalog Updates
• Demo - Functions: Reimplementing the Customer-Facing Books Catalog
• Streaming: Introduction
• Streaming: Features
• Streaming: Fundamentals
• Streaming: Use Cases
• Events: Fundamental Concepts
• Events: Event Messages and Event Types
• Events: Rule Actions
• Demo: Actions
• Events: Working with Rules
• Demo: Rules
• Events: Use Cases
• Hands-On Activity: Deploy an OKE Cluster
• Hands-On Activity: Configure Oracle Functions

Module 4: Design Scalable and Elastic Solutions for HA and DR

• High Availability
• Disaster Recovery
• Load Balancer Refresher
• Load Balancer - Session Persistence
• Load Balancer - Request Routing
• Load Balancer - SSL Handling
• Demo: Load Balancer
• DNS Zone Management - What is DNS
• DNS Zone Management - DNS Overview and Demo
• DNS Zone Management – OCI Private DNS and DNS Resolver Lab
• DNS Traffic Management - Overview and Failover Lab
• Hands-On Activity: Design Scalable and Elastic Solutions for HA and DR

Module 5: Deliver Infrastructure-as-code

• Terraform Configuration Files:OCI Provider
• Terraform Install
• Terraform Plan
• OCI Resource Manager
• Demo: Resource Manager
• Hands-On Activity: Deliver Infrastructure-as-code

Module 6: Oracle Database Cloud Service

• Database Cloud Service Overview
• Database Lifecycle Management
• Monitoring Database Cloud Service
• Maximum Availability Architecture

Module 7: Oracle Autonomous Database

• Provisioning
• Demo: Provisioning
• Start and Stop ADB
• Demo: Start and Stop ADB
• Scaling
• Auto Scaling
• Demo: Scaling
• Move ADB to another compartment
• Demo: Move ADB to another compartment
• Create an ADB clone
• Demo: Create an ADB clone
• Managing Users
• Connecting to Autonomous Database - Part 1
• Connecting to Autonomous Database - Part 2
• Demo: Connect to ADB
• Create alarms and events
• Demo: Create events and alarms
• Manage ADB backup and restores
• Demo: Backup and Recovery
• Autonomous Data Guard
• Dedicated Infrastructure Overview
• Describe Workflows and Functionality
• Provision Dedicated Resources: Exadata, Container Database, and VM Cluster
• Creating OCI Policies for Autonomous Dedicated
• Monitoring Dedicated Infrastructure
• Hands-On Activity: Oracle Autonomous Database

Module 8: Design for Hybrid Cloud Architecture

• OCVS - Introduction to Oracle Cloud VMware Solution
• OCVS - VMware Products Overview
• OCVS - Use Cases Benefits Values
• OCVS - SDDC Deployment
• OCVS - Design Hybrid Cloud
• OCVS - Network Topology
• Demo: OCVS
• Demo: Accessing SDDC
• Access to Microsoft Azure
• Demo: Access to Microsoft Azure
• Introduction to IPv6 with Oracle
• Demo: IPv6

Module 9: Migrate On-Premises Workloads to OCI

• Planning your Data Migration to OCI
• Data Migration - Offline Transport - Data Transfer Service
• Data Migration - Online Transport - Storage Gateway
• Database Migration - Methods and Best Practices
• Database Migration - Migrating to Autonomous Database
• Database Migration - Zero Downtime Migration

Module 10: Design for Security and Compliance

• IAM- Federation
• Understanding Sign-In Options
• Demo: Federation
• WAF - Concepts and Use Cases
• WAF - Architecture Review

Module 11: Real-World Architectures

• Reference Architecture 1: Architecture Overview
• Reference Architecture 2: Hub-Spoke Architecture
• Reference Architecture 3: HPC Architecture
• Reference Architecture 4: Security Architecture

Module 12: What's New in OCI Architect Professional

• Networking: IPv6 - Support for Load Balancer
• Networking: Certificates
• Demo: Certificates
• Demo: Certificate Authority - Part 1
• Demo: Certificate Authority - Part 2
• API Gateway: OCI Certificates Integration
• API Gateway: Network Security Groups
• API Gateway: Mutual TLS Support
• API Gateway: Customise Trust Store
• SCH: Dimensions
• OKE: Tagging Cluster Resources
• OKE: User-Managed Keys
• OKE: Custom Cloud-init Scripts
• OKE: File Storage for PVCs
• OKE: Capacity Reservations
• OKE: Network Security Groups
• OCI DevOps Overview
• DevOps Components
• OCI DevOps CICD
• Environment
• Oracle ADB-S: Oracle DB APIs for MongoDB
• Oracle ADB-S: Cloning Enhancements
• Oracle ADB-S: IAM Integration
• Oracle ADB-S: Other Enhancements
• Oracle ADB-D: Enhancements
• Oracle ADB-S: Autonomous Data Guard Enhancements

Oracle Cloud Infrastructure Operations Professional Training Course Outline

Module 1: Introduction to OCI Operations

• Overview of OCI Services and Infrastructure
• Key Concepts and Components in OCI
• Setting Up and Configuring OCI Environment
• Understanding the OCI Console and Dashboard

Module 2: Managing OCI Compute Resources

• Deployment and Management of Compute Instances
• Configuration and Scaling Options
• Using OCI Compute for Different Workloads
• Automation with Scripts and OCI CLI

Module 3: Network and Connectivity Management

• Setting Up Virtual Cloud Networks (VCN)
• Managing Load Balancers and Connectivity
• Advanced Network Configuration and Peering
• Network Security and Compliance

Module 4: Storage and Database Solutions

• Configuring OCI Storage Solutions
• Backup and Disaster Recovery Options
• Managing Oracle Databases in OCI
• Performance Optimisation for Storage and Databases

Module 5: Security and Compliance

• Implementing Identity and Access Management (IAM)
• Managing Users, Groups, and Policies
• Data Encryption and Security Best Practices
• Compliance Audits and Reports

Module 6: Monitoring and Troubleshooting

• Monitoring Resources with OCI Monitoring
• Setting Up Alarms and Notifications
• Troubleshooting Common Issues
• Using Logging and Diagnostic Tools

Module 7: Automation and Scripting

• Using OCI Resource Manager for Infrastructure as Code
• Scripting with OCI CLI and SDKs
• Automation of Routine Tasks
• Best Practices in Cloud Automation