Oracle Training

Online Instructor-led (3 days)

Online Self-paced (24 hours)

Oracle SQL Fundamentals Course Outline

Module 1: Relational Database Concepts

  • Introduction to Relational Database
  • Keys in SQL
  • SQL Syntax

Module 2: Using SQL*Plus

  • SQL*Plus
  • Working with SQL*Plus

Module 3: Using SQL Developer

  • SQL Developer Concepts
  • SQL Developer User Interface

Module 4: Retrieving Data with the Select Statement

  • Using the Select Statement
  • SELECT Statement
  • SQL Statement

Module 5: Aggregate Functions

  • Aggregate Function Overview
  • AVG Function
  • SUM Function
  • MAX Function
  • MIN Function

Module 6: Joining Tables

  • Joins in SQL
  • How to Join Two Tables?

Module 7: Numeric, Character and Date Functions

  • Functions in SQL
  • ABS
  • ACOS
  • CEIL
  • ASIN ()
  • ATAN ()
  • Character Functions
  • INITCAP
  • ASCII
  • Date Functions
  • CURRENT_DATE
  • LAST_DAY
  • NEXT_DAY
  • MONTHS_BETWEEN
  • DBTIMEZONE
  • EXTRACT

Module 8: Conversions and Miscellaneous

  • Conversion Functions in SQL
  • Different Functions

Module 9: SQL Parameters

  • Parameter Declaration
  • Keyword and Parameter Descriptions

Module 10: Using Subqueries

  • Using Subqueries
  • Subqueries with the INSERT Statement
  • Deleting a Row

Module 11: Managing Data

  • Database Management
  • Monitoring Databases
  • Administering Databases

Module 12: Managing Tables

  • Guidelines for Table Management
  • Creating Tables
  • Creating a Temporary Table
  • Loading Tables
  • Automatically Collecting Statistics on Tables
  • Creating a Table
  • Alter Table
  • Altering Tables
  • Dropping or Truncating Tables
  • Managing External Tables
  • Creating External Tables
  • Altering External Tables
  • Dropping External Tables
  • Viewing Information About Tables

Module 13: Managing Indexes and Views

  • About Indexes
  • About Views
  • Create a View

Module 14: Managing Sequences and Synonyms

  • About Sequences
  • Creating Sequences
  • Altering Sequences
  • Dropping Sequences
  • About Synonyms
  • Creating Synonyms
  • Dropping Synonyms

Module 15: Retrieve Data Using Subqueries

  • Types of Subqueries
  • IN and NOT IN Subqueries
  • Retrieving Data

Module 16: Hierarchical Queries

  • Hierarchical Queries Overview
  • Hierarchical Query Clause

Module 17: Enhanced grouping features

  • Grouping
  • Syntax of GROUP

Module 18: Manage Large Data Sets

  • Managing Very Large Databases
  • Benefits of Partitioning

Module 19: Date, Time, and Time Zone Support

  • Introduction to Time Zone Support
  • Datetime and Interval Datatypes
  • Datetime Datatypes
  • Interval Datatypes

Module 20: Regular Expression Support

  • Introduction to Regular Expressions
  • Implementation of Oracle Database Regular Expressions

Module 21: Manage Objects with the Data Dictionary

  • Introduction to Data Dictionary
  • Structure of Data Dictionary
  • How the Data Dictionary is Used?

Module 22: Manage Schema Objects

  • Introduction to Schema Objects
  • Schema Object Management Privileges

Show moredown

Who should attend this Oracle SQL Fundamentals Course?

The Oracle SQL Fundamentals Course is designed for individuals who want to develop a solid understanding of SQL (Structured Query Language) using Oracle's Database Management System. This Oracle Training Course can benefit a wide range of professionals, including:

  • Database Baeginners
  • Database Developers
  • Database Administrators
  • Business Analysts
  • Software Developers
  • Data Scientists
  • IT Professionals

Prerequisites of the Oracle SQL Fundamentals Course

There are no formal prerequisites for attending the Oracle SQL Fundamentals Course. However, a prior understanding of databases and exposure to Information Technology would be helpful for delegates. 

Oracle SQL Fundamentals Course Overview

Oracle SQL Fundamentals is a comprehensive introduction to the Structured Query Language (SQL), the industry-standard language for interacting with relational databases. This course provides a solid foundation in SQL concepts and syntax, enabling delegates to effectively query, manipulate, and manage data stored in Oracle databases.

Proficiency in Oracle SQL is crucial for anyone working with Oracle databases, including Database Developers, Database Administrators, Data Analysts, and business users. It empowers individuals to access, analyse, and extract valuable insights from data, supporting informed decision-making and enhancing business operations.

This intensive 3-day Oracle Training empowers us to teach delegates the fundamental concepts of SQL. During this training, representatives will thoroughly understand database management, which includes monitoring, administering, and maintaining a database and its groups in the enterprise. They will also acquire knowledge of sequential numbers produced by the sequence generator to automatically generate unique primary keys and coordinate keys across multiple rows or tables.

Course Objectives

  • To understand the fundamentals of relational databases and the SQL language
  • To create and modify database tables using DDL statements
  • To insert, update, and delete data using DML statements
  • To retrieve data using SELECT statements with various clauses
  • To use single-row functions to enhance query results
  • To apply aggregate functions to summarise data
  • To combine data from multiple tables using joins
  • To utilise subqueries and set operators for advanced data manipulation

After completing this Oracle Course, delegates can create Oracle SQL statements to query database tables and use standard aggregate functions. They can also implement extended SQL functions and perform flashback operations.

Show moredown

What’s included in this Oracle SQL Fundamentals Course?

  • World-Class Training Sessions from Experienced Instructors  
  • Oracle SQL Fundamentals Certificate
  • Digital Delegate Pack

Show moredown

Online Instructor-led (3 days)

Online Self-paced (24 hours)

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

Module 1: Installing and Configuring Oracle Database

  • Steps for Installing and Configuring the Oracle Database

Module 2: Administering an Oracle Database

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

Module 3: Understanding Network Configuration

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

Module 4: Creating and Managing Database Storage Structures

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

Module 5: Managing Redo Log Files and Control Files

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

Module 6: Managing Schema Objects

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

Module 7: Managing Users, Profiles, Privileges and Roles

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

Module 8: Managing Undo Data and Temporary Segments

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

Module 9: Monitoring and Resolving Lock Conflicts

  • Preparing for Conflict Resolution
  • Monitoring Locks

Module 10: Maintaining Database Security

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

Module 11: Monitoring General Database State and Workload

  • Steps to Monitoring General Database State and Workload

Module 12: Oracle Data Pump

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

Module 13: Backing Up and Recovering the Database

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

Show moredown

Who should attend this Oracle Database 11g Release 2 DBA - Part I Course?

The Oracle Database 11g Release 2 DBA - Part I Course is intended for individuals who are interested in becoming proficient Database Administrators (DBAs) and are seeking to enhance their skills and knowledge in managing Oracle databases. This Oracle Training Course can benefit a wide range of professionals, including:

  • Application Developers
  • Aspiring Database Developers
  • System Administrators
  • Data Analysts
  • IT Professionals
  • Cloud Database Specialists
  • Backup and Recovery Specialists

