close

close

Thank you for your enquiry!

One of our training experts will be in touch shortly to go over your training requirements.

close

close

Press esc to close

close close

Back to course information

Thank you for your enquiry!

One of our training experts will be in touch shortly to go overy your training requirements.

close close

Thank you for your enquiry!

One of our training experts will be in touch shortly to go over your training requirements.

Oracle Training courses

Online Instructor-led (3 days)

Online Self-paced (24 hours)

Oracle SQL Fundamentals Course Outline

The following sessions are taught during this Oracle course:

  • Session 1: Relational database concepts
  • Session 2: Using SQL*plus
  • Session 3: Using SQL developer
  • Session 4: Retrieving data with the select statement
  • Session 5: Aggregate functions
  • Session 6: Joining tables
  • Session 7: Numeric character and date functions
  • Session 8: Conversion and miscellaneous
  • Session 9: SQL Parameters
  • Session 10: Using subqueries
  • Session 11: Managing data
  • Session 12: Managing tables
  • Session 13: Managing indexes and views
  • Session 14: Managing sequences and synonyms
  • Session 15: Retrieve data using subqueries
  • Session 16: Hierarchical queries
  • Session 17: Enhanced grouping features
  • Session 18: Manage large data sets
  • Session 19: Flashback technology
  • Session 20: Date, time and timezone support
  • Session 21: Regular expression support
  • Session 22: Manage objects with the data dictionary
  • Session 23: Manage Schema Objects
  • Session 24: Access control

Show moredown

Prerequisites

There are no formal pre-requisites for the Oracle SQL Fundamentals course, although an understanding of databases and exposure to information technology would be useful.

Who should attend this Oracle Training Course?

Anyone who needs to use and understand Oracle SQL to query and update data in an Oracle database

Oracle SQL Fundamentals Course Overview

The Oracle SQL Fundamentals course is designed to give delegates practical experience in writing Oracle SQL statements and scripts.

After successfully completing this certification, delegates will be able to learn how to; create Oracle SQL statements to query database tables, use standard aggregate functions and related SELECT statement clauses, Implement extended SQL functions and many other useful skills.

Other vital skills that delegates will learn include; performing flashback operations, creating and using external tables as well as controlling user access to database objects.

The examinations are not included as a part of this course and will need to be purchased separately via Pearson Vue

Show moredown

What's included in this Oracle Training Course?

  • Delegate pack consisting of course notes and exercises
  • Manual
  • Experienced Instructor
  • Refreshments

Show moredown

Online Instructor-led (3 days)

Online Self-paced (24 hours)

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

The following topics will be taught during this Oracle course:

  • Installing and Configuring Oracle
  • Creating and Managing an Oracle Database
  • Administering an Oracle Database
  • Configuring the Oracle Network Environment
  • Creating and Managing Database Storage Structures
  • Managing Redo Log Files and Control Files
  • Managing Schema Objects
  • Managing Users, Profiles, Privileges and Roles
  • Managing Undo Data and Temporary Segments
  • Monitoring and Resolving Lock Conflicts
  • Maintaining Database Security
  • Monitoring the Performance of the Database
  • Loading and Unloading Data
  • Backing Up and Recovering the Database

Show moredown

Prerequisites

There are no prerequisites for this course but it has been recommended that delegates have the basic knowledge of Oracle SQL before taking this course.

Who should attend this Oracle Training Course?

Database Administrators who require the practical experience in setting up, administering and troubleshooting an Oracle 11g Release 1 or Release 2 database.

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

The Oracle Database 11g DBA - Part One course has been specifically designed for Database Administrators who require the practical experience in setting up, administering and troubleshooting an Oracle 11g Release 1 or Release 2 database.

After successfully completing this course, delegates will be able to learn how to install and configure Oracle, create and manage databases, manage to Redo log files and control files, configure the Oracle Network Environment and many other skills.

Show moredown

What's included in this Oracle Training Course?

  • Delegate pack consisting of course notes and exercises
  • Manual
  • Experienced Instructor
  • Refreshments

Show moredown

Online Instructor-led (3 days)

Online Self-paced (24 hours)

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

The following topics will be taught during this course:

  • Planning a backup strategy and a disaster recovery strategy
  • Altering a database to archivelog and noarchivelog modes
  • Managing memory
  • Using Recovery Manager to perform backups and restorations
  • Using Flashback technology to diagnose and repair a database
  • Reviewing database logs for diagnostic purposes
  • Using Database advisors and views to monitor and improve database performance
  • Controlling database resources using Resource Manager
  • Automating management tasks with the Scheduler

Show moredown

Prerequisites

You should have a good understanding of Oracle SQL and have previously attended our Oracle Database 11g Release 2 Part I course.

Who should attend this Oracle Training Course?

This course has specifically designed for data administrators who need to know how to set up, administer and troubleshoot Oracle databases.

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

The Oracle Database 11g Release 2 Part II course will enable delegates to learn and understand how to implement a backup and recovery strategy using Recovery Manager.

After successfully completing this course, delegates will be able to learn how to plan a backup strategy when an issue happens, alter databases to archive log and no archive log modes, use the recovery manager tool and many other fundamental skills.

Other techniques that delegates will learn include using flashback technology to diagnose and repair a database, reviewing database logs, automating management tasks and much more.

Show moredown

What's included in this Oracle Training Course?

  • Delegate pack consisting of course notes and exercises
  • Manual
  • Experienced Instructor
  • Refreshments​

Show moredown

Online Instructor-led (2 days)

Online Self-paced (16 hours)

Oracle 11g SQL Performance Tuning Course Outline

The following topics are taught during this Oracle SQL course:

  • Course Introduction
  • Session 1: Introduction to Oracle performance tuning
  • Session 2: Tools for evaluating SQL statements
  • Session 3: The optimizer
  • Session 4: Sorts
  • Session 5: Indexes
  • Session 6: Advanced indexes
  • Session 7: Joins
  • Session 8: Sequences and views
  • Session 9: Using Hints
  • Session 10: Miscellaneous

Show moredown

Prerequisites

Delegates should have completed the Oracle SQL course before taking this course.

Who should attend this Oracle Training Course?

This Oracle 11g SQL Performance Tuning course is specifically designed for SQL programmers, application developers/designers and technical support professionals who are required to tune the performance of an Oracle application running under Oracle 9i, 10g or 11g.

Oracle 11g SQL Performance Tuning Course Overview

Oracle SQL delivers a simple and easy architecture for defining, accessing and maintaining data. The Oracle 11g SQL Performance Tuning course introduces the delegate to the main concepts of Oracle SQL performance tuning.

After successfully completing this course, delegates will be able to gain skills in tuning database applications for optimal performance, managing statistics, structuring SQL statements for performance, using Hints to influence execution plans and many other vital techniques.

Show moredown

What's included in this Oracle Training Course?

  • Delegate pack consisting of course notes and exercises
  • Manual
  • Experienced Instructor
  • Refreshments

Show moredown

Online Instructor-led (3 days)

Online Self-paced (24 hours)

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

The following subjects will be taught during this course:

Course Introduction

  • Administration and Course Materials
  • Course Structure and Agenda
  • Delegate and Trainer Introductions

Changes to Database Management Tools

  • Enterprise Manager Cloud Control Home Page and Express home page
  • SQL Developer new functionality
  • Changes to the OUI and the DBCA

Oracle Database 12c Architecture

  • Overview of the Oracle database architecture
  • An overview of a Container Database (CDB)
  • The benefits of Multitenant Architecture
  • The root container and Pluggable Database containers
  • The structure of the Root Container
  • The structure of a Pluggable Database (PDB)
  • CDB_xxx and DBA_xxx Views

Create a Database with the Database Configuration Assistant

  • Select a database storage method
  • Select a CDB or non-CDB database
  • Select a database type based on workload
  • Select a character set for the database
  • Set the NLS_LANG initialization parameter
  • Create a database with the DBCA

Preparation for Upgrade To Oracle Database 12c

  • Methods used to perform upgrade and migrate data
  • Direct upgrade supported releases
  • Upgrade process overview
  • Rolling upgrade
  • Upgrade a CDB
  • Create an upgrade test plan
  • Carry out performance testing
  • Run the Pre-Upgrade Information Tool
  • Backup and Install the Oracle Database 12c software
  • Create the new Oracle home

Perform an Upgrade to Oracle Database 12c

  • Upgrade a database with the Database Upgrade Assistant (DBUA)
  • Upgrade a database manually
  • Migrate a non-CDB to a CDB

Migrate Data with Data Pump

  • Migrate data with Data Pump
  • Import data using a Data Pump network link

Configure and Create a Container Database and Pluggable Databases

  • Create and configure a CDB using Enterprise Manager
  • Examine the structure of a CDB using Enterprise Manager and the CDB_xxx Views
  • Administer the database using Enterprise Manager and SQL*Plus
  • Create a new PDB from PDB$SEED
  • Create a PDB from a Non-CDB
  • Clone a PDB into the same CDB using DB links
  • Plug in an Unplugged PDB

Manage a Container Database and Pluggable Databases

  • Connect to a CDB as an Administrator
  • Connect to a PDB using a service name
  • Startup and shutdown a CDB
  • Open and close a PDB Using SQL*Plus and EM
  • Open and close all PDBs
  • Change the state of a PDB

New Tablespaces and Management Features

  • Create permanent tablespaces in the root and PDBs
  • Online rename and relocation of an active datafile
  • Restrict PGA size
  • Implement extended data types for VARCHAR2, NVARCHAR2 and RAW data types to 32767 bytes
  • Temporary UNDO
  • DDL Logging

Manage Common and Local Users, Roles And Privileges

  • Manage common and local schemas and users in the Root and PDBs
  • Manage system and object privileges to common and local grantees
  • Manage common and local roles

Manage Backup, Recovery and Flashback of a CDB and PDB

  • Backup a CDB and a PDB
  • Recover a CDB from the loss of redo log files, control files and undo datafile loss
  • Use Flashback at CDB Level

Online Datafile Move and Automatic Data Optimization

  • Data classification in 12c
  • Configure a heat map
  • Automatic movement and compression
  • Compression levels and types

In Database Archiving

  • New In-database archiving solutions
  • Use the ROW ARCHIVAL clause to enable row lifecycle state for applications
  • Set the ROW ARCHIVAL VISIBILITY for session level visibility control
  • Use predicate on ORA_ARCHIVE_STATE column
  • Set a Temporal Validity: PERIOD FOR with the CREATE or ALTER TABLE clause
  • SQL temporal data type

Enhancements to Database Auditing

  • Overview of database auditing in R12
  • Security compliance
  • Standard auditing
  • Unified audit trail overview
  • Create a tablespace for the Unified Audit Trail
  • Separation of audit responsibilities with the AUDIT_ADMIN and AUDIT_VIEWER roles
  • Configure the Unified Audit Trail
  • Specify audit options
  • Configure the Unified Audit Trail to set a tolerance level for lost of audit records
  • Create audit policies

Enhancements to Privileges

  • Implement the separation of duties for Database Administration tasks
  • Grant the CAPTURE_ADMIN role to enable management of privilege captures
  • Create, start and stop privilege captures
  • Query the DBA_PRIV_CAPTURES view
  • Use the mandatory INHERIT PRIVILEGES privilege to execute the invoker's rights procedure

Data Redaction

  • Types of data masking policies
  • Administer the EXEMPT REDACTION POLICY system privilege to enable a user to view unmasked values
  • Manage masking policies
  • Understanding the masking of statements containing subqueries
  • Query the data dictionary to obtain information on masking policies

New RMAN Features

  • The SYSBACKUP privilege
  • Execute SQL statements in RMAN
  • Use the RMAN DESCRIBE Command
  • Table or partition recovery
  • Restore and recover datafiles across the network
  • Run the duplicate operation with the NOOPEN option
  • Backup and restore very large files
  • Cross-platform backup and restore

Monitoring Database Operations

  • Overview of DB monitoring operations
  • Bracketing an operation
  • Monitoring the progress of operations
  • DB Operation tuning and active report

Schema and Data Changes

  • Create identity columns
  • Create a table with invisible columns
  • Truncate table cascade
  • Session level sequences
  • Create multiple indexes on the same set of columns
  • Advanced Row Compression
  • The Schema Change Plan flow
  • Schema synchronization
  • The Data Comparison flow
  • The DBMS COMPARISON package

SQL and PL/SQL Enhancements

  • SQL*Plus Enhancements
  • Row limiting for Top-N result Queries
  • The Schema Change Plan flow
  • PL/SQL Enhancements
  • Implicit results on SQL*Plus
  • WITH clause enhancements

Performance Tuning New Features

  • Partitioning Enhancements
  • Data Pump Single-Partition Imports
  • Materialized Views and Query Rewrite Enhancements
  • The PIVOT and UNPIVOT Clauses
  • Data Compression
  • Enhancements to the Degree of Parallelism
  • System Managed Indexes for List Partitioning
  • Overview of new ADDM Analysis features
  • Real-time ADDM analysis
  • Defining Workload dimensions
  • Reported items and Root Causes
  • Report requirements

Resource Manager and Other Performance Enhancements

  • Manage resources within a PDBs and CBPs
  • Manage runaway queries
  • Automated maintenance tasks

ADR and Network Support

  • ADR file types
  • New File types and locations
  • New commands for ADRCI
  • Improve performance by Compression

Data Pump and SQL*Loader Enhancements

  • Data Pump enhancements
  • Turn off redo log generation
  • Transport view as table
  • Use FULL Transportable export and import
  • SQL*Loader enhancements

Partitioning Enhancements

  • Move a partition online
  • The split partition operation enhancement
  • The merge partition operation
  • The Add and drop partition operations

Show moredown

Prerequisites

There are no prerequisites, but we recommend having a good knowledge of Oracle Database 12c.

Who should attend this Oracle Training Course?

This Oracle 12C New Features for Administrators course is designed for Oracle professionals who need to gain an understanding of and implement the new features and functionality introduced in Oracle Database 12c, including database administrators and system administrators.

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

This Oracle 12C New Features for Administrators course is designed to give Oracle Database Administrators practical experience in using the new features available in Oracle Database 12c.

Delegates will gain an appreciation of how these features can be used to increase security, manageability and performance.

After successfully completing this course, delegates will be able to gain skills in creating an Oracle Database 12c, upgrading a database to Oracle Database 12c, managing Container and Pluggable databases and many other vital techniques.

Show moredown

What's included in this Oracle Training Course?

  • Delegate pack consisting of course notes and exercises
  • Manual
  • Experienced Instructor
  • Refreshments

Show moredown

Online Instructor-led (3 days)

Online Self-paced (24 hours)

Oracle Database 12c: Administration Course Outline

The following subjects will be taught during this course:

Course Introduction

  • Administration and Course Materials
  • Course Structure and Agenda
  • Delegate and Trainer Introductions

