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)

Classroom (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 (3 days)

Classroom (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)

Classroom (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 (3 days)

Classroom (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)

Classroom (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)

Classroom (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 (2 days)

Classroom (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)

Classroom (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 (2 days)

Classroom (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)

Classroom (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)

Classroom (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

Online Instructor-led (3 days)

Classroom (3 days)

Online Self-paced (24 hours)

Oracle Procure to Pay Training​ Course Outline

Module 1: Overview of Oracle Purchasing

  • 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 Quotations

  • 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 Requisition
  • Create a Foreign Currency 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 a Purchase Order
  • Amend a Purchase Order
  • 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 Modules

  • 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 Accounting

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

Module 17: Introduction to Payable System

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

Module 18: 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 19: Inquiry on Invoices

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

Module 20: Apply and Release Holds

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

Module 21: Approve Invoices

  • Approval Methods
  • Approve a Non-PO Invoice

Module 22: Adjust or Cancel Invoices

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

Module 23: Payment Banks and Payment Processing

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

Module 24: General Ledger Transfer

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

Module 25: Integration with Other Modules

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

Module 26: Payables Set Up Overview

  • Define Financials and 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 27: Payables Period Close

  • Payables Period End Procedures
  • Run Payables Accounting Process
  • Run the Accounts Payable Trial Balance
  • Close the Payables Accounting Period
  • Resolve Period-End Exceptions
  • Open the Following Payables Accounting Period

Module 28: Withholding Tax

  • Set Up Tax Types
  • Set Up Inland Revenue Supplier Account
  • Set Up Withholding Tax Special Calendar
  • Set Up Tax Codes
  • Set Up or Amend Supplier Account
  • Process Supplier Invoice with Withholding Tax
  • Query Back and Validate Tax Deduction Invoice

Show moredown

Prerequisites

There are no prerequisites for this course.

Audience

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

Oracle Procure to Pay Training​ Course Overview

Oracle Procure to pay is an integrated solution that links to purchasing and payables to maximise return on invested capital. With the help of Oracle procure to pay, organisations can reduce the cost to improve margins, streamline procure to pay processes to improve working capital, and drive compliance to optimise asset usage. This course explains purchasing and payables.

In purchasing module, delegates will acquire knowledge of how to manage suppliers, create items, create RFQs and quotations. They will also acquire knowledge of approving suppliers and sourcing rules, processing purchase order requisitions, purchase orders, purchase order receipts, approving/rejecting requisitions, and forwarding to the workflow process.  This course describes raising iProcurement requisitions, running standard purchasing reports, and carrying out end processes.

During this course, delegates will gain an understanding of how to enter, review, and approve the supplier’s invoices. They will learn how to adjust or cancel an invoice, enter recurring invoices, process prepayments, holds and releases, enter and process credit and debit memos. Furthermore, this course also describes processing single payment batch processing, closing periods and resolving period-end exceptions, opening next periods, and running accounts payable reports.

Show moredown

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

Show moredown

Online Instructor-led (3 days)

Classroom (3 days)

Online Self-paced (24 hours)

Oracle 12c Data Integrator (ODI) Training Course Outline

Module 1: Oracle Data Integrator

  • Introduction to Oracle Integrator
  • ODI Architecture
  • ODI Components
  • Graphical Modules
  • ODI Agents
  • Oracle Data Integrator Repositories Overview

Module 2: Administering ODI Repositories and Agents

  • Administrating the ODI Repositories
  • Creating Repository Storage Spaces
  • Creating and Connecting to the Master Repository
  • Creating and Connecting to the Work Repository
  • Creating a Wallet to Securely Store Credentials
  • Managing ODI Agents
  • Creating a Physical Agent

Module 3: ODI Topology Concepts

  • Overview of ODI Topology
  • About Data Servers and Physical Schemas
  • Defining the Physical Architecture
  • Defining the Logical Architecture
  • Mapping Logical and Physical Resources

Module 4: Setting Up a New ODI Project

  • Creating a New Project
  • Creating and Maintaining Folders
  • Organising Projects and Folders
  • Exchanging ODI Objects and Sharing Global Objects
  • Object Export and Import
  • Creating and Labelling with Markers

Module 5: Oracle Data Integrator Model Concepts

  • Model Overview
  • Understanding Metadata in ODI
  • Understanding Reverse Engineering
  • Creating Models Organising Models
  • Creating Datastores
  • Configuring Constraints in ODI
  • Creating Keys and References

Module 6: Organising ODI Models and Creating Data Stores

  • What is a Mapping?
  • Business Rules for Mappings
  • Creating a Basic Mapping
  • Define Join and Filter
  • What is Constraint?
  • Staging Area

Module 7: Concepts of ODI Mapping

  • Introduction to Mapping
  • Business Rules for Mapping
  • Define Mapping, a Filter, and Join
  • Integration Process
  • Define Staging Area
  • Execution Location
  • Creating an Intermediate Mapping

Module 8: Designing Mappings

  • Designing Mapping
  • Multiple Source
  • Datastores
  • Creating Joins
  • Filtering Data
  • Disabling Transformations
  • Overview of the Flow
  • Specifying the Staging Area

Module 9: Mapping: Monitoring and Debugging

  • Monitoring Mappings
  • Objects with Operator
  • Sessions and Tasks
  • Monitoring Execution of a Mapping
  • Troubleshooting
  • Keys to Reviewing the Generated Code Errors

Module 10: Creating and Running ODI Procedures

  • Creating Procedures
  • Adding Commands
  • Adding Options
  • Running a Procedure
  • Viewing Results with Operator

Module 11: Using ODI Packages

  • Creating a Package
  • Executing a Package
  • Creating Advanced Packages
  • Error Handling
  • Controlling an Execution Path
  • Creating a Loop
  • Using the Advanced Tab

Module 12: ODI Scenarios and Versions

  • Managing Scenarios with Load Plans
  • Preparing Scenarios for Deployment
  • Automating Scenario Management
  • Scheduling the ODI Scenario
  • Overview of ODI Version Management
  • Handling Concurrent Changes

Show moredown

Prerequisites

There are no 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 12c Data Integrator (ODI) Training​ Course Overview

Data Integrator is a comprehensive data integration platform. It is high volume, high performance, batch loads, to event-driven, tickle-feed integration processes, to SOA-enabled data services. This course teaches delegates oracle integrator architecture, components, graphical modules, ODI agents and oracle integrator repositories. Delegates will also gain an understanding of how to create repository storage spaces, create and connect to the master repositories and work repositories. They will also learn how to set up a new ODI project: create a new project, create and maintain folder, create model organising models, data stores, and configure constraints in ODI.

This course describes how to organise ODI models and create data stores. In this course, delegates will learn about mapping, business rules for mapping, filter, joins, constraints, and staging area. They will also acquire knowledge of monitoring and debugging mapping. This course explains how to create and run ODI procedures and use ODI packages.

Show moredown

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

Show moredown

Online Instructor-led (3 days)

Classroom (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)

Classroom (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)

Classroom (2 days)

Online Self-paced (16 hours)

Oracle WebLogic Administration Training​ Course Outline

The course outline is designed to provide knowledge of the administrative task of the Oracle WebLogic server. These modules are arranged by our IT professionals to provide technical knowledge of WebLogic Server Administrative tasks. Let's get into this training to acquire and enhance skill as an administrator of Oracle WebLogic Server.

Module 1: Oracle WebLogic Server Overview

  • Introduction of WebLogic Server
  • Understand WebLogic Server Terms and Tools
  • Explain WebLogic Server Architecture  

Module 2: Installing and Patching WebLogic Server

  • Understand Supported Configurations
  • Installing WebLogic Server 12c
  • Applying a Patch to WebLogic Server

Module 3: Creating Domains Overview

  • Explain Domain Configuration
  • Creating a Domain with Configuration Wizard
  • Configuring Domain Resources

Module 4: Starting WebLogic Server

  • Starting and Stopping Server with Standard Scripts
  • Describe Startup Problems
  • Customising Standard Start Scripts

Module 5: Administration Console

  • Access Administration Console
  • Creating and Configuring Server

Module 6: Configuration of JDBC

  • JDBC Generic Data Sources
  • GridLink Data Sources
  • Data Source Connection

Module 7: Node Manager Overview

  • Introduction of Node Manager
  • WebLogic Server Node Manager Utility
  • Configuring WebLogic Server Machines
  • Setting Up and Configuring Node Manager
  • Starting WebLogic Server Node Manager

Module 8: Deploying Applications Overview

  • Deploying Applications to WebLogic Server
  • Testing Deployed Applications
  • Monitoring Deployed Applications
  • Stress Testing WebLogic Server

Module 9: Cluster in Oracle WebLogic Server

  • Planning for a WebLogic Server Cluster
  • Creating and Configuring a WebLogic Server Cluster
  • Creating and Configuring a WebLogic Server Dynamic Cluster
  • Configuring Oracle HTTP Server as a WebLogic Server Cluster Proxy
  • Debugging Cluster Errors

Module 10: Transactions in Oracle WebLogic Server

  • WebLogic Server Transaction Architecture
  • WebLogic Server Transactions

Module 11: WebLogic Server Security

  • Describe the WebLogic Server Security Domain
  • Restore a WebLogic Server Domain

Module 12: Backup and Restoring a Domain

  • Backup Strategies for WebLogic Server Domain
  • Restore Strategies for WebLogic Server Domain

Show moredown

Prerequisites

It would be beneficial if delegates will have a basic knowledge of system administration and operating system.

Audience

This course is designed for various IT professional roles such as:

  • Java EE Developer
  • System Administrator
  • Technical Administrator

The Oracle technologies learner can also attend this course to enhance their knowledge of Oracle Technologies.

Oracle WebLogic Administration Training​ Course Overview

Oracle WebLogic is a scalable, enterprise-ready Java Platform, enterprise edition (Java EE) application server. This infrastructure supports the deployment of many types of distributed applications. Oracle WebLogic provides the administrative features such as creating a domain, starting servers, monitoring domain resources, setting up and using node manager, deploying applications, configuring database resources, configuring the cluster and more tasks.

In this 2-day course, delegates will learn about all the concepts of Oracle WebLogic at an administrative level. Delegates will get an essential understanding of how to install and configure Oracle WebLogic Server as well as perform the administrative tasks on it. In addition, delegates will gain knowledge of how to monitor domain resources to evaluate and increase the performance and scalability of an organisation’s applications and services. Delegates will also learn about backup and restore strategies of WebLogic Server Domain.

On course completion, delegates will be able to create and manage the WebLogic server at the administrator level and configure Oracle WebLogic Server as per requirements.

Show moredown

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

Show moredown

Online Instructor-led (3 days)

Classroom (3 days)

Online Self-paced (24 hours)

Oracle SQL & PL/SQL Fundamentals Course Outline

The course is based on Oracle SQL and PL/SQL and its functionality. Delegates will gain complete knowledge of relational database concepts. This outline is focused on providing an understanding of essential terms of the Oracle SQL and PL/SQL.  The following modules are arranged to deliver accurate and better databases knowledge.

Module 1: Relational Database Concepts

  • Oracle Database Overview
  • Relational Database Structure
  • Understand Table, Rows and Columns
  • Indexes, Primary Keys and Foreign Keys
  • Understand Support Datatypes

Module 2:  Working with SQL*Plus

  • SQL*Plus Overview
  • Entering and Executing SQL Statements
  • Editing SQL Statements
  • Creating, Editing and Executing SQL Files
  • SQL*Plus Parameters

Module 3: Working with SQL Developer

  • Oracle Developer Overview
  • Starting SQL Developer
  • Configure a Connection
  • Navigation Tabs
  • SQL Worksheet

Module 4: Retrieving Data with the SELECT Statement

  • SELECT Statement Overview
  • The SELECT and FROM Clauses
  • Conditions and the WHERE Clause
  • Conditional Operators
  • The ORDER BY Clause
  • Column Aliases
  • Arithmetic Expressions
  • Precedence of Operators

Module 5: Joining Tables in Oracle

  • Table Join Overview
  • Understand Inner Joins
  • Table Aliases
  • Outer Joins and Self Joins
  • ANSI Joins

Module 6: Numeric, Character and Data Functions

  • Function Types
  • Numeric Functions
  • Character Functions
  • String Concatenation
  • Date Arithmetic and Data Functions

Module 7: Working with Subqueries

  • Introduction to Subqueries
  • Use a Subquery as an Alternative to Join
  • Handle Multiple Records in Subqueries
  • Subquery in a Having Clause
  • Anti-Join
  • In-Line Views
  • Top-N Queries
  • Complex Subqueries
  • Multi-Column Subqueries
  • Correlated Subqueries
  • Subquery Rules
  • Combining Unrelated Aggregates
  • Using the ANY, ALL and SOME Operators

Module 8: Managing Data in Oracle

  • Inserting, Updating, Deleting Rows
  • Verifying Updates
  • Transaction Control
  • Commit and Rollback
  • Commits and Constraints
  • Amending Data in SQL Developer

Module 9: Managing Tables in Oracle

  • Creating Tables
  • Specifying Constraints
  • Altering Tables, Columns and Constraints
  • Dropping Tables, Columns and Constraints
  • Copying Tables

Module 10: Managing Indexes and Views

  • Creating Indexes
  • Dropping Indexes
  • Listing Indexes
  • Creating and Using Views
  • Dropping Views
  • Listing Views

Module 11: Managing Sequences and synonyms

  • Create a Sequence
  • View Sequence Details
  • Create a Synonym
  • List Synonyms

Module 12: Define PL/SQL Fundamentals

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

Module 13: Explain Program Logics

  • IF THEN ELSIF ELSE Statements
  • CASE Statements
  • The Basic Loop Construct
  • WHILE and FOR Loops
  • Nested and Labelled Loops
  • The GOTO Statement
  • The CONTINUE Statement

Module 14: Working with Cursor

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

Module 15: Exceptions and Nested Blocks

  • The EXCEPTION Section
  • Types of Exception
  • Handling Named System-Raised Exceptions
  • Handling Un-Named System-Raised Exceptions
  • User-Declared Exceptions and Application Errors
  • WHEN OTHERS THEN NULL
  • Nested and Labelled Blocks
  • Propagation of Exceptions
  • Scope of Variables and Cursors
  • Scope of Goto Statements

Module 16: Explain PL/SQL Records and Index by Tables

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

Show moredown

Prerequisites

There are no prerequisites to attend this course. It would be great if delegates have a basic knowledge of databases.

Audience

This course is designed for IT professionals and database learner.

Oracle SQL & PL/SQL Fundamentals​ Course Overview

Oracle is always ahead to provide the best platform and productivity to technologies. It also gives a helping hand to a platform to manage their databases. In oracle database management, PL/SQL is a procedural language extension to Structured Query language (SQL). The purpose of PL/SQL is to combine database language and procedural programming language as well as it automatically inherits the security, portability, and robustness of the Oracle database. It allows a declaration of constants and variables, procedures and functions, types and variable of those types and trigger.

This 3-day course will provide a complete knowledge of Oracle SQL and PL/SQL and Its functionality. From this fundamental course, delegates will learn how to write SQL statements and scripts using Oracle SQL. Delegates will get an understanding of statements, use of SQL functions, SQL*Plus parameters and table and view handling statements. The data tables operations such as inserting, updating, and deleting rows, will also be taught in this course. Delegates will learn about writing and running PL/SQL programs from SQL*Plus or SQL developer and using SQL statements within PL/SQL as well as implementing nested and labelled loops and blocks.

On course completion, delegates will be able to implement conditional execution, loop control, cursor handling, and exceptions handling.

Show moredown

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

Show moredown

Online Instructor-led (2 days)

Classroom (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 (3 days)

Classroom (3 days)

Online Self-paced (24 hours)

Oracle Forms Training Course Outline

Module 1: Introduction

  • What is Oracle Forms?
  • Oracle Form Builder Components
  • Application Code Partitioning
  • Exercise: Preparing to Work with Oracle Forms

Module 2: Getting Started

  • Creating an Oracle Form
  • Running an Oracle Form
  • The Runtime Interface
  • Performing Queries
  • Updating Records
  • Exercise: Creating and Running an Oracle Form

Module 3: The Form Builder Interface

  • The Main Menu
  • The Object Navigator
  • Basic Components of a Form
  • Property Palettes
  • The PL/SQL Editor
  • The Layout Editor
  • Exercise: Using Oracle Form Builder Tools

Module 4: Building a Form

  • Basic Steps in Development
  • Creating a Data Block
  • Customising the Layout
  • Setting Properties for Data Blocks and Items
  • Adding Trigger Code
  • Running the Oracle Form
  • Exercise: Building a Simple Oracle Form
  • Exercise: Building a Master-Detail Oracle Form

Module 5: Triggers

  • What is Navigation?
  • Navigational Triggers
  • Item and Block Validation
  • Commit Form Triggers
  • Query Triggers
  • Trigger Types and Scope
  • Trigger Code
  • Global, System and Bind Variables
  • Handling Errors
  • Exercise: Implementing Navigational Triggers
  • Exercise: Implementing Commit-time Triggers
  • Exercise: Implementing Query Triggers

Module 6: Introducing Standard Built-Ins

  • Unrestricted Built-in Procedures and Functions
  • Restricted Built-in Procedures
  • Calling Built-ins
  • Getting and Setting Properties at Runtime
  • Using Internal Object IDs
  • Error Handling
  • Exercises: Enhancing Oracle Form Applications Using Built-ins

Module 7: More Interface Objects

  • Basic Controls - Text and Display Items
  • Iconic Push-buttons
  • Check Boxes and Radio Groups
  • List Items
  • Image Items
  • Alerts
  • Editors
  • Record Groups and LOVs
  • Hierarchical Trees
  • Exercises: Creating Additional Interface Items

Module 8: Program Units

  • Oracle Form Module Program Units
  • PL/SQL Libraries
  • Database Procedures
  • Exercise: Using PL/SQL Libraries
  • Exercise: Using Database Procedures

Module 9: Canvases and Windows

  • Content Canvases
  • Stacked Canvases
  • Toolbar Canvases
  • Tab Canvases
  • Handling Windows
  • Exercise: Generating Canvases and Toolbars
  • Exercise: Handling Multi-Window Applications

Module 10: Re-Using Components

  • Visual Attributes
  • Property Classes
  • Copying Objects
  • Subclassing
  • Object Groups
  • Object Libraries
  • Exercise: Creating and Using a Property Class
  • Exercise: Creating and Using an Object Library

Module 11: Introduction to Calling Other Forms

  • Built-in Procedures
  • Methods for Calling other Oracle Forms
  • Exercise: Calling One Oracle Form from Another

Module 12: Debug Facilities

  • Running in Debug Mode
  • Creating Break Points
  • Monitoring Application Data

Module 13: Oracle Forms Services

  • Overview
  • Oracle Forms Compatibility Issues
  • Architecture and Components of the Oracle Forms Client

Module 14: Getting Started

  • Preparation
  • Default Deployment
  • Using runform.htm for Testing
  • Generating URLs
  • Default Configuration Files
  • Exercise: Test an Oracle Form Using runform.htm
  • Exercise: Create a URL to Deploy and Test an Oracle Form

Module 15: Configuring Forms Services

  • The formsweb.cfg Configuration File
  • System and Runform Parameters
  • Forms Applet and HTML Tag Parameters
  • Archive Parameters
  • Creating Application-specific Configurations
  • Renaming and Relocating formsweb.cfg
  • Customising the Base HTML Files
  • Exercise: Create Application-specific Configurations
  • Exercise: Create a Custom Configuration File

Module 16: Dealing with Icons and Images

  • Boilerplate and HTML Images
  • Forms Icons and Images
  • Images Loaded at Runtime
  • Other Images
  • SplashScreen, Background, and Logo Images
  • Using jar Files
  • Exercise: Deploy a Variety of Icons and Images
  • Exercise: Create and Use a jar File

Module 17: Other Configuration Issues

  • Icons in Form Builder
  • The Environment File default.env
  • The Registry File registry.dat
  • Font Mappings
  • The web.xml and forms90.conf Config Files
  • Notes on Configuring for SSO
  • JInitiator
  • Exercise: Configure registry.dat and default.env
  • Exercise: Configure web.xml and forms90.conf

Module 18: Performance Considerations

  • Built-in Optimisation Features
  • Using and Customising JInitiator
  • Improving Performance
  • Exercise: Implement Features to Improve Performance

Show moredown

Prerequisites

There are no prerequisites for this course.

Audience

This course is for IT Professionals and Developers, who want to learn about Oracle forms and Oracle Technologies.

Oracle Forms Training Course Overview

Oracle Forms is a component of Oracle Fusion Middleware. It is used to develop and deploy forms application which provides a user interface to access Oracle Database. This course is designed to provide delegates with the knowledge of how to use oracle form to develop and deploy a database application.

In this course, delegates will learn how to generate text items, buttons, and radio groups. They will also learn how to create toolbars, canvases, and windows. This course describes writing triggers to enhance application functionality, calling standard built-in procedures and functions, developing program units and code libraries, and generating objects for reuse in other products. Delegates will learn how to use debug tools and test oracle forms using runform.htm. In addition, they will also acquire knowledge of how to deploy custom images and icons. Furthermore, delegates will learn how to set default environment variables and implement techniques to improve performance.

Show moredown

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

Show moredown

Online Instructor-led (3 days)

Classroom (3 days)

Online Self-paced (24 hours)

Oracle BI 12c Build Repositories Training Course Outline

Module 1: Repository Basics

  • Oracle BI Architecture
  • Repository Structures, Features, and Functions
  • Oracle BI Administration Tool
  • Creating a Repository
  • Loading a Repository into Oracle BI Server

Module 2: The Repository Physical Layer

  • Importing Data Sources
  • Connection Pool Properties
  • Defining Keys and Joins
  • Physical Layer Object Properties
  • Alias Tables
  • Working with the Physical Layer Diagram

Module 3: Business Model and Repository Mapping Layer

  • Building a Business Model
  • Building Logical Tables, Columns, and Sources
  • Defining Logical Joins
  • Building Measures
  • Examining Business Model Object Properties
  • Working with the Business Model and Mapping Layer Diagram

Module 4: Repository Presentation Layer

  • Exploring Presentation Layer Objects
  • Creating Presentation Layer Objects
  • Modifying Presentation Layer Objects
  • Examining Presentation Layer Object Properties
  • Nesting Presentation Tables
  • Controlling Presentation Layer Object Visibility

Module 5: Testing and Validating a Repository

  • Checking Repository Consistency
  • Turning on Logging
  • Uploading the Repository through Enterprise Manager
  • Executing Analyses to Test the Repository
  • Inspecting the Query Log

Module 6: Managing Logical Table Sources

  • Adding Multiple Logical Table Sources to a Logical Table
  • Specifying Logical Content

Module 7: Adding Calculations to a Fact

  • Creating New Calculation Measures Based on Logical Columns
  • Creating New Calculation Measures Based on Physical Columns
  • Creating New Calculation Measures Using the Calculation Wizard
  • Creating Measures Using Functions

Module 8: Working with Logical Dimensions

  • Creating Logical Dimension Hierarchies
  • Creating Level-Based Measures
  • Creating Share Measures
  • Creating Dimension-Specific Aggregation Rules
  • Creating Presentation Hierarchies
  • Creating Parent-Child Hierarchies
  • Creating Ragged and Skipped-Level Hierarchies

Module 9: Enabling Usage Tracking

  • Creating the Usage Tracking Tables
  • Setting Up the Sample Usage Tracking Repository
  • Tracking and Storing Oracle BI Server Usage at the Detailed Query Level
  • Using Usage Tracking Statistics to Optimise Query Performance and Aggregation Strategies

Module 10: Using Model Checker and Aggregates

  • Using Model Check Manager
  • Modelling Aggregate Tables to Improve Query Performance
  • Using the Aggregate Persistence Wizard
  • Testing Aggregate Navigation
  • Setting the Number of Elements in a Hierarchy

Module 11: Using Partitions and Fragments

  • Exploring Partition Types
  • Modelling Partitions in an Oracle BI Repository

Module 12: Using Repository Variables

  • Creating Session Variables
  • Creating Repository Variables
  • Creating Initialisation Blocks
  • Using the Variable Manager
  • Using Dynamic Repository Variables as Filters

Module 13: Modelling Time Series Data

  • Using Time Comparisons in Business Analysis
  • Using Oracle BI Time Series Functions to Model Time Series Data

Module 14: Modelling Many-to-Many Relationships

  • Using Bridge Tables to Resolve Many-to-Many Relationships Between Dimension Tables and Fact Tables       

Module 15: Setting an Implicit Fact Column

  • Ensuring the Correct Results for Dimension-Only Queries
  • Selecting a Predetermined Fact Table Source
  • Specifying a Default Join Path Between Dimension Tables

Module 16: Importing Metadata from Multidimensional Data Sources

  • Importing a Multidimensional Data Source into a Repository
  • Incorporating Horizontal Federation into a Business Model
  • Incorporating Vertical Federation into a Business Model
  • Adding Essbase Measures to a Relational Model
  • Displaying Data from Multidimensional Sources in Oracle BI Analyses and Dashboards

Module 17: Security

  • Exploring Oracle BI Default Security Settings
  • Creating Users and Groups
  • Creating Application Roles
  • Setting Up Object Permissions
  • Setting Row-Level Security (Data Filters)
  • Setting Query Limits and Timing Restrictions

Module 18: Cache Management

  • Restricting Tables as Non-Cacheable
  • Using Cache Manager
  • Inspecting Cache Reports
  • Purging Cache Entries
  • Modifying Cache Parameters and Options
  • Seeding the Cache

Module 19: Managing Metadata and Working with Service Instances

  • Using BI Application Archive (BAR) Files to Export and Import Service Instances
  • Managing BAR Files Using WebLogic
  • Scripting Tool (WLST) Commands
  • Managing Service Instances Using WLST Commands

Module 20: Using Administration Tool Utilities

  • Using the Various Administration Tool Utilities
  • Using BI Server XML API to Create XML Representation of Repository Metadata

Module 21: Multiuser Development

  • Setting Up a Multiuser Development Environment
  • Developing a Repository Using Multiple Developers
  • Tracking Development Project History

Module 22: Performing a Patch Merge

  • Comparing Repositories
  • Equalising Objects
  • Creating and Applying a Patch
  • Making Merge Decisions

Show moredown

Prerequisites

There are no prerequisites for this course.

Audience

This course is for IT Professionals, Developers, and Data Modellers who want to learn about Oracle BI or Oracle Technologies.

Oracle BI 12c Build Repositories Training​ Course Overview

This Oracle BI 12c build repositories training course is designed to equip delegates with the knowledge of how to build and verify the three layers of an Oracle Business Intelligence repository. In this course, delegates will learn about the basics of repositories: Oracle BI Architecture, repository structure, features, and functions, Oracle BI administration tool etc. They will also learn about repository physical layer. It represents the physical structure of the data sources to which the Oracle BI submits queries.

Delegates will learn how to construct the repository and import schemas. They will also learn how to design and build logical business models. This course describes how to build physical and logical joins, simple measures, and calculation measures. This course also teaches delegates how to build the presentation layer of a repository. In this course, delegates will gain an understanding of how to validate their work by creating and running analyses. They will also learn how to verify query results using the query log.

This 3-day course explains how to implement Oracle BI Server Security and manage the Oracle BI server cache. Furthermore, delegates will also learn how to set up a multi-user development environment.

Show moredown

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

Show moredown

Online Instructor-led (3 days)

Classroom (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 (1 days)

Classroom (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 (1 days)

Classroom (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 (3 days)

Classroom (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 (3 days)

Classroom (3 days)

Online Self-paced (24 hours)

Oracle Application Express (APEX) Training Course Outline

Module 1: Introduction to Oracle Application Express

  • APEX Concepts
  • APEX Main Components
  • Workspaces, Database Applications and Web sheet Applications
  • Creating a Workspace
  • The Workspace Administrator
  • Upgrading APEX
  • Logging into APEX
  • Running an Application

Module 2: SQL Workshop

  • Use APEX to Browse, Create and Modify Objects
  • Process Ad Hoc SQL Statements
  • Manage Scripts in APEX
  • Create, Run and Save SQL Queries

Module 3: Build a Database Application

  • Application Components
  • Create an Application
  • Create an Application from a Spreadsheet

Module 4: Create Reports

  • Creating Interactive Grids
  • Create Reports Using Wizards
  • Edit Report Attributes in Page Designer
  • Add Links to Reports
  • Create a Link to a Printer-Friendly version of a Report
  • Save and Print Reports in Different Formats

Module 5: Using Files

  • Uploading Images
  • Creating Cascading Stylesheet Files
  • Uploading Static Files
  • Adding an Image as an Application Logo
  • Adding a Reference to a Java Script File

Module 6: Pages and Regions

  • View Page Attributes in Page Designer
  • Edit Page Attributes in Page Designer
  • Create a Global Page
  • Create a New Region
  • View Region Attributes
  • Add Comments
  • Add a Title and a Logo

Module 7: Create Forms

  • Web Form Behaviour in APEX
  • Create a Form-Based on a Table
  • Create a Form-Based on a Procedure
  • Create a Form with a Report
  • Create a Tabular Form
  • Create an Editable Interactive Grid
  • Format a Form
  • Locking in APEX Forms

Module 8: Creating Lists of Values

  • Overview of Application Express Shared Components
  • Dynamic and Static Lists of Values
  • Create a Dynamic List of Values
  • Create a Static List of Values
  • Use a List of Values to Control Data in a Report
  • Create a Cascading List of Values

Module 9: Items and Buttons

  • Understand the Different Types of Items
  • Create Page Items
  • Create Application Items
  • Understand and Edit Item Attributes in Page Designer
  • Use Java Script with Item
  • Create and Edit Buttons

Module 10: Page Processing

  • Page Rendering and Page Processing
  • Create Computations
  • Validate Input Data
  • Process Data
  • Understand Application Branching
  • Create Conditional Branches

Module 11: Shared Components

  • Overview of Application Express Navigation Components
  • Manage the Navigation Menu
  • Create Navigation Bar Entries
  • Manage Breadcrumbs
  • Create and Use Lists and List Items
  • Creating and Using Shortcuts

Module 12: Display Dynamic Content

  • Create Hierarchical Trees
  • Creating and Editing Charts
  • Creating and Editing Calendars

Module 13: State and Debugging

  • Understand Session State
  • Set a Session State Value
  • Clear the Session State
  • Review the Session State
  • Review the Messages in Debug Mode
  • Enabling Feedback
  • Managing Feedback and Team Development

Module 14: Themes and Templates

  • Switch to a Different Theme
  • View Existing Templates
  • Understand and Manage Templates
  • Create a new Template
  • Add References to Cascading Stylesheet and JavaScript Files

Module 15: Dynamic Actions and Plug-In Components

  • Identify Plug-in Components and their Types
  • Plug in a Component
  • Create Dynamic Actions
  • Use a Plug-in in a Dynamic Action

Module 16: Building Websheet Applications

  • Websheet Applications and their Components
  • Create a Websheet Application
  • Enable SQL and PL/SQL in a Websheet Application
  • Add Sections and Pages to a Websheet Application
  • Add Links on a Websheet Page
  • Add a Data Grid to a Websheet Application
  • Create SQL Reports ion Websheet Applications
  • Add Annotations to a Websheet Application

Module 17: Implementing Security

  • Authentication and Authorisation
  • Provide an Authentication Scheme
  • Create an Authorisation Scheme Using Access Control
  • Enable and Configure Session State Protection

Module 18: Deploy an Application

  • Define Supporting Objects
  • Package an Application
  • Export and Import an Application
  • Install Supporting Objects

Show moredown

Prerequisites

There are no formal prerequisites for this course.

Audience

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

Oracle Application Express (APEX) Training​ Course Overview

Oracle Application Express is the low code web application development tool for the Oracle database. It enables delegates or users to design, develop, and deploy, responsive, the database-driven application either in cloud or on-premises. This course is designed to provide knowledge of how to build web-based applications for an Oracle database and websheets for managing structured and unstructured data.

This course teaches delegates how to develop an Apex web application, create reports, create interactive grids, and create forms. They will also gain an understanding of how to use a page designer to manage web pages and regions in the apex application. Delegates will acquire knowledge of how to use cascading stylesheets and JavaScript in Apex applications. They will also learn how to add graphs and charts to an apex application. This course teaches delegates how to add dynamics actions to the Apex application, add page processes to the Apex application, and manage database objects from within Apex. They will also acquire knowledge of how to build queries of database objects and deploy an Apex application as a packaged application.

This 3-day course explains how to manage apex users and groups, load and unload data, deploy an Apex application, develop an Apex websheet and create data grids and links in an Apex websheet.

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 01344 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 the United Kingdom
The Knowledge Academy is the Leading global training provider in the world for Oracle Training.
The price for Oracle Training certification in the United Kingdom starts from £2495.

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