Prerequisites of the Oracle Database 11g Release 2 DBA - Part I Course

There are no formal prerequisites for this Oracle Database 11g Release 2 DBA - Part I Training. However, a basic understanding of Oracle SQL would prove to be beneficial for delegates.

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

Oracle Database 11g Release 2 DBA - Part I is a comprehensive training designed to provide IT professionals with the fundamental knowledge and skills required to administer Oracle Database 11g Release 2 databases. This training covers various topics, including database installation, configuration, management, troubleshooting, and performance optimisation.

Proficiency in Oracle Database 11g Release 2 Administration is essential for IT professionals managing Oracle databases in production environments. This training is ideal for Database Administrators, System Administrators, and other IT professionals who want to learn how to manage Oracle Database 11g Release 2 databases effectively.

This intensive 3-day Oracle Training will help delegates develop the skills and knowledge to administer Oracle Database 11g Release 2 databases successfully. Delegates will learn how to install and configure Oracle Database 11g Release 2, manage database objects, monitor and troubleshoot database performance, and perform database backups and recovery.

Course Objectives

  • To understand the fundamentals of Oracle Database 11g Release 2 architecture
  • To learn how to install and configure Oracle Database 11g Release 2
  • To manage database objects, such as tables, indexes, and views
  • To monitor and troubleshoot database performance
  • To perform database backups and recovery
  • To learn about Oracle Enterprise Manager Database Control
  • To understand Oracle Database 11g Release 2 security concepts

After completing this Oracle Training, delegates will be proficient in the installation and configuration processes of Oracle Database 11g Release 2 and have an in-depth understanding of the database. They will also receive a certificate which will attest to their Oracle Database 11g Release 2 administration knowledge and skills.

Show moredown

What’s included in this Oracle Database 11g Release 2 DBA - Part I Course?

  • World-Class Training Sessions from Experienced Instructors  
  • Oracle Database 11g Release 2 DBA - Part I Certificate
  • Digital Delegate Pack

Show moredown

Online Instructor-led (2 days)

Online Self-paced (16 hours)

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

Module 1: Backup and Disaster Recovery

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

Module 2: Archivelog and Nonarchivelog

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

Module 3: Managing Memory

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

Module 4: Recovery Manager

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

Module 5: Flashback Technology

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

Module 6: Reviewing and Diagnosing Databases

  • Database Logs

Module 7: Monitoring and Improving Database Performance

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

Module 8: Controlling Database Resources

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

Module 9: Automating Tasks with Scheduler

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

Show moredown

Who should attend this Oracle Database 11g Release 2 DBA - Part II Course?

The Oracle Database 11g Release 2 DBA - Part II Training Course is designed for individuals who have a foundational understanding of Oracle databases and have completed the Part I Course. This Oracle Training Course can benefit a wide range of professionals, including:

  • Experienced Database Administrators
  • Oracle Application Developers
  • IT Managers
  • Database Developers
  • System Administrators
  • Security Specialists
  • Data Warehouse Administrators

Prerequisites of the Oracle Database 11g Release 2 DBA - Part II Course

Candidates are required to have attended the Oracle Database 11g Release 2 DBA - Part I Course, as well as have a basic understanding of Oracle SQL, before pursuing this Oracle Course.

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

Oracle Database 11g Release 2 DBA - Part II is an advanced training course that delves into the intricacies of database backup and recovery strategies. This comprehensive training equips Database Administrators and technical support staff with the knowledge and skills to safeguard and restore Oracle databases effectively.

Proficiency in Oracle Database 11g Release 2 DBA - Part II is crucial for database professionals who manage mission-critical databases. With data's increasing volume and complexity, ensuring data integrity and availability is paramount. This training empowers database professionals to design, implement, and execute robust backup and recovery plans, minimising downtime and data loss.

In The Knowledge Academy’s intensive 2-day Oracle Database 11g Release 2 DBA - Part II Training, delegates will gain in-depth knowledge of solutions and strategies for Oracle backup and recovery. They will also learn about restoring and recovering database files, previewing a database restore and recovery, and healing the whole database. Our highly professional trainers with years of experience in teaching such courses will conduct this training course and help you understand it.

Course Objectives

  • To understand the principles of database backup and recovery
  • To identify and evaluate various backup and recovery strategies
  • To implement Oracle Recovery Manager (RMAN) for effective backup and recovery
  • To utilise Oracle Flashback technologies for point-in-time recovery
  • To configure and manage Oracle Data Guard for disaster recovery
  • To monitor and troubleshoot backup and recovery operations
  • To optimise database performance and resource utilisation
  • To enhance database security and compliance

After completing this Oracle Training, delegates will receive a certificate of completion, validating their proficiency in database backup and recovery strategies. This certification enhances their professional credentials and demonstrates their expertise in this critical area of database administration.

Show moredown

What’s included in this Oracle Database 11g Release 2 DBA - Part II Course?

  • World-Class Training Sessions from Experienced Instructors  
  • Oracle Database 11g Release 2 DBA - Part II Certificate
  • Digital Delegate Pack

Show moredown

Online Instructor-led (2 days)

Online Self-paced (16 hours)

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

Module 1: Application Containers and Applications

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

Module 2: Security in PDBs

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

Module 3: PDBs Creation Using New Methods

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

Module 4: PDBs Recovery and Flashback

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

Module 5: Performance in PDBs

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

Module 6: Upgrade and Other Operations in PDBs

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

Module 7: Privileges and User Profiles

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

Module 8: Unified Auditing

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

Module 9: Data Redaction

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

Module 10: Data Encryption

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

Module 11: Transparent Sensitive Data Protection

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

Module 12: Availability Enhancements

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

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

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

Module 14: In-Memory Column Store

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

Module 15: SQL Tuning

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

Module 16: Resource Manager and Other Performance Enhancements

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

Module 17: Partitioning

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

Module 18: Manageability

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

Module 19: Diagnosability

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

Module 20: Oracle Database Cloud Services

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

Module 21: SQL Enhancements

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

Show moredown

Who should attend this Oracle Database 12c R2: New Features for 12c R1 Administrators Ed 1 Course?

The Oracle Database 12c R2: New Features for 12c R1 Administrators Ed 1 Course is intended for individuals who have experience and familiarity with Oracle Database 12c Release 1 (12c R1) and wish to upgrade their knowledge to Oracle Database 12c Release 2 (12c R2). This Oracle Training Course can benefit a wide range of professionals, including:

  • Database Administrators
  • Database Professionals
  • IT Personnel
  • System Administrators
  • Technical Managers
  • Database Developers
  • Data Architects

Prerequisites of the Oracle Database 12c R2: New Features for 12c R1 Administrators Ed 1 Course

There are no formal prerequisites for attending the Oracle Database 12c R2: New Features for 12c R1 Administrators Ed 1 Course. However, a prior understanding of Oracle Database 12c would be helpful for delegates.

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

Oracle Database 12c R2: New Features for 12c R1 Administrators is a 1-day training course that introduces Oracle Database 12c Release 2 (12cR2) features to Oracle Database Administrators already familiar with Oracle Database 12c Release 1 (12cR1). This training covers many new features, including pluggable databases, application containers, unified auditing, and In-Memory Column-Store enhancements.