Introduction to Oracle Database 12c

  • Overview of the Oracle Database 12c
  • Overview of the Oracle Cloud
  • Relational database concepts
  • Database administration tasks

Oracle Database 12c Architecture

  • Overview of the Oracle database architecture
  • The Oracle database instance
  • Oracle Database memory structures
  • Process architecture and structures
  • Server and client processes
  • The Oracle database storage architecture
  • Connect to the Oracle database instance

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
  • Administer the database using Enterprise Manager (EM)
  • Overview of the Enterprise Manager framework
  • Access Enterprise Manager Database Express
  • The Enterprise Manager Database Express Home Page
  • Enterprise Manager Cloud Control
  • Initialization parameter files

Configure the Oracle Network Environment

  • Overview of network configuration
  • Oracle Net Listener configuration and management
  • Oracle Net naming methods
  • Tools for configuring and managing the Oracle network
  • Using the Net Configuration Assistant
  • Configure client connections with Net Manager
  • View listener configuration
  • Start and stop the Oracle listener
  • Use TNSPING to test Oracle Net connectivity
  • Connect to the database
  • Configure Net Services with Enterprise Manager

Storage Structures

  • Overview of data storage
  • The database block
  • Overview of tablespaces and datafiles
  • Use Enterprise Manager to view the storage structure of the database
  • Create and alter tablespace commands
  • Temporary tablespaces
  • Create and manage data files
  • Use OMF
  • Drop tablespaces and datafiles

Manage Users

  • Predefined database administration accounts
  • User accounts
  • Create a user account
  • User authentication
  • Change a user's password
  • Manage a user account
  • Drop a user account
  • Monitor user information
  • Terminate user sessions

Manage Profiles and Resources

  • Overview of user profiles
  • Profile resource parameters
  • Create profile command
  • Manage passwords with profiles
  • Control resource usage with profiles
  • Maintain profiles

Manage Privileges

  • Database access
  • Oracle-supplied roles
  • System and object level privileges
  • The grant and revoke commands
  • Create, modify and drop roles
  • Use predefined roles

Database Auditing

  • Overview of database security
  • Overview of database auditing
  • Security compliance
  • Standard auditing
  • Unified audit trail
  • Separation of audit responsibilities with the AUDIT_ADMIN and AUDIT_VIEWER roles
  • Configure the audit trail
  • Specify audit options

Data Concurrency and Lock Conflicts

  • Levels of locking in Oracle
  • Methods used to acquire locks
  • Data concurrency
  • Possible causes of contention
  • DML locks
  • Prevent locking problems
  • Detect lock contention
  • Resolve conflicts

Undo Management

  • Undo data overview
  • Monitor and administer undo
  • Configure undo retention
  • Switch undo tablespaces
  • Specify the retention period
  • Guarantee undo retention
  • Retention period for flashback queries
  • View undo space information
  • Use the undo advisor
  • Size the undo tablespace
  • Alter an undo tablespace to a fixed size

Proactive Database Maintenance

  • Database Maintenance
  • View the alert log
  • The Automatic Workload Repository
  • Statistic levels
  • The Automatic Database Diagnostic Monitoring
  • Monitor an Oracle database
  • Use the Advisors
  • Set up notification rules

Performance Management

  • Tuning information sources
  • Performance monitoring
  • Tuning activities
  • Performance planning
  • Instance tuning
  • Performance tuning methodology
  • Performance tuning data
  • Monitoring performance
  • Managing memory

SQL Tuning

  • SQL tuning
  • The Oracle Optimizer
  • SQL Plan directives
  • Adaptive execution plans
  • SQL Advisors
  • Automatic SQL Tuning results
  • Implement automatic tuning recommendations
  • SQL Tuning Advisor

Moving Data

  • Create directory objects
  • Data Pump architecture, data dictionary views, interactive mode and API's.
  • Use Data Pump to export data and import data
  • Overview of SQL Loader
  • Command line parameters
  • Record filtering
  • Control file keywords
  • Datafiles
  • SQL Loader data paths
  • External Tables

Automate Tasks with the Scheduler

  • Introduction to the Scheduler
  • Access Rights
  • Scheduler components and workflow
  • Create a Job and Job Classes
  • Create an event-based schedule

Managing Resources with Resource Manager

  • Overview of the Database Resource Manager
  • Use the Resource Manager and create resource plans
  • The default maintenance resource manager plan
  • Create Resource Plan Directives
  • Allocate resources for Resource Plans

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

Backup and Recovery Configuration

  • Oracle backup solutions and suggested backup strategy
  • Overview of database backup, restore and recover
  • Flashback technology
  • Types of failure
  • Tune instance recovery
  • The MTTR Advisor
  • Media failure
  • Configure a database for recoverability

Oracle Support

  • The Enterprise Manager Support Workbench
  • Register for security updates
  • Work with Oracle Support
  • My Oracle Support integration
  • Log Service Requests
  • Manage and Apply patches

Show moredown

Prerequisites

There is no prerequisite, although knowledge of PL/SQL would be highly beneficial.

Who should attend this Oracle Training Course?

This Oracle Database 12c Administration course has been specifically designed for anyone who needs to administer, monitor and support an Oracle 12c database.

Oracle Database 12c: Administration Course Overview

This Oracle Database 12c Administration course is designed to give the Oracle database administrator practical experience in administering, monitoring, tuning and troubleshooting an Oracle 12c database. Database administrators will gain an understanding of the architecture and processes of the Oracle database server.

They will be able to ensure the integrity and availability of a company's data within the Oracle environment. They will be able to monitor the performance of the database, allocate resources with the Resource Manager and Schedule jobs.​

Show moredown

What's included in this Oracle Training Course?

  • Delegate pack consisting of course notes and exercises
  • Manual
  • Experienced Instructor
  • Refreshments

Show moredown

Online Instructor-led (2 days)

Online Self-paced (16 hours)

Oracle Discoverer Desktop for End Users Course Outline

The following sessions will be taught during the Oracle Discover course:

Session 1: What is Oracle Discoverer?

  • Overview of Oracle Discoverer
  • Oracle Discoverer Components
  • Connecting to Oracle Discoverer
  • Workbooks and Worksheets

Session 2: Workbook Basics

  • The Discoverer Workbook Window
  • The Button Bars
  • Displaying Data
  • Selecting Worksheet Sections
  • Viewing Pages

Session 3: Workbook Formatting

  • Re-Ordering and Resizing Columns
  • Formatting Headings and Data
  • Using Graphic Bars
  • Worksheet Titles

Session 4: Creating a Workbook

  • Overview of Workbook Creation
  • Adding a Table Layout Worksheet
  • Adding a Crosstab Layout Worksheet
  • Page-Detail Worksheets
  • Duplicating Sheets
  • Worksheet Management

Session 5: Conditions

  • Creating and Editing a Condition
  • Creating and Using Parameters
  • Advanced Conditions

Session 6: Counts and Calculations

  • Creating COUNTS on a worksheet
  • Creating and Editing Calculations
  • Introduction to Oracle functions

Session 7: Graphing Your Data

  • Overview of Graphs in Oracle Discoverer Worksheets
  • The Graph Tool Bar
  • Creating a Graph
  • Modifying a Graph
  • Reference Lines and Pull-Outs
  • Rotating a Graph

Session 8: Workbook Manipulation

  • Pivoting Data
  • Drilling into Data
  • Sorting Data

Session 9: Data Analysis Tools

  • Overview of the Data Analysis Tools
  • Creating and Editing a Total
  • Creating and Editing a Percentage
  • Formatting Exceptions

Note - in practice this session may start on the first day

Session 10: Reports

  • Printed Reports
  • Scheduled Reports
  • Using the Scheduling Manager

Session 11: Advanced Features

  • Subqueries
  • Correlating a Subquery
  • Setting Oracle Discoverer Options

Session 12: Analytical Functions

  • Introduction - Analytical Functions and their Purpose
  • Examples of Analytical Functions
  • Creating Calculations using Analytical Functions

Session 13: Discoverer and The Web

  • Overview of Discoverer on the Web
  • Discoverer on the Web components
  • Accessing Oracle Discoverer Workbooks
  • Running Oracle Discoverer Plus for the first time
  • Maintaining Discoverer Preferences

Session 14: Discoverer and The Web using 10gAS

  • Accessing the connections page
  • Creating Private Connections
  • Using Oracle Discoverer Plus
  • Using Oracle Discoverer Viewer

Session 15: Discoverer and The Web using 9iAS

  • Accessing the connections page
  • Creating Private Connections
  • Using Oracle Discoverer Plus
  • Using Oracle Discoverer Viewer

Show moredown

Prerequisites

An ability to use a Windows interface is needed prior to attending this course.

Who Should Attend this Oracle Training Course?

This Oracle Discoverer course has been specifically designed for individuals who would like to use the tool to analyse data.

Oracle Discoverer Desktop for End Users Course Overview

This course provides individuals with the skills needed to analyse data using Discoverer Workbooks. This course introduces the end user to the Oracle Discoverer Tool for processing workbooks.

It introduces the concept of the Oracle Discoverer End Use Layer (EUL) and how, by building and manipulating workbooks, they can perform analysis of the data sources at their disposal. After successfully completing this course, delegates will be able to learn how to create workbooks and worksheets, use data analysis tools, use command line interface and many other skills.

 

Show moredown

What's included in this Oracle Training Course?

  • Delegate pack consisting of course notes and exercises
  • Manual
  • Experienced Instructor
  • Refreshments

Show moredown

Online Instructor-led (3 days)

Online Self-paced (24 hours)

Oracle Discoverer for Administrators Course Outline

The following sessions will be taught during this Oracle Discoverer course:

Session 1: What is Oracle Discoverer?

  • Overview
  • Discoverer Components
  • The Discoverer Administration Interface
  • The Data Page
  • The Hierarchies Page
  • The Item Classes Page
  • The Summaries Page
  • The Discoverer Workbook Window

Session 2: Database Requirements for Using Discoverer

  • Introduction
  • Preparing for the use of Scheduled Workbooks
  • Requirements for Summary Management
  • Query Prediction

Session 3: The End User Layer

  • Introduction - the Purpose of the End User Layer
  • Creating an EUL
  • Managing the EUL
  • Deleting an EUL

Session 4: Business Area Management

  • Introduction - Business Areas and their Use
  • Building a New Business Area
  • Building a New Business Area with the Load Wizard
  • Applying security and privileges to a Business Area
  • Scheduling workbooks

Session 5: Folder Management

  • Introduction - the Types of Folder
  • Creating a Simple Folder
  • Creating a Complex Folder
  • Creating a Custom Folder
  • Folder Properties
  • Editing the SQL of a Custom Folder
  • Sharing Folders across Business Areas
  • Folder Operations
  • Importing and Exporting using Discoverer Administrator

Session 6: Managing Items and Item Classes

  • Introduction - Items, Item Classes and their Use
  • Item Properties
  • Deleting an Item
  • Creating and Editing Item Classes
  • Using the Item Class Page to Manage Item Classes

Session 7: Joins, Calculations, Conditions and Hierarchies

  • Introduction - the Use and Purpose of these Objects
  • Joins
  • Calculations
  • Conditions
  • Hierarchies

Session 8: Summary Folders

  • Introduction - the Purpose of Summary Folders
  • What is a summary Folder?
  • Creating a Summary Folder
  • Editing and Repairing Summary folders
  • Summary Folder Properties
  • Automated Summary Management

Session 9: EUL Status Workbooks

  • Introduction - What are EUL Status Workbooks?
  • Installing the EUL v5 Business Area
  • Workbook Content

Session 10: Introduction to Application Server

  • Introduction to the Application Server
  • A Simple Application Server Environment to Support Discoverer
  • Oracle Application Server Installation Types
  • Managing an Application Server
  • The Enterprise Manager Website
  • The Application Server Farm Home Page
  • The Application Server Instance Home Page
  • The Components' Home Pages
  • Starting and Stopping Components and their Effects
  • Clues to Potential Web Problems

Session 11: Discoverer Architecture

  • Introduction - Discoverer Architecture on the Web
  • The Discoverer Services
  • Accessing Discoverer Plus
  • Accessing Discoverer Viewer

Session 12: Configuring Discoverer for the Web

  • Introduction - the Discoverer Configuration Page
  • Issues Concerning Running Discoverer Plus for the First Time
  • Managing Discoverer Services
  • Shutting Down the Discoverer System
  • Using Discoverer in a Multi-Machine Environment
  • Creating Public and Private Discoverer Connections
  • Discoverer and Oracle Single Sign-On
  • Configuring Single Sign-On to Protect Discoverer
  • Connecting to Discoverer with Single Sign-On

Session 13: Influencing Discoverer Behaviour

  • Introduction - Discoverer Preferences and Oracle Web Cache
  • Maintaining Oracle Discoverer Preferences
  • Using Parameters in the Oracle Discoverer URLs
  • Oracle Discoverer and the Oracle Web Cache
  • Configuring Oracle Discoverer to use the Web Cache

Show moredown

Who Should Attend this Oracle Training Course?

This Oracle Discover certification has been specifically designed for individuals looking to set up or maintain relevant Business Areas within an Oracle Discoverer End User Layer.

Prerequisites

Individuals must attend the Oracle Discoverer Plus for End Users course before attending this qualification.

Having knowledge of Oracle SQL is needed before attending this course

Practical knowledge of Oracle Application Server Administration would be beneficial to have before taking this course.

 

Oracle Discoverer for Administrators Course Overview

This course is designed for individuals intending to set up and administer Business Areas within a Discoverer End User Layer (EUL). Understanding and efficiently utilizing the features of the Discoverer Administration tool is critical to the provision of pertinent data to End Users of Discoverer Plus or Discoverer Desktop. After successfully completing this course, delegates will be able to create and maintain the Oracle Discoverer EUL, develop Oracle Discover Business areas, manage simple and complex folders and many other techniques.

Show moredown

What's included in this Oracle Training Course?

  • Delegate pack consisting of course notes and exercises
  • Manual
  • Experienced Instructor
  • Refreshments

Show moredown

Online Instructor-led (3 days)

Online Self-paced (24 hours)

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 and Pluggable Database Containers
  • The Structure of the Root Container
  • The Structure of a Pluggable Database (PDB)
  • CDB_xxx and DBA_xxx Views

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

  • Plan an Installation
  • System Requirements and Operating System Prerequisites
  • Carry Out Pre-installation Checks
  • Set Environment Variables
  • Set Permissions to Run Root Configuration Scripts Automatically
  • 19c Automated Installation, Configuration and Patching
  • Install the Oracle Database Software with the Oracle Universal Installer
  • Silent Mode Installation
  • 19c Image Based Client Installation
  • 19c Automated Installation and Patching
  • Database Software Deinstallation

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

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

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

  • Methods Used to Perform an Upgrade
  • Methods of Data Migration
  • Direct Upgrade Supported Releases
  • 19c Simplified Upgrade with Auto Upgrade
  • The Database Upgrade Assistant
  • Upgrade Process Overview
  • Rolling Upgrade
  • Create an Upgrade Test Plan
  • Carry out Performance Testing
  • Run the Pre-Upgrade Information Tool
  • Pre-Configuration of the ORAchk Utility with Default Values
  • Backup the Database
  • Install the Oracle Database Software
  • Create the New Oracle Home

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
  • Carry Out Post Upgrade Tasks After a Manual Upgrade
  • Migrate to Unified Auditing