Proficiency in Oracle Database 12c R2 is essential for Oracle Database Administrators who want to manage and maintain Oracle Database 12c R2 databases. This training is ideal for Oracle Database Administrators who are already familiar with Oracle Database 12c R1 and want to learn about the new features in Oracle Database 12c R2.

In this intensive 2-day Oracle Database 12c R2: New Features for 12c R1 Administrators Ed 1 training, delegates will thoroughly understand how to create unified auditing policies for operations in application containers and easily create users in application containers. During this training, delegates will learn how to create a local UNDO tablespace at the PDB level. Our highly experienced trainers will deliver this training course, who will put in their best efforts to make delegates understand things easily.

Course Objectives

  • To understand the new features and enhancements of Oracle Database 12c R2
  • To learn how to use the new features to improve the performance, scalability, and security of Oracle databases
  • To gain hands-on experience with the latest features through a series of practical exercises
  • To be able to apply the new features to their own Oracle databases
  • To prepare for the Oracle Database 12c R2 Certified Associate certification exam
  • To manage the procedure of database deployment, backup, and recovery automatic
  • To get in touch with how to manage the PDB lockdown profiles

After completing this Oracle Certification Training, delegates will be updated about every aspect of the Oracle Database 12c R2 and receive a certificate, which demonstrates to employers that delegates have the skills and knowledge to manage Oracle Database 12cR2 effectively.

Show moredown

What’s included in this Oracle Database 12c R2: New Features for 12c R1 Administrators Ed 1 Course?

  • World-Class Training Sessions from Experienced Instructors  
  • Oracle Database 12c R2: New Features for 12c R1 Administrators Ed 1 Certificate
  • Digital Delegate Pack

Show moredown

Online Instructor-led (3 days)

Online Self-paced (24 hours)

Oracle Database 12c: Administration Course Outline

Module 1: Introduction to Oracle Database 12c

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

Module 2: Oracle Database Architecture

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

Module 3: Administer a Database Instance

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

Module 4: Configure the Oracle Network Environment

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

Module 5: Storage Structures

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

Module 6: Manage Users

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

Module 7: Manage Profiles and Resources

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

Module 8: Manage Privileges

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

Module 9: Database Auditing

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

Module 10: Data Concurrency and Lock Conflicts

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

Module 11: Proactive Database Maintenance

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

Module 12: Performance Management

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

Module 13: SQL Tuning

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

Module 14: Moving Data

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

Module 15: Automate Tasks with the Scheduler

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

Module 16: Managing Resources with Resource Manager

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

Module 17: Manage Space

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

Module 18: Oracle Support

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

Show moredown

Who should attend this Oracle Database 12c: Administration Course?

The Oracle Database 12c: Administration Course is designed for individuals who want to gain expertise in administering Oracle Database 12c, a powerful and widely used Relational Database Management System. This Oracle Training Course can benefit a wide range of professionals, including:

  • Aspiring Oracle 12c Database Administrators
  • Oracle Developers
  • System Administrators
  • Database Administrators
  • Data Analysts
  • IT Managers
  • Business Intelligence Specialists
  • Application Developers

Prerequisites of the Oracle Database 12c: Administration Course

There are no formal prerequisites for attending the Oracle Database 12c: Administration Course. However, prior knowledge of PL/SQL would be highly beneficial for delegates.

Oracle Database 12c: Administration Course Overview

Oracle Database 12c is the latest version of Oracle's flagship database management system, offering significant enhancements in performance, scalability, and security. This comprehensive 3-day training course thoroughly introduces Oracle Database 12c administration, covering essential concepts, best practices, and hands-on exercises to equip delegates with the skills and knowledge.

Mastering Oracle Database 12c Administration is crucial for Database Administrators (DBAs), System Administrators, and IT professionals who must ensure the smooth operation and performance of Oracle Database 12c environments. DBAs play a critical role in ensuring the availability, implementation, and security of Oracle databases, and they are in high demand by businesses of all sizes.

This intensive 3-day Oracle Training offered by The Knowledge Academy will equip delegates with the expertise to confidently manage and administer Oracle Database 12c environments. Delegates will gain a deep understanding of Oracle Database architecture, storage structures, network configuration, user management, performance monitoring, and backup and recovery techniques.

Course Objectives

  • To understand Oracle Database 12c architecture and its key components
  • To create and manage Oracle Database 12c instances
  • To configure storage structures for optimal performance
  • To establish a secure Oracle Network environment
  • To create and manage Oracle Database users and roles
  • To effectively monitor Oracle Database performance and identify performance bottlenecks
  • To implement comprehensive backup and recovery strategies for Oracle Database 12c

After completing this Oracle Training, delegates will receive a certificate of attendance and be well-equipped to tackle the challenges of administering Oracle Database 12c environments. They will gain the skills and knowledge necessary to ensure their Oracle Database systems' availability, performance, and security.

Show moredown

What’s included in this Oracle Database 12c: Administration Course?

  • World-Class Training Sessions from Experienced Instructors  
  • Oracle Database 12c: Administration Certificate
  • Digital Delegate Pack

Show moredown

Online Instructor-led (3 days)

Online Self-paced (24 hours)

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

Module 1: Oracle Database Multitenant Architecture Overview

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

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

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

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

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

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

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

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

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

Module 6: Migrate Data with Data Pump

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

Module 7: Enhancements to Database Auditing

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

Module 8: Enhancements to Privileges and Profiles

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

Module 9: New RMAN Features

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

Module 10: Miscellaneous New Features

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

Module 11: SQL and PL/SQL Enhancements

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

Module 12: Performance Tuning New Features

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

Module 13: Big Data and Data Warehouse New Features

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

Module 14: Partitioning Enhancements

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

Module 15: Data Pump Enhancements

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

Module 16: SQL*Loader and External Table Enhancements

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

Module 17: Database Diagnostic New Features

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

Module 18: Data Guard New Features

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

Module 19: Active Data Guard New Features

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

Module 20: Transparent Sensitive Data Protection

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

Module 21: Application Continuity Enhancements

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

Show moredown

Who should attend this Oracle Database 12cR2, 18c and 19c New Features for Administrators Course?

The Oracle Database 12cR2, 18c, and 19c New Features for Administrators Course is designed for individuals who have a background or role in Oracle Database Administration and Management. This Oracle Training Course can benefit a wide range of professionals, including:

  • Database Administrators (DBAs)
  • System Administrators
  • Database Developers
  • IT Managers and Decision Makers
  • Technical Consultants
  • Database Architects
  • Data Analysts

Prerequisites of the Oracle Database 12cR2, 18c and 19c New Features for Administrators Course

There are no formal prerequisites for attending the Oracle Database 12cR2, 18c and 19c New Features for Administrators Course.

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

This Oracle Database Course focuses on the new features introduced in Oracle Database 12cR2, 18c, and 19c, empowering Database Administrators to manage and optimise their database environments effectively. It covers critical concepts such as multitenant architecture, container databases, enhanced auditing, privilege analysis, data redaction, performance tuning, and Big Data and Data Warehousing enhancements.