Module 6: Migrate Data with Data Pump

  • 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
  • Enhancements to Unified Auditing 18c & 19c
  • Audit Top Level User Activities in 19c
  • Audit a Read-Only Database to the Operating System 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
  • 12.2 Administrative Password Security Enhancements
  • Schema Only Accounts from 18c
  • Passwords Removed from Schema Only Accounts in 19c
  • Grant Administrative Privileges to Schema Only Accounts in 19c
  • Control Definer's Rights Privileges for Database Links
  • 19c Privilege Analysis with an Enterprise Edition License
  • Database Privilege Analysis with Database Capture
  • Grant the CAPTURE_ADMIN Role to Enable Management of Privilege Captures
  • Create, Start and Stop Privilege Captures
  • Viewing Privilege Profile Data
  • Query the DBA_PRIV_CAPTURES View
  • The Default ORA$DEPENDENCY Profile
  • Execute the Invokers Rights Privilege with the Inherit Privilege

Module 9: New RMAN Features

  • 12.2 RMAN Syntax Enhancements
  • Enhanced Table Point in Time Recovery from 12.2
  • The 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
  • Simplified RMAN Duplication of TDE Tablespaces

Module 10: Miscellaneous New Features

  • Cancel a SQL Statement in a Session from 18c
  • Online Redefinition Enhancements from 18c
  • Use Private Temporary Tables from 18c
  • Miscellaneous Data Redaction Enhancements
  • New Algorithm for Tablespace Encryption from 19c
  • 12.2 INMEMORY_SIZE Parameter
  • 12.2 INMEMORY Enhancements

Module 11: SQL and PL/SQL Enhancements

  • SQL*Plus Enhancements
  • The login.sql File
  • SQL*Plus Command Line History
  • SQL*Plus Performance Settings Options
  • The 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
  • The 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
  • Automatic Plan Capture Enhancements
  • The Optimizer Statistics Advisor Rules, Findings, Recommendations and Actions
  • The Expression Statistics Store
  • Enhancements to the SQL Performance Analyser
  • Configure the Automatic SPM Evolve Advisor Task to Run Hourly
  • Automatic Resolution of SQL Plan Regressions
  • 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
  • Configure a Lightweight, High Frequency Statistics Gathering Job for Stale Statistics
  • Advanced Index Compression
  • Automatic SQL Plan Management
  • SQL Statements Terminated by the Resource Manager Quarantined
  • Improved Diagnosis and Repair Capabilities with the Test Case Builder and the SQL Repair Advisor
  • COUNT(DISTINCT) Rollup
  • Polymorphic Tables Enhancements
  • HCC Data Compression with an ADO Row-Level Policy

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
  • The Usage of Wildcards in TRANSPORT_DATAFILES
  • New Substitution Variables for Filenames
  • Parameter File Contents Written to the Log File
  • The REMAP_DIRECTORY Parameter
  • DATA_OPTIONS Parameter Changes
  • Dynamic Data Pump Tracing
  • Miscellaneous New Data Pump Features

Module 16: SQL*Loader and External Table Enhancements

  • SDF_PREFIX Parameter
  • HADOOP_TRAILERS Parameter
  • Hexadecimal and Multi-Byte String Support for SQL*Loader Express
  • InMemory External Tables
  • External MODIFY Clause
  • Load XML Documents with the XML TAG Clause

Module 17: Database Diagnostic New Features

  • Set an ADR Retention Target from 12.2
  • The Retention Advisor
  • The TFA Collector
  • Install the TFA Collector
  • Manage the TFA Daemon
  • Start and Stop the TFA Collector
  • Quarantined Objects

Module 18: Data Guard New Features

  • 12.2 Data Guard New Features
  • Use the DBCA and EM Command Line Interface to Create Standby Databases
  • Create Scripts with the Broker DGMGRL Command Line Interface
  • Automatic Password File Management
  • Simple Repair of No Logging Operations
  • Perform Data File Block Comparison Between the Primary and a Standby
  • Multiple Fast Start Failover Targets and Observers
  • Fast Start Failover in Maximum Protection mode
  • Zero Data Loss Failovers in any Mode with Storage Failures
  • Enhanced Control of Alternative Destinations
  • Use RMAN and Enterprise Manager to Create Far Sync Instances
  • 18c Data Guard New Features
  • New Broker VALIDATE Commands
  • Multi-Instance Redo Apply
  • Keep Buffer Cache at Role Change
  • 19c Data Guard New Features
  • New Broker Commands
  • Export and Import the Broker Configuration File
  • Dynamically Change Fast Start Failover Target Using the Data Guard Broker
  • Observe Only Mode to Test Fast Start Failover
  • Data Guard Physical Standby Using the Data Guard Broker in 18c and 19c
  • Automatically Replicate Restore Points from Primary to Standby
  • Flashback a Standby Database when the Primary is Flashed Back
  • Periodically Clear the Flashback Logs
  • Active Data Guard Redirection

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
  • Use AWR and SQL Tuning Advisor to diagnose and Tune Redo Apply and Query Issues on an Active Data Guard Standby
  • Move Users Transparently During Role Change on the Primary and Preserve Existing Connections at the Active Data Guard Standby
  • Increased Protection with Auto Block Repair Enhancements
  • Control Login Attempts
  • 18c Active Data Guard New Features
  • New RECOVER STANDBY DATABASE FROM SERVICE
  • Execute DML
  • Create Global Temporary Tables
  • Standby Nologging for Load Performance and Data Availability

Module 20: Transparent Sensitive Data Protection

  • Overview of New Security Features Support for TSDP
  • TSDP with Unified Auditing
  • TSDP with Fine-Grained Auditing
  • TSDP with TDE Column Encryption
  • 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
    • New States Management
    • Declarative Request Demarcation

Show moredown

Prerequisites

There are no prerequisites for this course.

Audience

This course is for IT Professionals who want to learn about databases and Oracle Technologies.

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

This Oracle Database 12cR2, 18c, and 19c New features for administrators’ course is designed to provide knowledge of how to use new non-container database features that have been introduced in Oracle Database 12cR2, 18c, and 19c. Delegates will acquire knowledge of how the enhanced features of Oracle Database 12cR2, 18c, and 19c can be implemented at their own site.

This training course will teach how to install oracle database 18c/19c software with OUI and create a non-container oracle database 18c or 19c Database. This course will teach delegates how to upgrade an Oracle Database 18c or 19c database and migrate a database to 18c/19c with data pump. They will also gain an understanding of new database management features and enhancements to unified auditing. In this course, delegates will learn schema and data management new features and SQL*PLUS history commands and the SQLcl utility. They will also learn about new SQL, PL/SQL, RMAN and availability features.

This 3-day course explains data redaction and data encryption enhancements. Delegates will acquire knowledge of performance tuning, data pump, SQL*Loader and external table. They will also learn about SQL tuning enhancements using the optimiser statistics advisor and SQL join processing. This course also describes data guard, active data guard, and the broker. Furthermore, they will learn how to use the in-memory column store new feature for increasing SQL performance.

Show moredown

  • Delegate pack consisting of course notes and exercises
  • Manual
  • Experienced Instructor

Show moredown

Online Instructor-led (1 days)

Online Self-paced (8 hours)

Oracle VirtualBox Training Course Outline

Module 1: Get Started with Virtual Basics

  • Introduction to Virtualisation
  • What is Hypervisor?
  • Virtualisation Benefits
  • Introduction to Oracle VM VirtualBox
  • Oracle VirtualBox Features
  • How Oracle VirtualBox Works?
  • Executable and Components

Module 2: Install VirtualBox

  • System Requirements
  • Download Oracle VirtualBox
  • Install Oracle VirtualBox on Windows
  • Install Oracle VirtualBox on Linux

Module 3: Create Virtual Machines

  • What is a Virtual Machine?
  • What is the Guest Operating System?
  • Create a Virtual Machine
  • Install Guest  OS
  • Install Ubuntu
  • VirtualBox Guest Additions

Module 4: Use Virtual Machines

  • Start Virtual Machine
  • Pause Virtual Machine
  • Virtual Machine Snapshots
  • Take, Restore, and Delete Snapshots
  • Clone Virtual Machine
  • Virtual Machine Groups

Module 5: Administer Virtual Machines

  • Change Virtual Machine Name
  • Memory Management
  • Move Virtual Machine
  • Remove Virtual Machine
  • Log Viewer

Module 6: Configure Devices

  • Add DVD or CD-ROM Drive
  • Add Floppy Drive
  • USB Settings
  • Virtual Disks
  • Hard Disk Controller
  • Disk Image Files

Module 7: Configure Networking

  • Virtual Networking
  • Network Modes
  • Configure NAT Networking
  • Configure Bridged Networking
  • Configure Internal Networking
  • Configure Host-Only Networking

Show moredown

Prerequisites

There are no prerequisites for this course.

Audience

This course is for IT Professionals who want to learn about virtualisation and Oracle Technologies.

Oracle VirtualBox Training​ Course Overview                                                                                                 

In computing, virtualisation means to create a virtual version, such as a server, storage device, network and operating system where the framework divides the resource into one and more execution environments. Virtualisation reduced operating system costs, eliminated downtime, faster provisioning of applications and resources, increase IT productivity, efficiency, agility and responsiveness.

The hypervisor is a hardware virtualisation technique that allows multiple guest operating system to run on a single host system at the same time. The hypervisor is also known as a VMM (virtual machine manager). The hypervisor split into two classes: bare metal and hosted. Bare-metal hypervisors run guest virtual machines directly on the system whereas hosted hypervisor is installed on a host computer, which already has an operating system installed. It runs as an application like other application or software on the computer.

Oracle VirtualBox is a cross-platform and open-source application to create, manage, and run virtual machines. VM’s are computers or machines whose hardware components are emulated by the host computer. Delegates will gain an understanding of how oracle VirtualBox work and how to install virtual box. They will also learn how to create and use virtual machines. In this 1-day course, delegates will learn how to manage virtual machines, configure devices, and configure networking. In networking, delegates will learn about virtual networking, network modes, configure NAT networking, bridged networking, internal networking, and host-only networking.

Show moredown

  • Delegate pack consisting of course notes and exercises
  • Manual
  • Experienced Instructor

Show moredown

Online Instructor-led (3 days)

Online Self-paced (24 hours)

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 of the Oracle Database Architecture
  • The Oracle Database 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
  • Administer the Database using Enterprise Manager (EM)
  • Overview of the Enterprise Manager Framework
  • Access Enterprise Manager Database Express
  • Enterprise Manager Database Express Home Page
  • Enterprise Manager Cloud Control
  • Initialisation Parameter Files

Module 4: Configure the Oracle Network Environment

  • Overview of Network Configuration
  • Oracle Net Listener Configuration and Management
  • Oracle Net Naming Methods
  • Tools for Configuring and Managing the Oracle Network
  • Using the Net Configuration Assistant
  • Configure Client Connections with Net Manager
  • View Listener Configuration
  • Start and Stop the Oracle Listener
  • Use TNSPING to Test Oracle Net Connectivity
  • Connect to the Database
  • Configure Net Services with Enterprise Manager

Module 5: Storage Structures

  • Overview of Data Storage
  • The 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
  • User Authentication
  • 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, Modify and Drop Roles
  • Use Predefined Roles

Module 8: Manage Profiles and Resources

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

Module 9: Database Auditing

  • Overview of Database Security
  • Overview of Database Auditing
  • Security Compliance
  • Standard Auditing
  • Unified Audit Trail
  • Separation of Audit Responsibilities with the AUDIT_ADMIN and AUDIT_VIEWER roles
  • Configure the Audit Trail
  • Specify Audit Options

Module 10: Data Concurrency and Lock Conflicts

  • Levels of Locking in Oracle
  • Methods used to acquire Locks
  • Data Concurrency
  • Possible causes of Contention
  • DML Locks
  • Prevent Locking Problems
  • Detect Lock Contention
  • Resolve Conflicts

Module 11: Undo Management

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

Module 12: Backup and Recovery Configuration

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

Module 13: 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 14: Performance Management

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

Module 15: SQL Tuning

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

Module 16: Moving Data

  • Create Directory Objects
  • Data Pump Architecture
  • Data Pump Data Dictionary Views
  • Data Pump Interactive Mode
  • Data Pump API
  • 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 17: Managing Resources with Resource Manager

  • Overview of the Database Resource Manager
  • Use the Resource Manager
  • Create Resource Plans
  • Default Maintenance Resource Manager Plan
  • Create Resource Plan Directives
  • Allocate Resources for Resource Plans

Module 18: 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 19: 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 20: Oracle Support

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

Show moredown

Prerequisites

There are no prerequisites for this course.

Audience

This course is for IT Professionals who want to learn about databases and Oracle Technologies.

Oracle Database 19c Administration Training​ Course Overview

Oracle Database 19c is a multi-model database providing complete support to relational as well as non-relational data, for e.g. XML, JSON, text, and graph data. Along with this, Oracle Database enables SQL access to non-relational data using SQL extensions or native APIs.

This course is designed to provide the knowledge of how to administer, monitor, tune, and troubleshoot an Oracle database. Delegates will get familiarised with the architecture and processes of the Oracle database server. They will learn how to ensure the company’s data integrity and availability within the Oracle environment. This course explains how to monitor the database performance, resource allocation with the resource manager and schedule jobs with the Oracle Job Scheduler.

This course describes how to configure the Oracle Network Environment as well as create and manage database storage structures. In this course, delegates will learn how to manage users, profiles, privileges and roles. They will also gain an understanding of how to manage temporary segments. This course teaches delegates how to monitor and resolve lock conflicts. Delegates will learn how to load and unload data. They will also acquire knowledge of how to use the job scheduler and configure a database for backup and recovery.

Show moredown

  • Delegate pack consisting of course notes and exercises
  • Manual
  • Experienced Instructor

Show moredown

Online Instructor-led (3 days)

Online Self-paced (24 hours)

Oracle Database 18c Administration Training​ Course Outline

The outline is focused on providing complete knowledge of Oracle Database within modern version 18c. Our professionals have arranged the following modules to provide an understanding from the introduction level to the administrative level. Let’s start from:

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

  • Oracle Database Cloud Service Architecture
  • Understand Features and Tooling
  • Automated Database Overview