Proficiency in Oracle Database 12cR2, 18c, and 19c is essential for Database Administrators responsible for managing and maintaining Oracle database environments. This training is designed for experienced Oracle Database Administrators who want hands-on experience with the latest features and enhancements.

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

Course Objectives

  • To understand the concepts of multitenant architecture and container databases
  • To implement and manage Oracle Database 12cR2, 18c, and 19c features
  • To configure and utilise enhanced auditing and privilege analysis features
  • To protect sensitive data using data redaction and encryption enhancements
  • To leverage Big Data and Data Warehousing enhancements for advanced analytics
  • To troubleshoot and diagnose database issues using Oracle Database 12cR2, 18c, and 19c tools
  • To implement disaster recovery and high availability solutions using Oracle Data Guard

Upon completion of the Oracle Database 12cR2, 18c, and 19c New Features for Administrators Course, delegates will gain a comprehensive understanding of the latest features and enhancements in Oracle Database versions, enabling them to efficiently leverage these advancements in their database management tasks.

Show moredown

What’s included in this Oracle Database 12cR2, 18c and 19c New Features for Administrators Course?

  • World-Class Training Sessions from Experienced Instructors  
  • Oracle Database 12cR2, 18c and 19c New Features for Administrators Certificate
  • Digital Delegate Pack

Show moredown

Online Instructor-led (3 days)

Online Self-paced (24 hours)

Oracle Database 19c Administration Training Course Outline

Module 1: Introduction to Oracle Database

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

Module 2: Oracle Database Architecture

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

Module 3: Administer a Database Instance

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

Module 4: Configure the Oracle Network Environment

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

Module 5: Storage Structures

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

Module 6: Manage Users

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

Module 7: Manage Privileges

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

Module 8: Database Auditing

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

Module 9: Data Concurrency and Lock Conflicts

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

Module 10: Undo Management

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

Module 11: Backup and Recovery Configuration

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

Module 12: Proactive Database Maintenance

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

Module 13: Performance Management

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

Module 14: SQL Tuning

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

Module 15: Moving Data

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

Module 16: Managing Resources with Resource Manager

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

Module 17: Automate Tasks with the Scheduler

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

Module 18: Manage Space

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

Module 19: Oracle Support

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

Show moredown

Who should attend this Oracle Database 19c Administration Training Course?

The Oracle Database 19c Administration Training is designed for individuals who are looking to develop expertise in managing Oracle Database 19c environments. This Oracle Training can benefit a wide range of professionals, including:Database Administrators (DBAs)

  • System Administrators
  • Oracle Database Developers
  • IT Managers
  • Technical Consultants
  • Data Security Officers
  • Data Analysts

Prerequisites of the Oracle Database 19c Administration Training Course

There are no formal prerequisites for attending the Oracle Database 19c Administration Course.

Oracle Database 19c Administration Training Course Overview

The Oracle Database 19c Administration Training equips individuals with the skills and knowledge to manage and maintain Oracle Database 19c environments effectively. This comprehensive training delves into the intricacies of database creation, configuration, security, performance tuning, and recovery, ensuring that delegates are well-prepared to handle the demands of modern database administration.

Proficiency in Oracle Database 19c Administration is a highly sought-after skill in the IT industry. As organisations increasingly rely on Oracle databases to store and manage their critical data, the demand for skilled Database Administrators grows. This training is for IT professionals, Database Administrators, and System Administrators who aspire to master Oracle Database 19c Administration.

This intensive 3-day Oracle Training delivered by The Knowledge Academy, will teach delegates how to administer, monitor, tune, and troubleshoot an Oracle database. During this training, delegates will learn how to ensure the company’s data integrity and availability within the Oracle environment. They will also learn how to use the job scheduler and configure a database for backup and recovery.   

Course Objectives

  • To understand the fundamental concepts of Oracle Database 19c architecture and components
  • To gain hands-on experience in creating and managing Oracle Database 19c instances
  • To master user administration techniques and implement robust security measures
  • To configure and manage Oracle Net Services for effective database connectivity
  • To optimise database performance using various tuning techniques and tools
  • To implement and manage Pluggable Databases (PDBs) for multitenant environments
  • To employ automated maintenance tasks to streamline database operations
  • To monitor and troubleshoot database performance issues effectively

Upon completion of an Oracle Training Course, delegates will acquire the essential skills and knowledge needed to efficiently manage and maintain Oracle Database systems, enhancing their career prospects in the field of database administration.

Show moredown

What’s included in this Oracle Database 19c Administration Training Course?

  • World-Class Training Sessions from Experienced Instructors  
  • Oracle Database 19c Administration Certificate
  • Digital Delegate Pack

Show moredown

Online Instructor-led (2 days)

Online Self-paced (16 hours)

Oracle Database 18c Administration Training​ Course Outline

Module 1: Oracle Database Architecture Overview

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

Module 2: Oracle Database Cloud Overview

  • Understand Features and Tooling
  • Automated Database Overview

Module 3: Oracle Database Access

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

Module 4: Managing Database Instances

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

Module 5: Oracle Net Services

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

Module 6: User Security for Administrator

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

Module 7: Create a PDBs in Oracle

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

Module 8: Creating Master Encryption Keys for PDBs

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

Module 9: Create and Manage Tablespaces

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

Module 10: Managing Storage Space

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

Module 11: Undo Data and Moving Data Overview

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

Module 12: Backup and Recovery Concepts

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

Module 13: Configure Backup and Recovery

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

Module 14: Creating Database Backups

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

Module 15: Monitoring and Tuning Database Strategies

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

Module 16: SQL Tuning Overview

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

Show moredown

Who should attend this Oracle Database 18c Administration Training Course?

The Oracle Database 18c Administration Course is designed for individuals who wish to develop expertise in administering Oracle Database 18c. This Oracle Training Course can benefit a wide range of professionals, including:

  • Database Administrators (DBAs)
  • System Administrators
  • Database Developers
  • IT Managers
  • IT Professionals
  • Technical Consultants
  • Database Architects

Prerequisites of the Oracle Database 18c Administration Training Course

There are no formal prerequisites for attending the Oracle Database 18c Administration Training Course. However, prior knowledge of SQL and PL/SQL packages would be helpful for delegates.

Oracle Database 18c Administration Training Course Overview

Oracle Database 18c Administration Training is a comprehensive course designed to equip individuals with the skills and knowledge to effectively manage and maintain Oracle Database 18c environments. This Oracle Training Course covers a wide range of topics, from the fundamentals of database architecture to advanced performance tuning techniques.

Proficiency in Oracle Database 18c Administration is essential for IT professionals managing and maintaining Oracle databases. This includes Database Administrators, System Administrators, and Application Developers. As Oracle databases grow in complexity, the demand for skilled Oracle Database Administrators is also increasing.

In this intensive 2-day Oracle Database 18c Administration Training Course, delegates will gain in-depth knowledge of Oracle Database 18c Administration and how to configure Oracle databases. During this training, delegates will learn how to manage processes that enable multiple applications and users to connect with a single instance of a database. This Oracle Training Course will be led by our highly professional trainers, who have years of teaching experience and will help you understand the subject in detail.

Course Objectives

  • To understand the architecture of an Oracle Database 18c instance
  • To install and configure Oracle Database 18c
  • To manage users and roles
  • To create and manage tables and other database objects
  • To perform backups and recoveries
  • To troubleshoot common problems
  • To learn about new features in Oracle Database 18c

After completing this Oracle Course, delegates will be able to create and manage Database Cloud Service deployments, configure the database to support an application, manage the database security, and implement auditing. They can also create databases with DBCA and the CREATE DATABASE statement.

Show moredown

What’s included in this Oracle Database 18c Administration Training Course?

  • World-Class Training Sessions from Experienced Instructors   
  • Oracle Database 18c Administration Certificate
  • Digital Delegate Pack

Show moredown

Online Instructor-led (1 days)

Online Self-paced (8 hours)

Oracle SQL Advanced Training​ Course Outline

Module 1: Access Control

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

Module 2: Retrieve Data Using Subqueries

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

Module 3: Hierarchical Queries

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

Module 4: Enhanced Grouping Features

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

Module 5: Analytic Queries

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

Module 6: Manage Large Data Sets

  • Multi-Table Inserts
  • Merging Data into a Table

Show moredown

Who should attend this Oracle SQL Advanced Training Course?

The Oracle SQL Advanced Training Course is ideally suited for professionals who possess a solid foundation in SQL and are seeking to enhance their skills to a more advanced level. This Oracle Training Course can benefit a wide range of professionals, including:

  • Database Developers
  • Database Administrators
  • Business Analysts
  • Data Scientists
  • Application Developers
  • Technical Managers
  • IT Professionals

Prerequisites of the Oracle SQL Advanced Training Course

There are no formal prerequisites for attending the Oracle SQL Advanced Course.

Oracle SQL Advanced Training Course Overview

Oracle SQL Advanced Training is a comprehensive 1-day training that delves into the intricacies of advanced SQL concepts and techniques, empowering you to harness the full potential of Oracle databases. This training is designed for those with a solid SQL foundation and who are eager to elevate their skills to an expert level.

Proficiency in advanced Oracle SQL is a highly sought-after skill in the IT industry. It opens doors to lucrative career opportunities in database administration, data analysis, and software development. Whether you're a seasoned professional or a recent graduate, mastering advanced SQL will give you a competitive edge in the job market.

This intensive 1-day Oracle SQL Advanced Training provides delegates with SQL statements and how to create analytic and hierarchical queries. During this training, delegates will learn how to implement GROUPING and GROUPING_ID functions. They will learn how to create and use external tables, perform flashback operations, and control user access to database objects. This training will be led by our highly skilled instructors, who have years of teaching experience in Oracle Courses.

Course Objectives

  • To confidently utilise subqueries to enhance data retrieval and manipulation
  • To master hierarchical queries for complex data relationships
  • To effectively leverage indexes for improved query performance
  • To optimise SQL code for enhanced efficiency and scalability
  • To gain insights into advanced database concepts and features
  • To apply advanced SQL techniques to real-world scenarios
  • To enhance problem-solving skills and analytical thinking
  • To prepare for advanced Oracle Certifications

After completing this training, delegates will be able to define data in a database and manipulate that data. They will also be able to manage the hierarchy in a database and build a new sequence object.

Show moredown

What’s included in this Oracle SQL Advanced Training Course?

  • World-Class Training Sessions from Experienced Instructors  
  • Oracle SQL Advanced Certificate
  • Digital Delegate Pack

Show moredown

Online Instructor-led (2 days)

Online Self-paced (16 hours)

Oracle Program Training with PL/SQL Course Outline

Module 1: PL/ SQL and Its Components

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

Module 2: Program Logic Essentials

  • Statement for Program
  • Loops for Program

Module 3: Cursors in PL/SQL Overview

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

Module 4: EXCEPTIONS and NESTED Blocks

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

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

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

Module 6: Triggers Overview

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

Module 7: Procedures Overview

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

Module 8: Functions Overview 

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

Module 9: Packages Overview 

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

Module 10: PL/SQL Records and Tables in Packages

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

Module 11: Cursor Variables Overview

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

Module 12: Managing Dependencies

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

Module 13: Native Compilation and Compile-Time Warnings

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

Module 14: Oracle - Supplied Packages Overview

  • Introduction to Oracle-Supplied Packages
  • Understand Packages Types

Show moredown

Who should attend this Oracle Program Training with PL/SQL Course?

The Oracle Program Training with PL/SQL Course is designed for individuals who want to become proficient in Oracle Database and its associated programming language, PL/SQL. This training course will benefit a variety of professionals, including:

  • Database Developers and Administrators
  • Software Developers
  • Application Developers
  • Business Analysts
  • Data Analysts
  • DevOps Engineers
  • IT Professionals
  • Technical Consultants

Prerequisites of the Oracle Program Training with PL/SQL Course

There are no formal prerequisites to attend this Oracle Program Training with PL/SQL Course. However, a basic knowledge of database, SQL, programming, and database management system would be beneficial for the delegates.

Oracle Program Training with PL/SQL Course Overview

Oracle Program Training with PL/SQL is a comprehensive overview of PL/SQL, Oracle's powerful procedural extension language for SQL. Delegates will gain a thorough understanding of PL/SQL syntax, data types, control structures, and error handling. They will also learn to create and manage stored procedures, functions, packages, and triggers.

Proficiency in PL/SQL is essential for Oracle Developers and Database Administrators who want to enhance their skills and advance their careers. PL/SQL is a versatile language that can automate complex database tasks, improve application performance, and develop sophisticated database applications.

This intensive 2-day training provides delegates with a comprehensive knowledge of various basic to advanced concepts of SQL. Delegates will learn multiple concepts such as cursor operations, creating variables and assigning values, types of declaring records, nested records, etc. Our highly experienced trainers will conduct this training and provide delegates with in-depth knowledge of PL/SQL.

Course Objectives

  • To understand the fundamentals of PL/SQL and its role in Oracle database development
  • To gain proficiency in PL/SQL syntax, data types, control structures, and error handling
  • To learn how to create and manage stored procedures, functions, packages, and triggers
  • To understand the principles of code optimisation and performance tuning for PL/SQL applications
  • To be able to troubleshoot PL/SQL problems and resolve common errors
  • To gain hands-on experience in developing PL/SQL applications using Oracle Database 12c

After completing this Oracle Certification Training, delegates will receive a certificate which will attest to their proficiency in PL/SQL and ability to develop and deploy PL/SQL applications effectively.

Show moredown

What’s included in this Oracle Program Training with PL/SQL Course?

  • World-Class Training Sessions from Experienced Instructors   
  • Oracle Program Training with PL/SQL Certificate
  • Digital Delegate Pack

Show moredown

Online Instructor-led (3 days)

Online Self-paced (24 hours)

Oracle SQL & PL/SQL Fundamentals Course Outline

Module 1: Introduction

  • Oracle SQL & PL/SQL
  • RDBMS
  • SQL

Module 2: SQL: Data Definition Language

  • Introduction to DDL
  • Database
  • Views
  • Indexes
  • Synonyms