Module 3: Oracle Database Access

  • Introductions to SQL*Plus
  • SQL Developer
  • Database Configuration Assistant (DBCA)
  • Oracle Enterprise Manager Database Express
  • Oracle Enterprise Manager Cloud Control
  • Oracle Database Cloud Service Tools

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
  • Connecting to an Oracle Database Instance
  • Naming Methods
  • Oracle Net Services Administration Tools
  • Configuring Communication Between Database Instances
  • 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

  • Methods and Tools to Create PDBs
  • 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
  • Implementing Oracle Managed Files
  • Moving and Renaming Online Data Files
  • Tablespace Encryption by Default in DBCS

Module 10: Managing Storage Space

  • Oracle Database Space Management Features
  • Block Space Management
  • Types of Segments
  • Deferred Segment Creation
  • Space-Saving Features
  • 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
  • Point-in-time Recovery
  • Flashback Technology

Module 13: Configure Backup and Recovery

  • Configuring and 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)
  • RMAN Backup Types
  • Automatic Backups on Database Cloud Service (DBCS)
  • On-Demand Backups on 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
  • Performance Tuning Methodology
  • Managing Memory Components

Modules 16: SQL Tuning Overview

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

Show moredown

Prerequisites

It would be great if delegates will have a basic knowledge of SQL and PL/SQL packages.

Audience

This course is designed for various IT roles such as:

  • Database Administrators
  • Database Designers
  • Support Engineer
  • Technical Administrator
  • Data Warehouse Administrator 

Oracle Database 18c Administration Training​ Course Overview

Oracle Database 18c is the modern version of the accessible database. Oracle Database 18c can be deployed on on-premises and cloud-based platform. This database technologies are very fast, most scalable and reliable for the secure deployment of analytical and transactional workloads in the cloud as well as on-premises and Hybrid Cloud Configurations. In database technology, Oracle Database 18c debut with new functionality and enhancements to features such as multitenant architecture, in-memory column store, native database sharding and critical capabilities previously introduced in Oracle 12c.

This 3-days course will teach how to manage an Oracle Database instance. Delegates will get a complete administration knowledge of the Oracle Database new version 18c. They will learn about how to configure the Oracle Network environments, create and manage storage structures. Along with this, delegates will gain an understanding of how to create and manage database cloud service deployments as well as will how to create users and administer database security to meet organisation requirements.

During this course, delegates will gain a comprehensive knowledge of how to create a database storage structure appropriate for the organisation applications supported by the created database. This course will provide necessary information on backup and recovery techniques. On course completion, delegates will be able to create and manage Database Cloud Service deployments and configure the database to support an application as well as manage the database security and implement auditing.

Show moredown

  • Delegate pack consisting of course notes and exercises
  • Manual
  • Experienced Instructor

Show moredown

Online Instructor-led (3 days)

Online Self-paced (24 hours)

Oracle Reports Training Course Outline

Module 1: Introduction to Oracle Reports Developer

  • Overview of Oracle Reports Developer
  • Oracle Reports Developer Basic Concepts
  • Paper and Web Reports
  • Key Features and Benefits
  • Oracle Application Server Reports Services
  • Designing Reports
  • Available Reports Styles

Module 2: Creating a Basic Tabular Paper Report

  • Invoke the Reports Builder
  • Use the Object Navigator
  • Designing a Report to Retrieve Data Efficiently
  • Use the Report Wizard to Build a Report
  • Use Query Builder to Create the Query
  • Apply an Appropriate Template
  • Reports Property Palette
  • Modify the Layout Model
  • Save the Report in an Appropriate Format
  • Exercise: Create Various Tabular Reports

Module 3: Create a Web Report

  • Use Java Server Page Technology to Build a Web Report
  • Testing a Report on the Web
  • Web Technology in Oracle Reports
  • Create a Web Report Using the Report Wizard
  • Examine the Source Code Using the Web Source View
  • Make Basic Enhancements to the Web Source Code
  • Create a Cascading Stylesheet for a Report
  • Preview a Report on the Web
  • Exercises:
    • Create a Web Report
    • Modify the Web Source Code of a Report

Module 4: Managing Report Templates

  • Modify a Predefined Template
  • Create a New Template
  • Configure the Report Builder Preferences
  • Exercise: Create Templates

Module 5: Break Report

  • Concepts of the Break Report
  • Data Model Objects: Report Groups
  • Formula Columns
  • Summary Columns
  • XML Settings
  • Repeating Frames
  • Use the Wizard to Create a Break Report
  • Modify the Data Model
  • Modify Field Properties
  • Customise the Web Source Field Tags
  • Display System Variables
  • Display Report Margins
  • Add Boilerplate Text and Images
  • Embed Report Variables in Boilerplate Text
  • Include Report Variables in the Web Source Code
  • Exercises:
    • Create Various Break Reports
    • Add Formula Columns to a Report
    • Customise the Report with Text, Images and System Data

Module 6: Form Report

  • Design and Create a Form Report
  • Embed Data in Boilerplate Text
  • Flex and Confine Modes
  • Use the Arrange Objects Tools in the Layout
  • Group Operations
  • External Queries
  • Exercise:
    • Create a Form-Style Report and Customise the Layout
    • Use an External Query in the Report

Module 7: Master-Detail Reports

  • Multi-Query Reports
  • Use Data Links in the Layout Model
  • Create a Master/Detail Report
  • Control the Pagination of Layout Objects
  • Use the Report Block Tool for a Customised Layout
  • Use the Report Block Tool in a Web Report
  • Exercise:
    • Create a Report Using Multiple Queries
    • Add an Additional Layout to a Report

Module 8: Layout Model Objects

  • Frames
  • Fields
  • Boilerplate
  • Anchors
  • Images
  • Sections
  • Displaying a File in a Column
  • Exercises:
    • Display a File in a Form-Style Report
    • Add a New Section to a Report

Module 9: Letters and Mailing Labels

  • The Mailing Label Report Style
  • The Form-Letter Report Style
  • Exercise:
    • Create Report Consisting of a Letter with Mailing
    • Labels to the Recipients

Module 10: Matrix Reports

  • Introduction to Matrix Reports
  • The Matrix Data Model
  • To Create a Single Query Matrix Report
  • Matrix Summaries
  • Multi-Level and Break Matrices
  • Child Dimension in Matrix Reports
  • Exercise: Create Various Matrix Reports

Module 11: Parameters

  • System Parameters in Reports
  • Using Bind Parameters in Reports
  • The Use of Lexical Parameters
  • Lists of Parameter Values
  • The Parameter Form Screen
  • Creating Parameter HTML Extensions
  • Exercise: Create Reports with Bind and Lexical Parameters

Module 12: PL/SQL and Triggers in Reports

  • PL/SQL in Oracle Reports
  • Report Level Triggers
  • Group Filters
  • Use Parameters and Placeholders in a Report
  • External and Internal PL/SQL Procedures
  • PL/SQL in Oracle Reports Builder
  • Create, Attach and Use PL/SQL Libraries
  • Oracle Reports PL/SQL Packages
  • Report Level PL/SQL
  • Creating Reports Using Ref Cursor Queries
  • Enhance the Web Source Code with Triggers
  • Use JSP in the Web Source Code Instead of Triggers
  • The SRW Package
  • Create Dynamic Web Links Using PL/SQL Functions
  • Exercises:
    • Add Triggers to Existing Reports
    • Create a Report with a ref Cursor Query

Module 13: Report Distribution

  • Report Distribution and Distribution Files
  • Distribute Paper Report Sections
  • Burst a Paper Report to Multiple Destinations
  • Exercises: Burst a Report to Multiple Destinations

Module 14: Web Reporting

  • Build Reports for the Web
  • Use JSP in Oracle Reports
  • HTML and PDF in Reports Builder
  • Web Links for HTML Output
  • Style Sheets
  • Add a Bookmark to a Paper Report
  • Add a Hyperlink to a Paper Report
  • Add Dynamic Content to a Web Page
  • Create an HTML File from a report
  • Create a delimited File from a report
  • Add Report Data to an HTML File
  • Prepare a Paper-Based Report for the Web
  • Add Web Links to Paper-Based Reports
  • HTML Special Characters
  • Exercises:
    • Create Report Output in Different Formats
    • Add a Dynamic Hyperlink to a Report

Module 15: XML and Pluggable Data Sources

  • Storing Reports as XML files
  • Generating XML Output from a Report
  • Reports Based on an XML Pluggable Data Source
  • Reports Based on Text Pluggable Data Source
  • Exercises: Create Reports Based on XML and Text Pluggable Data Sources

Module 16: Using Graphics in a Report

  • Oracle Graphics Objects
  • Create and Embed a Graph Using the Graph Wizard
  • Add a Graph to a Web Report
  • Customise a Graph in a Report
  • Exercises:
    • Create and Embed a Graph in a Report
    • Exercise: Add the Graph to the Web Report

Module 17: Using Oracle Application Server Reports Services

  • Report Request Methods
  • Oracle Application Server Reports Services
  • Architecture Report Request Methods
  • JSP Runtime Architecture
  • Servlet Runtime Architecture
  • Viewing and Scheduling Reports
  • Monitoring and Managing Reports Services
  • Exercise: Create a Web Page to Run Reports

Module 18: Performance Issues

  • Designing Efficient Reports
  • Monitor the Performance of Reports
  • Investigate Performance Issues
  • Exercise: Use Report Monitoring Tools
  • Conclusion
  • Appendices:
    • Supported File Types
    • Reports Executables
    • JSP Tags Used in Web Reports
  • The SRW Packaged Procedures

Show moredown

Prerequisites

There are no formal prerequisites for this course.

Audience

This course is for IT Professionals and Accounts Manager who wants to learn about Oracle Technologies.

Oracle Reports Training​ Course Overview

This Oracle Reports Training course will introduce delegates to the main concepts of Oracle Reports Developer. Delegates will gain an understanding of how to design and create web and paper reports using Oracle Report wizard. Delegates will gain a thorough understanding of how to add dynamic report data to static HTML pages and publish reports on the web.

This 3-day course will equip delegates with the knowledge of how to create paper and web reports. In this course, delegates will learn how to build reports in various different formats. They will acquire knowledge of how to edit and manipulate boilerplate and layout objects. This course explains how to edit and enhance the web source code and use cascading stylesheets in web reports. Delegates will learn how to build master-detail and matrix reports. In addition, they will learn how to build and use report templates.

During this course, delegates will gain an understanding of using PL/SQL to base reports on ref cursor queries and PL/SQL trigger code to validate and format reports. They will also learn how to add dynamics web link to report and how to use XML and text pluggable data sources in reports. This course provides delegates with the knowledge of using parameters in reports, adding graphics to a report, distributing and bursting reports. They will also acquire knowledge of tuning reports, maximising report performance using Oracle AS reports services, publishing reports on the web, and adding dynamics to an HTML page.

Show moredown

  • Delegate pack consisting of course notes and exercises
  • Manual
  • Experienced Instructor

Show moredown

Online Instructor-led (1 days)

Online Self-paced (8 hours)

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
  • The Exists Operator
  • The WITH Clause
  • Multi-Column Subqueries
  • Insert and Update Using a Query
  • Correlated Update and Delete

Module 3: Hierarchical Queries

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

Module 4: Enhanced Grouping Features

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

Module 5: Analytic Queries

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

Module 6: Manage Large Data Sets

  • Multi-Table Inserts
  • Conditional and Unconditional Inserts
  • Merging Data into a Table
  • Table and View-Based Merge
  • A Sub Query Based Merge

Show moredown

Prerequisites

There are no prerequisites for this course.

Audience

This course is for IT Professionals and Database Administrators who want to learn about databases and Oracle Technologies.

Oracle SQL Advanced Training​ Course Overview

Structured Query Language is a set of statements with all programs and users access data in an Oracle database. The Advanced Oracle SQL training course, build upon the prior knowledge and understanding of Oracle SQL, as taught in the Introduction to SQL on Oracle. This course teaches delegates how to retrieve data using multi-column subqueries, correlated subqueries, and in-line views. They will also acquire knowledge of inserting and updating rows using complex subqueries.

During this 1-day course, delegates will learn how to create analytic and hierarchical queries. Along with this, they will learn about ROLLUP, CUBE, and GROUPING SETS, group. Delegates will acquire knowledge of how to implement GROUPING and GROUPING_ID function. Delegates will get an understanding of how to insert data conditionally and unconditionally, manage large data sets, and merge rows in a table.

This course explains how to manage objects with the data dictionary and manage schema objects. Delegates will also acquire knowledge of how to create and use external tables, perform flashback operation, and control user access to database objects.

Show moredown

  • Delegate pack consisting of course notes and exercises
  • Manual
  • Experienced Instructor

Show moredown

Online Instructor-led (2 days)

Online Self-paced (16 hours)

Oracle Program Training with PL/SQL Course Outline

This outline is designed with a primary focus on providing complete knowledge of how to program with PL/SQL. The following modules are arranged by our IT professionals to provide quality knowledge. The course will provide an understanding of PL/SQL from initial to advance level.

Module 1: PL/ SQL and Its Components

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

Module 2: Program Logic Essentials

  • Statements for Program
    • IF THEN ELSE
    • GOTO
    • CONTINUE
    • CASE
  • Loops for Program
    • Loop Construct Overview
    • WHILE and FOR
    • Nested and Labelled

Module 3: Cursors in PL/SQL Overview

  • Introduction to Cursor
  • Implicit and Explicit Cursors
  • Cursor Operations
  • Declaring, Opening and Closing Cursors
  • Fetching Rows
  • Status Checking
  • Cursor FOR UPDATE
  • Cursor FOR Loop
  • Parameterised Cursor

Module 4: EXCEPTIONS and NESTED Blocks

  • EXCEPTION Section Overview
  • Types of Exception
  • Named and Unnamed System-Raised Exceptions
  • User-Declared Exceptions and Application Errors
  • Nested and Labelled Blocks
  • Propagation of Exceptions
  • Scope of Variables and Cursors

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

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

Module 6: Triggers Overview

  • Introduction to Triggers
  • DML Triggers
  • CREATE TRIGGER Statement
  • Writing Trigger Code
  • INSTEAD OF Triggers
  • Calling Procedures from Triggers
  • Coding Restrictions
  • System Event and DDL Triggers
  • Attribute Functions
  • Compound Triggers
  • Create Trigger Follows Clause
  • Managing Triggers
  • Privileges required for Triggers
  • Dictionary Information Concerning Triggers

Module 7: Procedures Overview

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

Module 8: Functions Overview

  • Introduction to Functions
  • CREATE FUNCTION Statement
  • Executing Functions
  • Invoker’s Rights
  • Autonomous Transactions
  • DBMS_OUTPUT
  • Functions in SQL Statements
  • Deterministic and Parallel-Enabled Functions
  • Function Result Cache
  • Managing Functions
  • Privileges Required for Functions
  • Dictionary Information Concerning Functions