Module 3: SQL: Data Manipulation Language

  • Introduction to Data Manipulation Language
    • INSERT
    • UPDATE
    • DELETE

Module 4: SELECT Statement

  • Basic SELECT Statement
  • Comparison Conditions
  • Using the OR Condition
  • Using the LIKE Condition
  • Using the IN Condition
  • Using the ANY Condition
  • Using the ALL Condition
  • ORDER by Clause
  • Sorting by Multiple Columns
  • Aggregation and Grouping

Module 5: Joins

  • Joining Table Using Oracle Syntax
  • Unions and Subqueries

Module 6: SUB-QUERIES

  • Using a Subquery to Solve a Problem
  • Types of Subqueries
    • Single Row Subqueries
    • Multiple Rows Subqueries
    • Correlated Subquery

Module 7: SQL Functions

  • Introduction
  • Single Row Functions
  • Aggregate Functions

Module 8: PL/SQL

  • About PL/SQL
  • Benefits of PL/SQL
  • Benefits of Subprograms
  • Features of PL/SQL
  • Identifiers
  • PL/SQL Blocks
  • Syntax for Creating Functions
  • Advantages of User-Defined functions in SQL Expressions
  • Restrictions on SQL Functions
  • Removing Functions
  • Oracle PL/SQL Package
  • Removing Packages
  • PL/SQL Trigger
  • Guidelines for Designing Triggers
  • DML Trigger Components
  • SQL and PL/SQL
  • Using PL/SQL for Data Manipulation
  • Control Structures
  • PL/SQL Data Types
  • Errors and Exception Handling

Show moredown

Who should attend this Oracle SQL & PL/SQL Fundamentals Training Course?

The Oracle SQL & PL/SQL Fundamentals Training Course is designed to introduce individuals to the essentials of Oracle Database using SQL and PL/SQL. This training course is beneficial for a wide range of professionals, including:

  • IT Professionals
  • Technical Consultants
  • Business Analysts
  • Data Analysts
  • Software Developers
  • Database Administrators
  • Project Managers
  • Team Leaders

Prerequisites of the Oracle SQL & PL/SQL Fundamentals Course

There are no formal prerequisites to attend this Oracle SQL & PL/SQL Fundamentals Course. However, a basic knowledge of databases would be beneficial for the delegates.

Oracle SQL & PL/SQL Fundamentals Course Overview

Mastering the fundamentals of Oracle SQL and PL/SQL is crucial for anyone involved in data management, database administration, or application development. This comprehensive 3-day training delves into the core concepts of SQL, the structured query language used to interact with relational databases, and PL/SQL, the procedural language extension that enhances SQL's capabilities.

Proficiency in Oracle SQL and PL/SQL is highly sought after by a wide range of professionals, including Database Developers, Data Analysts, Data Architects, and Software Engineers. These skills are essential for designing, querying, and managing complex databases, enabling professionals to extract valuable insights and develop robust data-driven applications.

This intensive 3-day training will equip delegates with the essential knowledge and skills to utilise Oracle SQL and PL/SQL effectively. Delegates will gain a thorough understanding of SQL syntax, data manipulation techniques, and advanced query strategies. They will also learn how to create and implement PL/SQL procedures and functions, enabling them to automate complex tasks and enhance database efficiency.

Course Objectives

  • To understand the fundamental concepts of relational databases and Oracle Database architecture
  • To master SQL syntax and data manipulation techniques, including SELECT, INSERT, UPDATE, and DELETE statements
  • To construct complex queries using joins, subqueries, and set operations
  • To implement data integrity constraints such as primary keys, foreign keys, and constraints
  • To create and utilise PL/SQL procedures and functions for enhanced data manipulation
  • To handle control flow structures, including loops and conditional statements
  • To manage exceptions and errors in PL/SQL program units
  • To apply best practices for writing secure and efficient PL/SQL code

Upon completion of this Oracle Course, delegates will acquire a strong foundation in SQL and PL/SQL programming, equipping them with the essential skills to effectively retrieve, manipulate, and manage data within Oracle databases.

Show moredown

What’s included in this Oracle SQL & PL/SQL Fundamentals Course?

  • World-Class Training Sessions from Experienced Instructors   
  • Oracle SQL & PL/SQL Fundamentals Certificate
  • Digital Delegate Pack

Show moredown

Online Instructor-led (2 days)

Online Self-paced (16 hours)

Oracle 18c DBA Fundamentals​ Course Outline

Module 1: Getting Started with Database Administration

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

Module 2: Creating and Configuring an Oracle Database

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

Module 3: Starting Up and Shutting Down

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

Module 4: Managing Processes and Memory

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

Module 5: Managing Users and Securing the Database

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

Module 6: Monitoring the Database and Managing Diagnostic Data

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

Module 7: Managing Control Files

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

Module 8: Managing the Redo Log

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

Module 9: Managing Archived Redo Log Files

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

Module 10: Managing Tablespaces

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

Module 11: Managing Data Files and Temp Files

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

Module 12: Transporting Data and Managing Undo

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

Module 13: Using Oracle Managed Files

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

Module 14: Managing Views, Sequences, and Synonyms

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

Module 15: Managing Automated Database Maintenance Tasks

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

Module 16: Managing a Distributed Database

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

Show moredown

Who should attend this Oracle 18c DBA Fundamentals Training Course?

The Oracle 18c DBA Fundamentals Training Course is designed for individuals seeking to enhance their Database Management skills using Oracle 18c. This Oracle Training Course will benefit various professionals, including:

  • System Administrators
  • Database Administrators
  • Application Developers
  • IT Professionals
  • Business Analysts
  • Technical Consultants
  • IT Team Leaders

Prerequisites of the Oracle 18c DBA Fundamentals Course

There are no formal prerequisites to attend this Oracle 18c DBA Fundamentals Training Course. However, a basic understanding of Database concepts, SQL fundamentals, and operating systems would be beneficial for the delegates.

Oracle 18c DBA Fundamentals Course Overview

Oracle 18c DBA Fundamentals is a comprehensive 1-day training course designed to provide aspiring and experienced Database Administrators with the essential skills and knowledge to manage and maintain Oracle 18c databases effectively. This training covers various topics, including database creation and configuration, storage management, user administration, security, backup and recovery, and performance tuning.

Proficiency in Oracle 18c DBA Fundamentals is essential for Database Administrators who want to ensure the optimal performance, availability, and security of their Oracle 18c databases. This training is particularly beneficial for IT professionals new to Oracle database administration and those looking to refresh their skills and stay up-to-date with the latest features and functionality of Oracle 18c.

This intensive 2-day Oracle Training offered by The Knowledge Academy will help delegates understand the fundamental concepts and principles of Oracle 18c database administration. They will learn how to install and configure Oracle 18c databases, manage storage structures, create and manage users and privileges, implement security measures, perform backups and recoveries, and monitor and tune database performance.

Course Objectives

  • To understand the fundamentals of Oracle 18c database administration
  • To gain hands-on experience with Oracle 18c features and functionalities
  • To learn how to create and configure Oracle Courses
  • To manage Oracle 18c users, privileges, and roles
  • To implement effective performance monitoring strategies
  • To employ backup and recovery techniques for Oracle 18c databases
  • To troubleshoot common Oracle 18c database issues
  • To prepare for the Oracle Certified Professional (OCP) exam

Upon completion of an Oracle 18c DBA Fundamentals Course, delegates will have a solid foundational understanding of Oracle Database administration, enabling them to efficiently manage and support Oracle 18c databases.

Show moredown

What’s included in this Oracle 18c DBA Fundamentals Course?

  • World-Class Training Sessions from Experienced Instructors   
  • Oracle 18c DBA Fundamentals Certificate
  • Digital Delegate Pack

Show moredown

Online Instructor-led (2 days)

Online Self-paced (16 hours)

Oracle Accounts Payable Training Course Outline

Module 1: Payables Overview

  • Payables Workbenches
  • Multiple Organisation Access Control

Module 2: Suppliers

  • Suppliers Pages Reference
  • Reviewing and Adjusting Suppliers

Module 3: Invoices

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

Module 4: Expense Reports and Credit Cards

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

Module 5: Payments

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

Module 6: Accounting

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

Module 7: Resource Management and Reports

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

Module 8: Automatic Interest and Automatic Offsets

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

Module 9: Invoice, Payment, and Account Default Charts

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

 

Show moredown

Who should attend the Oracle Accounts Payable Training Course?

The Oracle Accounts Payable Training Course is designed to equip individuals with skills to effectively handle financial transactions, invoices, and managing Accounts Payable within an organisation using Oracle. This Oracle Training Course is beneficial for a wide range of professionals, including:

  • Accounts Payable Specialists
  • Financial Analysts
  • Accounts Managers
  • Auditors
  • Finance Managers
  • Business Administrators
  • Consultants and Advisors

Prerequisites of the Oracle Accounts Payable Training Course

There are no formal prerequisites to attend this Oracle Accounts Payable Training Course. However, a basic knowledge of accounting, business processes, and familiarity with financing would be beneficial for the delegates.

Oracle Accounts Payable Training Course Overview

Oracle Accounts Payable (AP) is a critical component of any organisation's financial management system, responsible for managing the process of paying suppliers for goods and services. Proficiency in Oracle AP is essential for ensuring timely and accurate payments, maintaining strong supplier relationships, and optimising cash flow.

Proficiency in Oracle AP is crucial for finance professionals, accounting clerks, and anyone involved in the procurement and payment process. Mastering Oracle AP enables users to efficiently manage the entire payables cycle, from creating invoices to processing payments, ensuring financial transparency and compliance.

This intensive 2-day Oracle Accounts Payable Training Course equips delegates with the core skills and techniques for payable Oracle accounts management. During this training, delegates will learn about locating and posting manual payments. They will also learn about types of vouchers, speed vouchers, review and approve vouchers, understand the post process for A/P, post vouchers, and many other essential topics.

Course Objectives

  • To understand the core concepts and terminology of Oracle AP
  • To learn how to create and manage suppliers in Oracle AP
  • To master the process of entering and processing invoices
  • To gain proficiency in matching invoices to purchase orders and receipts
  • To understand various payment methods and processes in Oracle AP
  • To generate key AP reports for analysis and decision-making
  • To identify and resolve common AP issues and errors
  • To implement best practices for efficient and effective AP management

After completing this training, delegates will receive a certificate demonstrating their proficiency in Oracle Accounts Payable. This valuable credential will enhance their professional profile and attest to their expertise in managing the payables cycle.

Show moredown

What’s included in this Oracle Accounts Payable Training Course?

  • World-Class Training Sessions from Experienced Instructors   
  • Oracle Accounts Payable Certificate
  • Digital Delegate Pack

Show moredown

Online Instructor-led (2 days)

Online Self-paced (16 hours)

Oracle Database DBA Performance Tuning & Management Training Course Outline

Module 1: Introduction to Oracle Performance Tuning

  • Performance Planning
  • Understanding Investment Options
  • Understanding Scalability
  • System Scalability
  • System Architecture
  • Hardware and Software Components
  • Application Design Principles
  • Deploying New Applications
  • Instance Tuning
  • Performance Principles
  • Baselines
  • Proactive Monitoring
  • Bottleneck Elimination
  • SQL Tuning
  • Query Optimiser and Execution Plans

Module 2: Using Application Tracing Tools

  • End-to-End Application Tracing
  • Using the trcsess Utility
  • Understanding SQL Trace and TKPROF

Module 3: SQL Optimiser

  • Optimiser Operations
  • Components of the Query Optimiser
  • Optimiser Access Paths
  • Joins
  • Execution Plans

Module 4: Sorts

  • Sort Merge Joins

Module 5: Indexes

  • Index Characteristics
  • Keys and Columns
  • Unique and Nonunique Indexes

Module 6: Advanced Indexes

  • Types of Indexes
    • Categories of Indexes

Module 7: Joins Operations

  • Joins
    • Join Conditions
    • Types of Join

Module 8: Sequences and Views

  • Managing Views
    • Creating Views
    • Replacing Views
    • Using Views in Queries
    • Updating a Join View
    • Altering Views
    • Dropping Views
  • Managing Sequences
    • Creating Sequences
    • Altering Sequences
    • Dropping Sequences

Module 9: Using Hints

  • Overview of Optimiser Hints

Module 10: Miscellaneous

  • SQL Tuning Tips
  • Array Size
  • Virtual Columns
  • WITH Clause
  • Shared Pool
  • Intelligent Cursor Sharing
  • Bind Variable Usage
  • Result Caching

Module 11: Basic Tuning Diagnostics

  • Performance Tuning Diagnostics, Features, and Tools
  • DB Time
  • Dynamic Performance Views
  • Database Statistics
  • Wait Events 
  • Using ADDM with Oracle Real Application Clusters

Module 12: Reduce the Cost of SQL Operations

  • Identify Invalid Objects
  • SQL Access Advisor
  • Row Migration
  • Manage Extents

Module 13: SQL Performance Analyser

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

Module 14: SQL Performance Management

  • Optimiser Statistics Collection
  • Gathering Statistics for Fixed Objects
  • Optimiser Statistics Advisor
  • Expression Statistics
  • Adaptive Query Optimisation
  • Adaptive Query Plans
  • Automatic SQL Tuning
  • SQL Tuning Advisor
  • SQL Access Advisor
  • SQL Plan Management

Module 15: Automatic Memory Management

  • Overview of Automatic Shared Memory Management
  • Dynamic SGA
  • Parameters for Sizing the SGA
  • Enable and Disable Automatic Shared Memory Management
  • Overview of Automatic Memory Management

Module 16: Tune the Shared Pool

  • Basic of Shared Pool
  • Latches and Mutexes
  • Avoiding Hard Parses
  • Pin the SQL in the Shared Pool Area
  • SHARED_POOL_SIZE and Automatic Storage Management
  • Data Dictionary

Module 17: Tune the Buffer Cache

  • About Data Base Buffer Cache
  • Database Smart Flash Cache
  • Full Database Caching