Module 9: Packages Overview

  • Introduction to Packages
  • Public and Private Components
  • Creating a Package
  • Persistent States
  • Overloading
  • Understand Purity Level Checking
  • Forward Declarations
  • Wrapping Packages
  • Managing Packages
  • Privileges Required for Packages
  • Functions Features

Module 10: PL/SQL Records and Tables in Packages

  • PL/SQL Records, Index-by Tables and Associated Arrays
  • PL/SQL Records and Tables in Packages Overview
  • Table Built-in functions
  • NOCOPY Hint
  • Bulk Collection
  • Bulk Binding DML Statements

Module 11: Cursor Variables Overview

  • Declare Cursor Variables
  • Use Cursor Variables
  • Open and Close Cursor Variables
  • Fetch Rows Overview
  • Cursor Variable Attributes
  • Pass Cursor Variables as Parameters
  • Open and Close Cursor Variables
  • Refcursor Datatype

Module 12: Managing Dependencies

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

Module 13: Native Compilation and Compile-Time Warnings

  • Introduction of Native Compilation and Compile-Time Warnings
  • Native Compilation
  • Automatic Recompilation
  • 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

Show moredown

Prerequisites

Delegates should have a basic knowledge of Oracle SQL to attend this course.

Audience

This course is designed for everyone who wants to be an administrator in the Database. This course is ideal for:

  • Database Administrator
  • Database Developer

Oracle Program Training with PL/SQL Course Overview

PL/SQL provides procedural capabilities such as conditions checking, branching and looping. Oracle programming enables a programmer to control the execution of a program based on some conditions and user inputs. PL/SQL allows data manipulation, collecting a large volume of data, and applying algorithms.

This 2-days course will provide complete knowledge of the Oracle Program with PL/SQL. Delegates will learn about writing and running PL/SQL programs from SQL*Plus or SQL developer. Declaring and using variables and constants are essential topics to be covered in this course. Delegates will learn about using SQL statements within PL/SQL as well as about conditional execution and loop constructs. Delegates will get an understanding of cursor, index – by tables and triggers as well as learn about table built-in function. During this course, delegates will gain an understanding of nested and labelled loops and blocks and bulk binding and bulk collecting techniques.

At this course completion, delegates will be able to write and to run PL/SQL programs from SQL*Plus or SQL Developer as well as be able to do the implementation of this structure.

Show moredown

  • Delegate pack consisting of course notes and exercises
  • Manual
  • Experienced Instructor

Show moredown

Online Instructor-led (1 days)

Online Self-paced (8 hours)

Oracle General Ledger Training Course Outline

This Course Outline is focused on providing complete knowledge of essential components of end user functionality provided in Oracle General Ledger. The following Modules are arranged to provide a understanding of journal processing, inquiries and running reports.

Module 1: Introduction

  • Oracle General Ledger – Keywords and Concepts
  • Transactions
  • Balances
  • Overview of the General Ledger
  • New Features in Release 12
  • Chart of Accounts
  • Accounts and Periods
  • Ledgers and Ledger Sets

Module 2: Accounting Calendars

  • Accounting Periods
  • Accounting Calendars
  • Posting Account Balances
  • Oracle General Ledger Features

Module 3: Account Flex Field Design

  • Key Flex Field Overview
  • Account Code Combinations Review High-Level Invoice Information

Module 4: Navigation

  • Login and Logout of Oracle
  • The Navigator Functions Tab
  • The Navigator Top Ten List
  • The Navigator Documents and Processes Tab
  • Oracle Window Features and Terminology
  • Oracle Form Features and Terminology
  • Flex fields
  • Icons
  • Enter and Find Data
  • Attachments
  • Folders
  • Profile Options
  • Oracle Help

Module 5: General Ledger Inquiries

  • General Ledger Inquiries
  • Funds Available Inquiries
  • Inquiring on Actuals
  • Inquiring on Encumbrances
  • Inquiring on Budgets

Module 6: Journal

  • Create a Manual Journal
  • Create a Statistical Journal
  • Create a Mixed Journal
  • Create a Reverse Journal
  • Generate a Reverse Journal
  • Find and Amend a Journal
  • Post a Journal Batch
  • Create a Fixed Recurring Journal Template
  • Generate a Recurring Journal Template
  • Create a Formula Recurring Journal Template
  • Journal Reconciliation

Module 7: WEB ADI Overview

  • Use the Journal Wizard to Enter and Upload a Journal
  • Use the Budget Wizard to Enter and Upload Budgets
  • Use the Currency Rates Manager to Enter and Upload Exchange Rate Information

Module 8: Journal Reconciliation

  • Set Up Journal Reconciliation
  • Reconcile Journals
  • Run Reconciliation Reports
  • Reversal of Reconciliation Process

Module 9: Month and Year End Process Overview

  • Month and Year End Process Overview
  • Oracle Data Flow Across Ledgers
  • Steps for General Ledger Month and Year End

Module 10: General Ledger User Exercises

  • Run a Trial Balance Summary Report
  • Inquire on Account - Actual Amounts
  • Inquire on Account - Actual v Budget Amounts
  • Inquire on Journals
  • Enter a Journal - (Standard and via Journal Wizard)
  • Post Journals
  • Enter Journal Batches
  • Reverse an Existing Journal
  • Post the Reversal
  • Define Recurring Journals
  • Generate a Recurring Journal
  • Create a Folder Definition
  • Run Standard Reports

Module 11: Reporting Tools Overview

  • Overview
  • Oracle General Ledger Standard Reports
  • Report Categories
  • Financial Statement Generator
  • Oracle Financial Analyser
  • Oracle Discoverer
  • RXi Reports Administration Tool
  • Oracle Reports
  • SQL * Plus Reports
  • Comparison of Reporting Tools

Module 12: Standard General Ledger Reports

  • Concurrent Manager
  • Concurrent Processing Definitions
  • Useful Standard Reports
  • Submit Request Flow
  • Run a Standard General Ledger Report
  • Scheduling and Completion Options
  • View Requests

Module 13: The Financial Statement Generator

  • Introduction to FSG Reporting
  • FSG Components
  • Plan an FSG Report
  • Sets
  • Predefined Row and Column Sets
  • Define Row and Column Sets
  • Generate an Ad Hoc FSG Report
  • Define Row and Column Sets
  • Define an FSG Report
  • Run an FSG Report
  • Use a Content Set

Module 14: Reporting with Report Manager

  • Overview of Report Manager
  • Report Manager Structure and Access
  • Publish a Report to Reports Repository
  • View a Report in Reports Repository
  • Publish a Report from eBusiness Homepage
  • Analyse a Financial Report with Report Manager

Module 15: FSG Exercises

  • Define a Row and Column Set
  • Define an FSG Report
  • Run an FSG Report
  • View Report Requests
  • Define a Content Set
  • Define Display Groups and Display Sets
  • Define a Row Order

Module 16: Report Manager Exercises

  • Publish a Report from a Form Function
  • Analyse Report Output
  • Export Analysis to MS Excel
  • View a Report from Repository Management

Show moredown

Prerequisites

It would be great if a delegate will have General knowledge of accounting functions.

Audience

This course is designed for various professional roles such as System Administrators in finance management and Oracle Technologies learner.

Oracle General Ledger Training​ Course Overview

Oracle General Ledger is a Financial management solution that provides highly automated financial processing, effective management control, and real-time visibility to business results. It gives everything that an organisation need to meet financial compliance.

This course will teach delegates about Oracle General Ledger Concepts and its essentials. Delegates will learn about Navigations, performing Ledger inquiries and funds available surveys, journals and its templates. They will get an understanding of all essential areas of end user functionality provided in Oracle General Ledger. The journal processing, inquiries and running reports are also included in this course. The learner will gain knowledge of Financial Statement Generator as well as Report Manager for Publish, View, analyse reports. Along with this knowledge, the Course will provide the advance fundamentals concepts to get a complete understanding

At this course completion, Delegates will be able to process manual journals, to carry out inquires as well as define and run FSG reports and use report Manager to publish and interrogate them.

Show moredown

  • Delegate pack consisting of course notes and exercises
  • Manual
  • Experienced Instructor

Show moredown

Online Instructor-led (3 days)

Online Self-paced (24 hours)

Create Analyses and Dashboards with Oracle BI​ Course Outline

Module 1: Working with Oracle Business Intelligence Analyses

  • Introduction to Oracle BI Analysis Editor
  • Oracle BI Column Types
  • Working with Analyses in Oracle BI
  • Adding Basic Formatting
  • Setting Analysis Properties
  • Using Advanced Formatting

Module 2: Filtering Data for Analyses

  • Introduction to Filters and Selections
  • Creating, Editing, and Grouping Filters
  • Adding Prompts to Analyses
  • Dynamic Filtering
  • Using Saved Analyses as Filters

Module 3: Selecting and Grouping Data for Analysis

  • Creating Selection Steps
  • Creating Groups
  • Creating Calculated Items
  • Creating Direct Database Analysis Requests
  • Including Advanced SQL Clauses in your Analysis

Module 4: Advance Visualisation in Analysis

  • Introduction to Views, Graphs, and Editors
  • Working with Views in Compound Layouts
  • Creating and Editing Graphs
  • Performing Common View Tasks

Module 5: Showing Results with Pivot Tables

  • Creating, Arranging, and Formatting a Pivot Table
  • Using Hierarchical Columns
  • Sorting in Pivot Tables
  • Setting Aggregation and Using Totals
  • Showing an Item's Relative Value
  • Building Calculations and Displaying Running Sums

Module 6: Working with Additional Views in Analyses

  • Creating Simple and Advanced Trellis Views
  • Creating Performance Tile Views
  • Working Other View Types like TreeMap and Heat Matrix
  • Linking Master-Detail Views

Module 7: Visualising Data on Maps

  • Oracle Spatial Components
  • Managing Map Data
  • Creating and Editing Map Views
  • Interacting with Map Views
  • Other Applications and Points of Integration for Map Views

Module 8: Creating Oracle Business Intelligence Dashboards

  • Creating and Editing Dashboards
  • Using the Dashboard Builder
  • Exploring Dashboard Object Properties and Options
  • Publishing Dashboard Pages
  • Creating Personal Customisations and Using Other Page Options

Module 9: Configuring Oracle Business Intelligence Dashboards

  • Exploring Types of Dashboard Content
  • Embedding Content in Dashboards

Module 10: Creating Dashboard Prompts and Variables

  • Understanding Variables
  • Adding a Named Dashboard Prompt to a Dashboard
  • Adding a Hidden Named Dashboard Prompt to a Dashboard
  • Creating Additional Prompt Page and Setting Page Preferences
  • Adding Variable Prompts to a Dashboard

Module 11: Scorecards and Key Performance Indicators

  • Objects and Components of Oracle Scorecard and Strategy Management
  • Key Performance Indicator (KPI) Overview
  • Scorecard Document Types
  • Creating Scorecards and KPIs
  • Creating Scorecard Documents
  • Editing Scorecards and KPIs

Module 12: Visual Analyser, BI Ask, and Data Mashup

  • Creating Visual Analyser Projects
  • Adding and Rearranging the Visualisations
  • BI Ask
  • Data Mashups

Module 13: Working with BI Content in Smart View

  • Working with Views in Smart View Clients
  • Customising BI Data in MS Office
  • Copying and Pasting Views between Smart View Clients
  • Inserting BI Views into Smart View Clients
  • Creating and Publishing Views Using the View Designer
  • Federating Data from Multiple Data Sources

Module 14: Oracle Business Intelligence Mobile

  • Downloading and using the Oracle BI Mobile Application
  • Navigating the Oracle BI Mobile Application
  • Working with Favourites and Local Content
  • Working with BI Content
  • Oracle BI Mobile Security Toolkit

Module 15: Using Oracle Business Intelligence Delivers

  • Configuring Delivery Devices and Adding Delivery Profiles
  • Adding an Alert Section to a Dashboard
  • Configuring an Agent
  • Using Analysis and KPI Conditions to Deliver Content with Agents
  • Subscribing to an Agent

Module 16: Administering the Presentation Catalog

  • Oracle BI and Catalog Security Overview
  • Managing Security using Roles
  • Understanding Security Inheritance
  • Setting Object Permissions
  • Setting System Privileges
  • Archiving Catalog Items
  • Working with Oracle BI Briefing Books

Module 17: Direct Database Analysis

  • Direct Database Analysis Overview
  • Changing Direct Database Analysis Privileges
  • Creating and Executing a Direct Database Analysis

Module 18: Expressions

  • SQL Syntax and Semantics
  • Running Aggregate Functions
  • Advance Analytics Internal and External Logical SQL Functions

Show moredown

Prerequisites

There are no prerequisites for this course.

Audience

This course is for IT Professionals and database administrators who want to learn about databases and Oracle Technologies.

Create Analyses and Dashboards with Oracle BI​ Course Overview

This course gives knowledge of how to create Oracle BI analyses and dashboards in business intelligence applications. This course describes how to build and use views and graphs in analyses. In this course, delegates will gain an understanding of how to create and work with KPIs and scorecards. They will also learn how to create and modify Oracle BI dashboards. This course explains how to create mobile applications with Oracle Business Intelligence Mobile app designer and add geographical mapping to analyses. Delegates will learn how to use key performance indicators and scorecards to analyse trends and meet business objectives. They will acquire knowledge of how to integrate BI content into MS office application using Oracle Hyperion smart view for office.

This course teaches delegates how to create and modify interactive dashboards and create guided navigation links within interactive dashboards. This course also describes how to use delivers to configure agents to get the results of analyses and deliver them to subscribers. In this course, delegates will learn how to create and modify Oracle business intelligence analyses using analysis editor. They will also gain an understanding of administer analyses and other Oracle BI objects. At the end of this course, delegates will learn how to create and execute a direct database analysis. They will also learn about SQL syntax and semantics, run aggregate function, advanced analytics internal and external logical SQL function.

Show moredown

  • Delegate pack consisting of course notes and exercises
  • Manual
  • Experienced Instructor

Show moredown

Online Instructor-led (3 days)

Online Self-paced (24 hours)

Oracle Database Security Administration Training Course Outline

The following modules focus on providing an understanding of Oracle Database Security at the administrator level. Delegates will learn about data security essential components with the explanation of data security configuration strategies. Along with this, the modules will deliver the familiarity with the security encryptions concepts and solutions. Let's start from the first module to secure the database.

Module 1: Security Requirements Overview

  • Introduced Data Security Requirements 
  • Security Risks and Exploits Overview
  • Techniques to Enforce Security

Module 2: Security Solutions Overview

  • Network and Database Access Control
  • Data Access Control
  • Data Confidentiality
  • Data Integrity
  • Audit
  • Compliance

Module 3: Implement Database Security

  • Database Security Checklist
  • Reducing Administrative Effort
  • Principle of Least Privilege
  • Objects Protection

Module 4: User Authentications Overview

  • Basic Authentication
  • Strong Authentication
  • Database Link Passwords Protection

Module 5: Proxy Authentication Overview

  • Security Challenges of Three-Tier Computing
  • Proxy Authentication Solutions

Module 6: Privilege and Roles

  • Separation of Duties
  • Roles Management
  • Managing Security for Definer's Rights and Invoker's Rights
  • Managing RMAN Virtual Private Catalogs
  • Understand Privilege Analysis Flow
  • Privilege Analysis Implementation

Module 7: Application Contexts Overview

  • Introduction of Application Context
  • Application Context Implementation

Module 8: Virtual Private Database Overview

  • Fine-Grained Access Control and VPD
  • Policies Management
    • Fine-Grained Access Control (FGAC)
    • Virtual Private Database (VPD)

Module 9: Oracle Label Security

  • Access Control Overview
  • Oracle Label Security Registration
  • Oracle Label Security Policies Management

Module 10: Oracle Data Masking and Redacting Data

  • Introduction of Oracle Data Masking
  • Data Masking Definition Implementation
  • Data Masking Process Overview
  • Redacting Data
  • Masking Policies

Module 11: Data Encryption Concepts and Solutions

  • Concepts of Encryption
  • Encryption Solutions Overview
  • Oracle Solutions
  • Master Keys and the Keystore

Module 12: Oracle Audit Vault Overview

  • Introduction of Oracle Audit Vault
  • Architecture and Components
  • Audit Vault Users
  • Database Vault
  • Data Warehouse
  • Registering Sources and Deploying Collectors
  • Oracle Database Collectors Overview
  • Oracle Source Database Overview
  • Creating the Source User in the Source Database

Module 13: Managing Audit Settings

  • Using Audit Vault Overview
  • Introduction to Oracle Database Auditing

Module 14: Oracle Database Firewall

  • Understanding How Data is Compromised
  • Oracle’s Defense in Depth Security Approach
  • Oracle Database Security Solutions
  • Oracle Database Firewall
  • Positive and Negative Security Model-Based Enforcement
  • Oracle Database Firewall Architecture
  • Protected Databases

Module 15: Policies for Oracle Database Firewall

  • Oracle Database Firewall Policy Enforcement
  • Policy Engine Flow
  • Configuring Policies
  • Oracle Database Firewall Preconfigured Policies
  • Creating Policy Files
  • Custom Policy Development Overview
  • Enabling the Firewall Analyser to Understand Database Usage
  • Creating a Policy

Show moredown

Prerequisites

It would be great if delegates will have a basic knowledge of Oracle SQL and PL/SQL.

Audience

This course is designed for various roles such as:

  • DBA Administrator
  • System Administrator
  • Oracle Database Technologies Learners

Oracle Database Security Administration Training​ Course Overview

Oracle Database Security is the essential term to secure and maintain the Oracle SQL and PL/SQL Database for Organisations. For Database security, Oracle provides various essential components such as Oracle audit Vault, Database Firewall, Policies, Proxy Authentication, Privileges, Encryption of Database and Roles and Oracle Label Security.

In this 3-day course, delegates will learn how to secure database at the administrative level. They will understand the security requirements and security solutions accordingly. The securing data on the network is also included in this course. Delegates will learn how to manage access control, create virtual private databases and configure audit vaults. This course introduces delegates to oracle database control features to fully support and allow organisational-wide database security. In addition, delegates will get a better understanding of how to implement virtual private database as well as they will learn about Oracle Label Security, Oracle Data Masking, encryption concepts and solutions, Oracle Database Firewall and configuring policies to secure a database. This course will cover the Oracle Audit Vault within its features, architecture and components as well as they will acquire skills of managing audit settings. 

On course completion, delegates will be able to secure the database by Oracle components and features as well as configure and manage security features such as access control, virtual private databases, audit vaults, and database firewall.

Show moredown

  • Delegate pack consisting of course notes and exercises
  • Manual
  • Experienced Instructor

Show moredown

Online Instructor-led (1 days)

Online Self-paced (8 hours)

Oracle Purchasing Training​ Course Outline

The course outline is focused on providing complete knowledge of Oracle Purchasing (PO). These well-arranged modules will teach delegates about purchase order processing and purchasing accounting order.

Module 1: Oracle Purchasing Overview

  • Overview of Oracle Purchasing
  • Matching Options
  • Integration with Oracle Payables

Module 2: Supplier Management

  • Supplier Overview
  • Supplier Relationships
  • Contracts
  • Solicitations
  • Supplier Sites
  • Supplier Account Balances
  • Inquire on a Supplier
  • Add a Supplier
  • Amend an Existing Supplier
  • Merge Supplier/Supplier Sites
  • Add an Attachment to a Supplier Record
  • Create an Approved Suppliers List

Module 3: Item Attributes and Set-Up

  • Define Master Items
  • Assign a Master Item to an Organisation
  • Update Parameters Specific to an Organisation
  • Copy-Item Attributes From a Template
  • Create a Template
  • Set Attribute Controls

Module 4: RFQ and Quotation

  • Add or Amend an Existing Supplier List
  • Create a New Supplier List
  • Create a New RFQ
  • Select the Suppliers who will Receive the RFQ
  • Print the RFQ
  • Create an RFQ from a Requisition
  • Enter a Quotation

Module 5: Approved Suppliers and Sourcing Rules

  • Create Source Documents
  • Set Up Sourcing Rules
  • Assign the Sourcing Rules to an Item
  • Test the Sourcing Set Up
  • Create an Approved Supplier List
  • Test Autosourcing Set Up

Module 6: Purchase Requisitioning Processing

  • Overview of Requisitioning
  • The Requisition Form
  • Overview of Approvals
  • Create a Requisition
  • Create a Requisition Using Preferences
  • Create a Foreign Currency Goods and Services Requisition
  • Add an Attachment to a Requisition
  • Review a Requisition
  • Approve/Reject a Requisition
  • View Action/Approval History
  • Cancel a Requisition
  • Requisition Templates
  • Supplier Item Catalog

Module 7: Purchase Order Processing

  • Create a Standard Goods Purchase Order
  • Create a Standard Purchase Order Using Preferences
  • Create a Blanket Purchase Agreement
  • Create a Blanket Release
  • Autocreate a Standard Goods Purchase Order
  • Add an Attachment to a Purchase Order
  • Approve/Reject a Purchase Order
  • Review, Amend, and Copy a Purchase Order
  • Close/Cancel a Purchase Order
  • Freeze a Purchase Order
  • Other Control Actions
  • Print a Purchase Order
  • Purchase Orders and Projects
  • Workflow Document Creation

Module 8: Purchase Order Receipt Processing

  • Overview of the Receiving Process
  • Exceptions
  • Receipt Routing
  • Receipt Processing Methods
  • Payment on Receipt
  • Correct a Receipt
  • Return Goods to a Supplier
  • Find and Review Receipts
  • Receiving Tolerances

Module 9: Integration with Other Concepts

  • Integration with Payables
  • Integration with Inventory

Module 10: Enterprise Structure Overview

  • Organisations
  • Defining Locations
  • Units of Measure
  • Item Categories

Module 11: Raising iProcurement Requisitions

  • Shopping by Store
  • Shopping to Category
  • Checkout Process

Module 12: Receipting a PO in iProcurement

  • Express Receive
  • Standard Receipting
  • Returning Ordered Items
  • Receipt Corrections
  • View Receipts

Module 13: Non-Catalog Requests

  • Requisition Information
  • Review Approver List
  • Review and Submit

Module 14: Purchasing Set Up Overview

  • Purchasing Profile Options
  • Purchase Order Matching and Tax Tolerances
  • Purchasing Document Security, Routing and Approval
  • Approval Assignments and Approval Groups
  • Purchasing and Receiving Options

Module 15: Purchasing Management

  • Accruals
  • Encumbrance Accounting
  • Generate Uninvoiced Receipt Accruals
  • Close a Purchasing Period

Show moredown

Prerequisites

It would be great if delegates have a basic knowledge of the procurement process and Oracle navigation.

Audience

This course is designed for users and various professional roles to facilitate to finance departments and account managers.

Oracle Purchasing Training​ Course Overview

Oracle Purchasing (PO) is the application for professional buyers that streamlines purchase order processing while strengthening policy compliance. It is an essential component of Oracle advanced procurement. It takes central control of all suppliers and item master information with an application that tightly integrates suppliers into an organisation by leveraging advanced supply management capabilities.

In this course, delegates will get a complete understanding of Oracle purchasing (PO) and its essential components. They will learn how to manage suppliers as well as define and create an item in this Oracle purchasing. From this course, delegates will acquire knowledge of orders and receipts, process requisitions, make enquiries and run reports in both purchasing and procurement, as well as understand the approvals process. Furthermore, delegates will get an understanding of the fundamental elements of setting up and how they affect the system’s operation.

On course completion, delegates will be able to understand Oracle purchasing and procurement to manage the procurement process.

Show moredown

  • Delegate pack consisting of course notes and exercises
  • Manual
  • Experienced Instructor

Show moredown

Online Instructor-led (1 days)

Online Self-paced (8 hours)

Oracle BI Applications for E-Business OBIA Training Course Outline

This course outline is focused on providing complete knowledge of Oracle BI applications for E-Business. Delegates will learn about Oracle Business Applications Warehouse (OBAW) as well as its foundation concepts and architecture. They will learn how to install and configure Oracle BI applications as well as learn about customising Oracle DAC metadata. The following is the brief synopsis of topics to be covered in this course:

  • Oracle Business Intelligence Applications Architecture Overview
  • Installing and Configuring Oracle BI Applications and Related Components
  • Exploring SDE and SIL Mappings
  • Working with the Data Warehouse Administration Console
  • Customising DAC Metadata and Running and Execution Plan
  • Customising the Oracle Business Analytics Warehouse
  • Adding Columns to an Existing Dimension Table
  • Adding a New Dimension in OBAW
  • Managing OBAW Performance

Show moredown

Prerequisites

It would be great if delegates have knowledge about DB modeling and design, SQL and BI.

Audience

This course is designed for various professionals’ roles such as;

  • Administrator
  • Analyst and Architect
  • Developer and Implementer
  • Oracle Technologies Learner

Oracle BI Applications for E-Business OBIA Training ​Course Overview

Oracle Business Intelligence Applications are pre-built-in BI solution that is intuitive intelligence for everyone in the organisation. OBIEE is the platform, and Oracle BI applications are designed and build a data warehouse, metadata repository. Oracle BI Application provide the Packaged set of schemas, ETL Routines and Prebuilt reports and dashboards.

In this course, delegates will get a complete understanding of Oracle Business components and architecture. They will learn how to install, support, extend and fully manage the enterprise functionality of Oracle Business Intelligence Applications. This course will help to understand the ETL process and the relationship between the architecture components. Delegates will learn about Oracle E-Business Suite for Oracle Business Analytics Warehouse (OBAW) to load data. Along with this, delegates will learn about technique customisations for dimension table and adding a new dimension.

At this course completion, delegates will be able to plan to implement Oracle business Intelligent Applications (OBIA).

Show moredown

  • Delegate pack consisting of course notes and exercises
  • Manual
  • Experienced Instructor

Show moredown

Online Instructor-led (3 days)

Online Self-paced (24 hours)

Oracle 18c DBA Fundamentals​ Course Outline

Module 1: Oracle Database Architecture 

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

Module 2: Introduction to Oracle Database Cloud

  • Oracle Database Cloud Service Architecture
  • Features and Tooling
  • Automated Database Provisioning

Module 3: Creating Oracle Database Cloud Service (DBCS) Deployments 

  • Input to the Creation Wizard
  • SSH Key Pairs
  • Database File Storage

Module 4: Accessing an Oracle Database 

  • SQL*Plus
  • SQL Developer
  • Database Configuration Assistant (DBCA)
  • Oracle Enterprise Manager Database Express
  • Oracle Enterprise Manager Cloud Control
  • Oracle Database Cloud Service Tools

Module 5: Managing DBCS Database Deployments 

  • Managing the Compute Node
  • Managing Network Access to DBCS
  • Scaling a Database Deployment
  • Patching a Database Deployment

Module 6: Managing Database Instances 

  • Initialization 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 7: Oracle Net Services

  • Oracle Net Listener Overview
  • Connecting to an Oracle Database Instance
  • Naming Methods
  • Oracle Net Services Administration Tools
  • Configuring Communication Between Database Instances
  • Comparing Dedicated and Shared Server Configurations

Module 8: Administering User Security

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

Module 9: Creating PDBs

  • Methods and Tools to Create PDBs
  • Creating PDBs from Seed
  • Cloning PDBs
  • Unplugging and Plugging in PDBs
  • Dropping PDBs

Module 10: Creating Master Encryption Keys for PDBs

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

Module 11: Creating and Managing Tablespaces

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

Module 12: Managing Storage Space

  • Oracle Database Space Management Features
  • Block Space Management
  • Types of Segments
  • Deferred Segment Creation
  • Space-Saving Features
  • Table and Row Compression
  • Shrinkable Segments
  • Resumable Space Allocation

Module 13: Managing Undo Data

  • 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

Module 14: Moving Data

  • Oracle Data Pump
  • SQL*Loader
  • External Tables
  • Migrating to Oracle Database Cloud Service

Module 15: Backup and Recovery Concepts

  • Categories of Failure
  • Instance Recovery
  • Complete Recovery
  • Point-in-time Recovery
  • Flashback Technology

Module 16: Backup and Recovery Configuration

  • Configuring and Monitoring the Fast Recovery Area
  • Multiplexing Control Files
  • Multiplexing Redo Log Files
  • Archive Redo Log Files
  • Configuring ARCHIVELOG Mode

Module 17: Creating Database Backups

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

Module 18: Performing Database Recovery

  • Database Recovery Advisor
  • Recovering Data Files in NOARCHELOG Mode
  • Recovering Data Files in ARCHIVELOG Mode
  • Recovery Options in Database Cloud Service (DBCS)

Module 19: Monitoring and Tuning Database Performance

  • 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
  • Performance Tuning Methodology
  • Managing Memory Components

Module 20: SQL Tuning

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

Show moredown

Prerequisites

There are no prerequisites for this course.

Audience

This course is for IT Professionals and Database Administrators who wants to learn about databases and Oracle Technologies.

Oracle 18c DBA Fundamentals​ Course Overview

Oracle 18c describes how to create, configure, and administer an Oracle database. This course gives knowledge on the architecture of an Oracle Database instance and database, enables delegates to manage their database resources effectively. This course describes how to create oracle database cloud service (DBCS) deployments, how to access an oracle database and manage DBCS database deployments. In this course delegates will learn how to manage database instances. They will also learn about oracle net services: oracle net listener, connecting to an oracle database instances, naming methods, oracle net services administration tools, configuring communication between database instances, and comparing dedicated and shared server configurations.