Module 18: Tune PGA and Temporary Space

  • Overview of the PGA
  • Oracle Memory Usage
  • Automatic PGA Memory Mode Configuration
  • Histograms
  • Temporary Tablespace Management
  • Temporary Tablespace Group
  • Multiple Temporary Tablespaces
  • Temporary Tablespace Shrink
  • Data Dictionary Views

Module 19: Create and Use Snapshots and Baselines with the Automatic Workload Repository

  • Automatic Workload Repository
  • Create Baselines
  • Moving Window Baseline
  • Baseline Templates
  • Managing Baseline
  • Compare Periods Report

Module 20: Use Metrics and Alerts

  • Overview of Metrics and Alerts
  • Server Generated and Event based Alerts
  • Set Thresholds

Module 21: Use AWR-Based Tools

  • Automatic Maintenance Tasks
  • Configuring Maintenance Windows
  • Enabling ADDM in a Pluggable Database
  • Generate an ASH Report

Module 22: Real Time Database Operation Monitoring

  • Overview of Real Time Database Operation Monitoring
  • Database Operation Concepts
  • Enable the Monitoring of Database Operations
  • Database Operation Views
  • Oracle Database 12cR2 New Features

Module 23: Monitor Applications

  • Create Services
  • End-to-End Application Tracing

Module 24: Big Data and Data Warehouse Features

  • Online Statistics Gathering for Bulk Loads
  • Real Time Statistics Gathering During DML Operations
  • Basic and Advanced Table Compression
  • Advanced Index Compression
  • Automatic Indexing with DBMS_AUTO_INDEX
  • Scalable Sequences
  • Quarantine of Runaway SQL Statements

Module 25: Tune Database I/O

  • Overview of Database I/O Management
  • I/O Calibration
  • About Data Files
  • Manually Distributing I/O
  • Sample Configurations
  • Asynchronous and Synchronous I/O
  • Automatic Storage Management (ASM)

Module 26: Summary of Oracle Performance Tuning

  • Potential Impact of Initialisation Parameters on Performance
  • Memory Management
  • Tablespace Types
  • DB_BLOCK_SIZE
  • Size the Redo Log Buffer and the Redo Log Files

 

Show moredown

Who should attend this Oracle Database DBA Performance Tuning & Management Training Course?

The Oracle Database DBA Performance Tuning & Management Training Course is designed for individuals who want to specialise in the Performance Tuning and Management of Oracle Database systems. This Oracle Training Course will benefit the following professionals:

  • Database Administrators (DBAs)
  • Database Performance Engineers
  • Database Developers
  • Technical Consultants
  • Database Managers
  • Team Leaders
  • IT Managers

Prerequisites of the Oracle Database DBA Performance Tuning & Management Training Course

There are no formal prerequisites to attend this Oracle Database DBA Performance Tuning & Management Course. However, a solid understanding of database administration, SQL, performance concepts, and programming would be beneficial for the delegates.

Oracle Database DBA Performance Tuning & Management Training Course Overview

In database administration, optimising performance ensures seamless data access, efficient application execution, and overall system responsiveness. The Oracle Database DBA Performance Tuning & Management Training Course delves into the intricacies of performance management, equipping professionals with the expertise to identify, diagnose, and resolve performance bottlenecks within Oracle database environments.

Proficiency in Oracle database performance tuning is paramount for Database Administrators (DBAs) who strive to maintain optimal system performance under ever-increasing demands. This training is particularly beneficial for experienced DBAs seeking to refine their skills and aspiring DBAs seeking to establish a strong foundation in performance management techniques.

This intensive 2-day Oracle Training empowers delegates with the knowledge and tools necessary to monitor, analyse, and tune Oracle database performance effectively. Delegates will gain insights into the Oracle database architecture, performance metrics, and tuning methodologies, enabling them to identify and address potential performance issues proactively.

Course Objectives

  • To understand the fundamentals of Oracle database performance management
  • To identify and analyse performance bottlenecks within Oracle database environments
  • To utilise Oracle-provided tools for performance monitoring and diagnosis
  • To apply effective tuning techniques to optimise SQL statements and database instances
  • To implement proactive performance management strategies to prevent future performance issues
  • To gain hands-on experience in performance tuning through practical exercises
  • To master the Oracle database performance tuning methodology

After completing this Oracle Online Course, delegates will earn a certificate of completion, attesting to their proficiency in Oracle database performance tuning and management. This valuable credential will enhance their professional standing and open doors to new opportunities in database administration.

Show moredown

What’s included in this Oracle Database DBA Performance Tuning & Management Training Course?

  • World-Class Training Sessions from Experienced Instructors   
  • Oracle Database DBA Performance Tuning & Management Certificate
  • Digital Delegate Pack

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 +1 6474932992 or Inquire.

Oracle Training FAQs

Oracle is a multinational corporation known for its database software, cloud engineering, and enterprise solutions, serving businesses globally. It provides a comprehensive suite of products and services for data management, cloud computing, and business applications.
Oracle is a versatile tool used for a wide variety of applications, including storing and managing customer data, tracking financial transactions, managing supply chains, analysing data for business insights, and supporting e-commerce applications.
Benefits of this training include gaining an increased earning potential, improved job prospects, enhanced career opportunities, validated skills, and a competitive edge in the job market.
Oracle Courses are designed for anyone who wants to learn or improve their skills in Oracle products and technologies. They are suitable for IT professionals, business professionals, and students alike.
In these Oracle Courses, delegates will have intensive training with our experienced instructors, a digital delegate pack comprising essential notes related to this Oracle Training Course, and a certificate after course completion.
Yes, there are prerequisites needed for these Oracle Courses. The specific requirements will vary depending on the course you are taking, and you may also need to have experience with a particular programming language, such as Java or Python.
Yes, The Knowledge Academy offers self-paced Oracle Courses, allowing learners to study at their own pace and convenience.
The difficulty level for Oracle Courses can vary depending on the specific course and your prior experience with Oracle or related technologies. However, the courses are generally considered intermediate to advanced level courses.
Yes, we provide corporate training for the Oracle Courses. We offer courses tailored to your organisational needs for a smooth learning journey.
After the Oracle Courses, you can expect roles such as Oracle Database Administrator, SQL Developer, or Oracle Application Developer. These positions involve managing databases, writing SQL queries, and developing applications using Oracle technologies.
Yes, we provide 24/7 customer support for these Oracle Courses via phone and email both before, during and after the course, ensuring that delegates have assistance when needed.
The duration of a course can vary depending on the specific course you are taking. However, in general, Oracle Courses range from 1 to 3 days.
Oracle Training is crucial for delegates as it equips them with essential skills to effectively manage Oracle technologies, enhances their ability to optimise database functionalities and enterprise applications, and significantly boosts their professional credibility and career prospects in a competitive IT landscape.
The Knowledge Academy stands out as a prestigious training provider known for its extensive course offerings, expert instructors, adaptable learning formats, and industry recognition. It's a dependable option for those seeking Oracle Certification Courses.
Please see our Oracle Training courses available in Canada
The Knowledge Academy is the Leading global training provider for Oracle Training.
The training fees for Oracle Training in Canada starts from CAD5195.
Show more down

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
cross

OUR BIGGEST SPRING SALE!

Special Discounts

red-starWHO WILL BE FUNDING THE COURSE?

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.