In this 3-day course, delegates will acquire knowledge of how to manage oracle cloud and database users, privileges, and roles. They will also learn about user authentication, creating and assigning profiles. This course describes creating PDBs: methods and tools to create PDBs, creating PDBs from seed, cloning PDBs, unplugging and plugging in PDBs and dropping PDBs. This course teaches delegates how to create master encryption keys for PDBs and Creating and managing table spaces. They will also learn how to manage storage space, manage undo data, and moving data.

This course explains backup and recovery concepts and configuration. Delegates will learn how to configure and monitoring the fast recovery area, multiplexing control files, multiplexing redo log files, archive redo log files, and configure ARCHIVELOG mode. They will also learn about SQL tuning: SQL tuning process, oracle optimiser, optimiser statistics, SQL tuning advisor, SQL access advisor, and SQL performance analyser. 

Show moredown

  • Delegate pack consisting of course notes and exercises
  • Manual
  • Experienced Instructor

Show moredown

Online Instructor-led (3 days)

Online Self-paced (24 hours)

Oracle Database 12c R2 Develop PL/SQL Program Units Course Outline

Module 1: Get Started with Oracle Database 12c R2: Develop Program Units

  • Human Resources (HR) Schema
  • PL/SQL Development Environments
  • Use the SQL Worksheet
  • Execute SQL Statements
  • Work With Script Files
  • Create and Execute Anonymous Blocks

Module 2: Creating Stored Procedures

  • PL/SQL Blocks and Subprograms
  • Describe the Uses and Benefits of Procedures
  • Create, Call, and Remove Procedures
  • Use Formal and Actual Parameters
  • Identify the Available Parameter-Passing Modes
  • Pass Parameters using the Positional, Named, or Combination Techniques
  • Handle Exceptions in Procedures
  • View the Procedure Information

Module 3: Creating Functions and Debugging Subprograms

  • Creating Stored Functions
  • Difference Between Procedures and Functions
  • Developing Functions
  • Creating and Executing and Removing Functions
  • Identifying the Advantages of Using Stored Functions in SQL Statements
  • Using User-Defined Functions in SQL Statements
  • Using a PL/SQL Function in the SQL WITH Clause
  • Restrictions when Calling Functions from SQL Statements

Module 4: Creating Packages

  • Using PL/SQL Packages
  • Components of a PL/SQL Package
  • Visibility of a Package's Components
  • Developing a PL/SQL Package
  • Creating the Package Specification and Package Body
  • Invoking the Package Constructs
  • Creating and Using Bodiless Packages
  • Removing a Package

Module 5: Working with Packages

  • Overloading Subprograms
  • Using Forward Declarations to Solve Illegal Procedure Reference
  • Initialising Packages
  • Using Package Functions in SQL and Restrictions
  • Controlling Side Effects of PL/SQL Subprograms
  • Persistent State of Packages
  • Persistent State of Package Variables and Cursors
  • Using PL/SQL Tables of Records in Packages

Module 6: Using Oracle-Supplied Packages in Application Development

  • Using Oracle-Supplied Packages
  • How Does the DBMS_OUTPUT Package Work?
  • Using the UTL_FILE Package to Interact With Operating System Files
  • Using the UTL_MAIL Package

Module 7: Using Dynamic SQL

  • Execution Flow of SQL
  • Working With Dynamic SQL
  • When Do You Need Dynamic SQL?
  • Using Native Dynamic SQL (NDS)
  • Declaring Cursor Variables
  • Executing a PL/SQL Block Dynamically
  • Using Native Dynamic SQL to Compile PL/SQL Code

Module 8: Design Considerations for PL/SQL Code

  • Standardise Constants with a Constant Package
  • Standardise Exceptions with an Exception Package
  • Write PL/SQL Code that uses Local Subprograms
  • Grant Roles to PL/SQL Packages and Standalone Stored Subprograms
  • Use the NOCOPY Compiler hint to Pass Parameters by Reference
  • Use the PARALLEL ENABLE hint for Optimisation
  • Use the AUTONOMOUS TRANSACTION Pragma to Run Independent Transactions within a Single Transaction
  • Describe the Differences between Invoker Rights and Definer Rights

Module 9: Creating Triggers

  • Different Types of Triggers
  • Database Triggers and Uses
  • Create Database Triggers
  • Database Trigger Firing Rules
  • Remove Database Triggers

Module 10: Creating Compound, DDL, and Event Database Triggers

  • Compound Triggers
  • Mutating Tables
  • Create Triggers on DDL Statements
  • Create Triggers on System Events
  • Display Information about Triggers

Module 11: Using PL/SQL Compiler

  • Using the PL/SQL Compiler using the Initialization Parameters for PL/SQL Compilation
  • Using the PL/SQL Compile Time Warnings
  • Viewing the Current Setting of PLSQL_WARNINGS
  • Viewing the Compiler Warnings: Using SQL Developer, SQL*Plus, or the Data Dictionary Views
  • Guidelines for Using PLSQL_WARNINGS

Module 12: Managing Dependencies

  • Dependent and Referenced Objects
  • Track Procedural Dependencies with Dictionary Views
  • Predict the Effect of Changing a Database Object upon Stored Procedures and Functions
  • Manage Local and Remote Procedural Dependencies

Show moredown

Prerequisites

There are no prerequisites for this course.

Audience

This course is for IT professionals and Database Administrators who wants to learn about databases and Oracle Technologies.

Oracle Database 12c R2 Develop PL/SQL Program Units Course Overview

This Oracle Database: Develop PL/SQL Program Units course teaches delegates basic PL/SQL language skills. They will learn how to develop, execute and manage PL/SQL stored program units including procedures, functions, packages, and database triggers. This course explains how to design and use PL/SQL packages, create overloaded packages subprograms for more flexibility, and utilise Oracle supplied packages in application development.

In this 3-day course, delegates will learn how to design PL/SQL code for predefined data types, local subprograms, additional programs and standardised constant and exceptions. They will also learn how to create triggers to solve business challenges and build and execute SQL statements dynamically. This course describes how to create compound, DDL, and event database triggers and how to manage PL/SQL subprograms and triggers. Delegates will also gain an understanding of how to manage dependencies between PL/SQL subprograms. This course also teaches delegates how to use dynamics SQL.

Show moredown

  • Delegate pack consisting of course notes and exercises
  • Manual
  • Experienced Instructor
  • Refreshments

Show moredown

Online Instructor-led (2 days)

Online Self-paced (16 hours)

Oracle Accounts Payable Training Course Outline

Module 1: Introduction

  • Overview of a Payables System
  • Accounts Payable Invoice Approval Workflow
  • Additional Features of Oracle Payables
  • An Overview of Payables in a Business
  • Integration with Other Modules
  • The Payables Cycle

Module 2: Enter Invoices

  • Invoice Types
  • Invoice Matching
  • Invoice Import
  • Invoice Gateway
  • Enter a Non-Purchase Order Invoice
  • Enter a Standard Purchase Order Invoice
  • Process a Credit Note - Match to a Purchase Order
  • Process a Credit Note - Match to an Invoice
  • Recurring Invoices
  • Applying Prepayments to an Invoice
  • Foreign Currency Invoices
  • Entering Taxes on Invoices
  • Debit memos

Module 3: Inquiry on Invoices

  • Invoice Inquiry Overview
  • Find Invoices
  • Find Invoice Distributions
  • Calculate Supplier Balances
  • Review High-Level Invoice Information

Module 4: Apply and Release Holds

  • Types of Hold
  • Apply a Manual Invoice Hold
  • Release a Manual Invoice Hold

Module 5: Approve Invoices

  • Approval Methods
  • Approve a Non-PO Invoice

Module 6: Adjust or Cancel Invoices

  • Add an Attachment to an Invoice
  • Adjust an Invoice
  • Cancel an Invoice
  • Create and Use a Clearing Payment Type

Module 7: Payment Banks and Payment Processing

  • Payment Workbench
  • Manual and Quick Payments
  • Payment Methods
  • Process a Payment Batch
  • Cancel a Payment Batch
  • Stop / Void a Payment
  • Set Up an Internal Bank Account

Module 8: Supplier Data

  • Supplier Sites
  • Supplier Account Balances
  • Inquire on a Supplier
  • Add a Supplier
  • Amend an Existing Supplier
  • Merge Suppliers / Supplier Sites
  • Add an Attachment to a Supplier Record

Module 9: General Ledger Transfer

  • Accounting Methods
  • Accounting Entries for Payables Transactions
  • Transfer to GL Process

Module 10: Integration with other Modules

  • Integration with Oracle Purchasing
  • Integration with Oracle Assets
  • Integration with Oracle Self-Service Web Applications
  • Integration with Oracle Receivables
  • Integration with Oracle Projects

Module 11: Payables Set Up Overview

  • Define Financials Options
  • Define Payables Options
  • Define Special Calendars
  • Define Purchase Order Matching and Tax Tolerances
  • Define Invoice Hold and Release Names
  • Create Templates for Entering Expense Reports
  • Open Payables Accounting Period

Module 12: Payables Period Close

  • Payables Period End Procedures
  • Run Payables Accounting Process
  • Run the Accounts Payable Trial Balance
  • Control Payables Accounting Period Statuses

Module 13: Withholding Tax

  • Set Up Withholding Tax
  • Process Invoices with Withholding Tax

Module 14: Accounts Payable Exercises

  • Enter New Suppliers
  • Merge Supplier Records
  • Enter Standard Invoices with Multiple Lines
  • Enter Invoices Using PO Default
  • Running Reports
  • Enter a Credit Memo and Match to a Purchase Order Invoice (Part Value of the Invoice)
  • Enter an Advance
  • Invoice Inquiry
  • Match a Credit Note to a Standard Invoice
  • Cancel Invoices
  • Enter an Expense Report and Apply a Prepayment/Advance
  • Apply a Manual Hold Invoice
  • Un-Apply a Prepayment
  • Enter a Discounted Invoice Matched to a Purchase Order

Module 15: Accounts Payable Payments Exercises

  • Payables Payment Run
  • Quick Payment
  • Void a Single Payment
  • Apply a Refund

Show moredown

Prerequisites

There are no formal prerequisites for this course.

Audience

This course is for Account Manager and IT professionals, who want to learn about accounts and Oracle technologies.

Oracle Accounts Payable Training​ Course Overview

The Oracle Account Payable is used to administer payment for services or products while preventing double payment. This course describes the account payable invoice approval workflow. In this course, delegates will learn about the payable cycle, invoices, and inquiry on the invoice. This course explains how to set up suppliers, manage suppliers, entering, reviewing, and approving supplier invoices.

This 2-day course teaches delegates how to adjust or cancel invoices. They will also learn how to match invoices to purchase orders and receipts. Along with this, they will get an understanding of how to enter recurring invoices, processing prepayments, and processing holds and releases. Delegates will learn how to enter and process credit and debit memos. They will also gain an understanding of processing employee expense reports and processing single payment batch processing.

During this course, delegates will get familiarised describes general ledger transfer, closing periods, opening the next period, and running account payable reports.

At the end of this course, delegates will be able to:

  • Use Oracle payables to manage the payables process.
  • Manage suppliers, process invoices, credit notes and payments, submit reports, close accounts payable periods and transfer accounting details to the general ledger.

Show moredown

  • Delegate pack consisting of course notes and exercises
  • Manual
  • Experienced Instructor

Show moredown

Online Instructor-led (2 days)

Online Self-paced (16 hours)

Oracle Asset Management Training​ Course Outline

Module 1: Overview of the Oracle Asset Management Process

  • Overview of Oracle Assets
  • Oracle Assets Setup
  • Assets Key Flexfields
  • Implementing Assets
  • Asset Books and Categories
  • Adding Assets Manually
  • Mass Asset Additions Process
  • Adding and Capitalising a CIP Asset
  • Acquire and Build CIP Assets
  • Asset Adjustments
  • Physical Inventory
  • Depreciation
  • Calculating Depreciation
  • Tracking Asset Retirements
  • Assets Journal Entries
  • Viewing Asset Information On-Line
  • Assets Reporting
  • Creating a Tax Book
  • Entering Information in Tax Books

Module 2: Asset Controls Set Up

  • Oracle Assets Setup Steps
  • Setup Steps Flow
  • Oracle Assets Key Flexfields
  • Setting Up Key Flexfields
  • Asset Category Key Flexfield
  • Location and Asset Key Flexfield
  • Creating Key Flexfield Combinations
  • Specifying System Controls
  • Quick Codes
  • Defining Fiscal Years and Calendars
  • Setting Up Fiscal Years
  • Setting Up Asset Calendars
  • Sharing Calendars
  • Profile Options
  • Maintaining Audit Trails

Module 3: Asset Books

  • Asset Books Positioning
  • Asset Books Regions
  • Calendar Region
  • Accounting Rules Region
  • Natural Accounts Region
  • Security by Book
  • Organisations and Security by Book
  • How Security by Book is used within Process Flow
  • Security by Book Set Up Steps
  • Troubleshooting Security by Book

Module 4: Asset Categories

  • Asset Categories
  • Asset Categories Set Up

Module 5: Manual Asset Additions

  • Adding Assets Manually
  • Asset Additions Required Data
  • Quick Additions
  • Detail Asset Additions
  • Asset Cost Terminology
  • Depreciate Check Box Actions
  • Detail Additions - Assignments and Source Lines Window
  • Manual Asset Additions Journal Entries

Module 6: Mass Asset Additions

  • Mass Asset Additions Process
  • Using the Mass Additions Interface Table
  • Adding Assets from Invoice Distribution Lines
  • The Mass Additions Process
  • Mass Additions Create
  • Requirements to Create Mass Addition Lines
  • Tracking Expensed Items in Oracle Assets
  • Other Mass Additions Considerations
  • Prepare Mass Additions
  • Mass Addition Queues
  • Changing Asset Information
  • Merging and Splitting Mass Addition Lines
  • Adding a Mass Addition to an Existing Asset
  • Accounting for Cost Adjustments Example
  • Post Mass Additions
  • Effect on Post Mass Additions on Queue Names
  • Delete and Purge Mass Additions
  • Future Transactions
  • View Pending Transactions
  • Create Assets using ADI
  • ADI Upload to Oracle Assets
  • Using the ADI Import Text File Option

Module 7: CIP Asset Additions

  • Adding and Capitalising a CIP Asset
  • Acquire and Build CIP Assets
  • Automatically Adding CIP Assets to Tax Books
  • Modifying the Cost of CIP Assets
  • Capitalising a CIP Asset
  • Reversing a Capitalised Asset
  • Recording a Capitalisation - Adding and Capitalising in the Same Period
  • Recording a Capitalisation - Adding and Capitalising in Different Periods
  • CIP Assets and Oracle Projects
  • Capital Projects Flow Integration
  • Creating Mass Additions from Oracle Projects
  • Integrating Oracle Projects with Oracle Assets

Module 8: Asset Adjustments

  • Asset Adjustment Overview
  • Single Asset Reclassification
  • Mass Reclassification
  • Inheriting Depreciation Rules
  • Mass Transactions Process
  • Adjusting Units
  • Adjusting Financial Information
  • Expense or Amortise Depreciation Adjustments
  • Using Mass Changes
  • Single and Mass Asset Transfers
  • Performing Physical Inventory
  • Entering Physical Inventory
  • Physical Inventory Comparison and Reconciliation
  • Integrating ADI with Physical Inventory

Module 9: Depreciation

  • Elements of Depreciation
  • Basic Depreciation Calculation
  • Depreciation Methods
  • Using the Life-Based and Flat-Rate Method
  • Prorate Conventions
  • Run Depreciation Process
  • Depreciation Program Processes
  • Rollback Depreciation
  • Projecting Depreciation for an Asset
  • Defining a Projection
  • Depreciation Forecasts
  • Using Depreciation Override
  • Depreciation Reports

Module 10: Asset Retirements

  • Tracking Asset Retirements
  • Overview of Retiring an Asset
  • Restrictions on Retirements and Reinstatements
  • Fully Retiring Assets
  • Partially Retiring Assets
  • Mass Asset Retirements
  • Reinstating Retired Assets
  • Calculate Gains and Losses Program
  • Retirement Processing Flow
  • Processing a Pending Retirement and Reinstatement
  • Calculating Depreciation for the Period Retired
  • Recording Retirements and Reinstatements
  • Retirement Reports

Module 11: Asset Accounting

  • Assets Journal Entries Flow
  • Journal Entries Created
  • Account Generator
  • Default Account Generator Process for Oracle Assets
  • Account Generator Example - Build Asset Cost Account
  • Generating Reports to Reconcile to The General Ledger
  • Reconciling Asset Cost Accounts
  • Reconciling a CIP Cost Account
  • Reconciling a Reserve Account
  • Reconciling Depreciation Expense
  • Reconciling Mass Additions

Module 12: Asset Enquiry and Reporting

  • Viewing Asset Information Online
  • Asset Inquiries
  • Viewing Financial Information
  • Viewing Transaction History
  • Oracle Assets Reporting
  • Assets Reports Groupings

Module 13: Tax Accounting

  • Creating a Tax Book
  • Asset Books Regions
  • Prerequisites for Setting Up Tax Book Asset Categories
  • Entering Information in Tax Books
  • Populating the Tax Book
  • Updating a Tax Book Manually
  • Deferred Depreciation
  • Calculating Deferred Depreciation
  • Adjusting Accumulated Depreciation
  • Adjusting Depreciation Reserve
  • Controlling Mass Depreciation Adjustment
  • Calculating Mass Depreciation Adjustment
  • Automatically Adding CIP Assets to Tax Books
  • General and Special Tax Reports
  • Depreciation Adjustment Reports

Show moredown

Prerequisites

There are no formal prerequisites for attending this course.

Audience

This course is for IT Professionals and Database Administrators who wants to learn about databases and Oracle Technologies.

Oracle Asset Management Training​ Course Overview

Asset Management is a systematic process of developing, operating, maintaining, and upgrading assets in the cost-effective manner. This course describes how to set up and use oracle assets. In this course delegates will acquire knowledge of the asset life cycle. They will also learn how to add an asset, adjust, and revalue an asset. This course defines asset books and categories, setting up depreciation, and create and prepare mass additions. Delegates will learn how to post mass additions and use CIP asset additions.

This course teaches delegates how to adjust and maintain assets. They will also acquire knowledge of clearing historical data, transferring assets, depreciating asset and projects assets. This “Oracle Asset Management Training” course describes report reconciliation, retiring and reinstating assets and calculating gains and losses. Delegates will acquire knowledge of how to create asset management journal entries and use the account generator. They will also learn how to perform asset inquiries and reports.

At the end of this “Oracle Asset Management Training” course delegates will learn about Tax Accounting. In Tax Accounting, they will learn how to create a tax book, populating the tax book, calculating deferred depreciation, controlling and calculating mass depreciation adjustment. Delegates will also learn how to use the Mass Additions Process to integrate with Oracle Accounts Payable.

Show moredown

  • Delegate pack consisting of course notes and exercises
  • Manual
  • Experienced Instructor

Show moredown

Online Instructor-led (3 days)

Online Self-paced (24 hours)

Oracle Database Data Guard Training Course Outline

Module 1: Data Guard Overview

  • Overview of Data Guard
  • Requirements for Maintaining a Standby Database
  • Data Guard Terminology
  • Types of Standby Databases
  • Levels of Protection
  • Physical, Logical, and Snapshot Standby Databases
  • Role Transition Management Services
  • Data Guard Interfaces
  • Standby Database Creation
  • Data Guard Installation
  • SYSDG Administrative Privilege for Data Guard Operations

Module 2: Data Guard Architecture

  • Data Guard Architecture
  • Processes Active on the Primary and Standby Database
  • Data Guard Architecture and Initialisation Parameters
  • Data Guard Usage with a Multitenant Database
  • PDB Creation and Cloning in a Multitenant Architecture Environment

Module 3: Create a Physical Standby Database with SQL Commands

  • Prepare the Primary Database for Data Guard
  • Initialisation Parameters for the Standby Database
  • Data File and Control File Duplication
  • Create the Standby Instance
  • Network Files Configuration
  • Activate the Standby Database
  • Verify Primary and Standby Databases are Working
  • Archive Log Loss
  • Open the Standby Database
  • Shut Down and Start-Up the Data Guard Environment
  • Active Data Guard
  • Far Sync Instance
  • Monitor the Primary and Standby Databases

Module 4: Redo Transport Services

  • Overview of Redo Transport Services
  • How Data Guard Sends Redo Data?
  • Control when Redo Data is Sent with the VALID_FOR Option
  • Handle Transmission Errors
  • Manage Archive Gaps
  • Automatic Outage Resolution with Data Guard in 19c
  • Levels of Protection
  • Fast-Sync Mode

Module 5: Redo Apply Services

  • Overview of Log Apply Services
  • Apply Redo Data Immediately
  • Delay Redo Data Application
  • Terminate Redo Apply Services
  • Configure a Cascading Standby Database
  • Create a Snapshot Standby Database

Module 6: Role Transition using SQL Commands

  • Role Transition Overview
  • Prepare the Primary and Standby Database
  • Perform a Switchover and Failover
  • Reinstate the Failed Primary
  • Overview of Application Continuity in a Data Guard Environment

Module 7: Change Management

  • Change Management Overview
  • Add Data Files or Tablespaces
  • Drop Tablespaces and Delete Data Files
  • Transportable Tablespaces
  • Rename Data Files
  • Add or Drop Redo Log Files
  • DML Operations on Active Data Guard in 19c
  • Nologging Operations
  • Nologging Enhancements from 18c
  • Lost Write Detection
  • Shadow Lost Write Protection from 18c

Module 8: Create a Standby Database with Recovery Manager

  • Overview of Standby Database Creation with RMAN
  • Create a Suitable Backup with RMAN
  • Standby Path and File Names
  • Build the Standby Instance
  • Create a Standby Database with RMAN
  • Create a Standby Database with RMAN from an Active Database
  • Create a Standby Database with the DBCA

Module 9: Backup and Recovery Considerations in an Oracle Data Guard Configuration

  • Implement a Backup and Recovery Strategy
  • The Usage of RMAN in a Data Guard Configuration
  • Backup and Recovery of a Primary Database with a Physical Standby Database
  • Backup and Recovery of a Logical Standby Database
  • Use an RMAN Recovery Catalog in a Data Guard Configuration
  • Create the Recovery Catalog
  • Register a Database in the Catalog
  • Configure Daily Incremental Backups
  • Recover from the Loss of Data Files and Control Files on Primary and Standby Databases
  • Recover from the Loss of Online Redo Logs
  • Restore and Recover Data Files Across the Network
  • Roll Forward a Physical Standby Database using RECOVER A STANDBY DATABASE FROM SERVICE primary_db
  • One Command Refresh of the Standby Database
  • Enable Block Change Tracking for a Physical Standby Database

Module 10: Use Flashback Database in a Data Guard Configuration

  • Overview of Flashback Database Usage in a Data Guard Configuration
  • Configure Flashback Database
  • Use Flashback Database Instead of Apply Data
  • Use Flashback Database and Real-Time Apply
  • A Flashback through Standby Database Role Transitions
  • Automatic Flashback Standby in 19c
  • Use Flashback Database after Failover

Module 11: Data Guard Broker Overview

  • Overview of Oracle Data Guard Broker
  • Oracle Enterprise Manager
  • The DGMGRL Command Line Interface
  • Data Guard Monitor
  • Install Oracle Data Guard
  • Start-Up and Use the Data Guard Broker
  • Obtaining Data Guard Diagnostic Information
  • The v$DATAGUARD_PROCESS View

Module 12: Build a Configuration Using the Broker

  • Prepare for a Configuration Build
  • Configure the Primary and Standby Database
  • Validate a Database
  • New Broker Commands in 18c
  • Validate a Database spfile
  • Validate Network Configuration
  • Validate Status Connect Identifier
  • Show, Enable and Disable the Configuration
  • Execute DGMGRL Scripts

Module 13: Manage a Configuration Using the Broker

  • Data Guard Broker Configuration Files
  • Display and Edit Database Properties
  • Set the Configuration Protection Mode
  • Use Additional Broker Configurable Properties from 18c and 19c
  • Configure Fast-Start Failover
  • Fast Start Failover in Observer Only Mode from 19c
  • Execute a Switchover
  • Execute a Failover
  • Configure Multiple Failover Targets
  • Alter the State of a Database
  • Export the Broker File
  • Monitor the Configuration
  • Configure Multiple Observers

Module 14: Create a Standby Database with the DBCA

  • Overview of Creating a Physical Standby Database Creation with the DBCA
  • Create a Standby Database with the DBCA
  • Add Entries to the tnsnames.ora File
  • Use the Data Guard Broker to Create the Configuration
  • Create the Standby Redo Logs on the Primary and Standby Database
  • Verify the Data Guard Configuration
  • Edit the listener.ora File on the Primary and Standby Database
  • Create a Data Guard Physical Standby Database for a Multitenant Container Database with the DBCA in 19c

Module 15: Creating a Logical Standby Using SQL Commands

  • Overview of Creating a Logical Standby Database Using SQL Commands
  • Prepare the Primary and Standby Database
  • Transition a Physical Standby to a Logical Standby
  • Start the Standby Instance
  • Real-Time Apply
  • Delete Archives
  • Dictionary Views Containing Useful Standby Information
  • Monitor the SQL Apply Progress

Module 16: Managing a Logical Standby Database

  • Overview of SQL Apply Architecture
  • Transaction Size Considerations
  • DML and DDL Apply Considerations
  • Intercept DDL Statements
  • Skip DML and DDL on the Standby Database
  • Modify a Logical Standby Database
  • Materialized Views on the Primary Database
  • Table Instantiation
  • Restart SQL Apply
  • Customise DBA_LOGSTDBY_EVENTS
  • Rolling Upgrades Using Logical Standby
  • Rolling Upgrades on a Physical Standby
  • Job Scheduling on a Logical Standby

Module 17: Tuning a Standby Database

  • Overview of Tuning a Physical Standby Database
  • Temporary Undo, Global and Session Variables
  • The Significance of Tables without Primary Keys
  • Statistics on the Logical Standby
  • Transaction Consistency
  • Adjusting the Number of Applier and Preparer Processes
  • Tune the Memory for the LCR Cache
  • Set the ReopenSecs and NetTimeout Database Properties
  • Compress Redo Transmission
  • Optimise SQL and Redo Apply

Module 18: Overview of Patching and Upgrading Databases in a Data Guard Configuration

  • Upgrade the Oracle Data Guard Broker Configuration
  • Upgrade the Oracle Database in a Data Guard Configuration with a Physical and a Logical Standby Database
  • Use DBMS_ROLLING to Upgrade a Database
  • Leading Group Databases and Leading Group Master
  • Trailing Group Databases and Trailing Group Master
  • Use DBMS_ROLLING to Carry out a Rolling Database Upgrade

Module 19: Data Guard Quick Setup Guide

  • Data Guard Physical Standby Setup Using the Data Guard Broker
  • Primary Server Setup
  • Configure Initialisation Parameters
  • Service Setup
  • Standby Server Setup
  • Create a Standby Database using DUPLICATE
  • Enable the Broker
  • Database Switchover and Failover
  • Read-Only Standby and Active Data Guard
  • Snapshot Standby

Show moredown

Prerequisites

There are no prerequisites for this course.

Audience

This course is for IT Professionals and Database Administrators who want to learn about databases and Oracle Technologies.

Oracle Database Data Guard Training ​Course Overview

This course describes the main architectural concepts of Oracle Data Guard. Oracle Data Guard ensures data protection, high availability, and disaster recovery for enterprise data. It provides a complete set of services for creating, managing, monitoring, and maintaining one or more standby databases to enable production Oracle databases to survive data corruptions and disasters. Data Guard maintains standby databases as transactionally consistent copies of the production database.

Delegates will learn the use of Oracle Data Guard to protect an Oracle database against planned and unplanned downtime. They will get an understanding of creating and managing physical, logical and snapshot standby databases. In addition, they will learn how to use standby databases for the purpose of reporting, querying, and testing.

This course teaches delegates in preparing a primary database for a data guard configuration. This course describes how to manage a data guard configuration and troubleshoot standby database configurations. This course explains how to use flashback in a data guard configuration, backup and recover a data guard configuration, and use the data guard broker. Delegates will gain an understanding of patching and upgrading databases in an Oracle Data Guard Configuration.

Show moredown

  • Delegate pack consisting of course notes and exercises
  • Manual
  • Experienced Instructor

Show moredown

Not sure which course to choose?

Speak to a training expert for advice if you are unsure of what course is right for you. Give us a call on +44 1344 203999 or Enquire.

What our customers are saying

Frequently asked questions

FAQ's

Please arrive at the venue at 8:45am.
Please see our Oracle Training courses available in Philippines
The Knowledge Academy is the Leading global training provider in the world for Oracle Training.
The price for Oracle Training certification in Philippines starts from $2709.

Why we're the go to training provider for you

icon

Best price in the industry

You won't find better value in the marketplace. If you do find a lower price, we will beat it.

icon

Trusted & Approved

We are accredited by PeopleCert on behalf of AXELOS

icon

Many delivery methods

Flexible delivery methods are available depending on your learning style.

icon

High quality resources

Resources are included for a comprehensive learning experience.

barclays Logo
deloitte Logo
Thames Water Logo

"Really good course and well organised. Trainer was great with a sense of humour - his experience allowed a free flowing course, structured to help you gain as much information & relevant experience whilst helping prepare you for the exam"

Joshua Davies, Thames Water

santander logo
bmw Logo
Google Logo
Shell Logo

"...the trainer for this course was excellent. I would definitely recommend (and already have) this course to others."

Diane Gray, Shell

Looking for more information on Oracle Training