close

close

Thank you for your enquiry!

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

close

close

Press esc to close

close close

Back to course information

Thank you for your enquiry!

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

close close

Thank you for your enquiry!

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

Oracle Training

Online Instructor-led (3 days)

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

Oracle Database 12c: Administration Course Overview

The Oracle Database is a Relational Database-Based System that allows users to directly access data objects. Nowadays, several multinational corporations rely heavily on the Oracle Database to manage and analyse data across local and wide-area networks. The database administrator is in charge of allocating storage to the system and planning additional storage requirements for the database system. This training will teach individuals how to create and manage database storage structures, configure the network environment, and monitor database performance. Individuals who possess the lucrative skills to perform administrative tasks by using the Oracle Database 12c will benefit with increased value and improved work output in their respective fields.

This 3-day Oracle Database 12c: Administration Training course is designed to provide an understanding of Oracle Database and how to perform administrator tasks. During this training, delegates will learn about relational databases that store and manage information to fulfil business needs. They will also learn how to administer a database instance using administrative tools available to DBAs and how to create database connections using SQL Developer. Our highly skilled trainer with years of teaching experience will conduct this course and equip delegates with the tools to manage and monitor user account information.

Course Objectives

  • To understand the Oracle database architecture and how it works
  • To learn about the enterprise manager, cloud control gives centralised monitoring and administration for the entire IT infrastructure
  • To get familiar with the initialisation parameter files that are given on the Oracle distribution medium for every OS
  • To attain an understanding of Oracle n et listener configuration and management
  • To determine the number of data files
  • To learn about the various methods for protecting Oracle database user accounts

After completing the training course, delegates will be able to ensure the integrity and availability of a company's data within the Oracle environment. They will be able to monitor the performance of the database, allocate resources with the resource manager, and schedule jobs. ​

Show moredown

What’s included in this Oracle 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)

Classroom (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 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 Course. However, a basic understanding of Oracle SQL would prove to be beneficial. 

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

Oracle Database 11g offers the best performance, scalability, security, and dependability in the market on a variety of clustered or single-servers running Windows, Linux, or UNIX. An individual or group is designated as a database administrator (DBA) and is in charge of maintaining, controlling, coordinating, and running the database management system efficiently. With the help of this training, learners will be able to set up, manage, and troubleshoot an Oracle 11g Release 1 or Release 2 database as it offers portability, backup and recovery, high performance, multiple database support, market presence, version changes, less cost, and various other benefits that is crucial for organisations. Individuals who pursue this training are better able to acquire the knowledge and abilities that will ultimately expand their employment options and upgrade their income. 

In this 3-day Oracle Database 11g Release 2 DBA-Part I, delegates will gain deep knowledge of how to set up, install, and configure Oracle 11g in their systems. Delegates will learn about initialising parameters, setting database limits, upholds security, usage of trace and alert files, and managing passwords efficiently. They will also learn about Oracle Net Listener Configuration and Client Connections. This course is led by our highly professional trainer who has years of teaching experience in this course and makes delegates efficient in using Oracle Database 11g. 

Course Objectives 

  • To view control and online redo log file information 
  • To create multiple tables and views in a single operation 
  • To monitor the general database state and workload 
  • To form red-log groups and members 
  • To learn about truncating tables and clusters 

At the end of this training, delegates will be able to install and configure Oracle in an attractive and easy method. They will also be able to create and manage databases and configure the Oracle network environment. 

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)

Classroom (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 Course is designed for individuals who have a foundational understanding of Oracle databases and have completed the Part I Course. This 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.

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

An Oracle database is a collection of data treated as a unit. The main objective of a database is to retrieve and store corresponding information. A database server is the best way to solve the problems faced in information management. Oracle Database 11g offers the best performance, scalability, security, and dependability in the market on a variety of clustered or single-servers running Windows, Linux, or UNIX. The Oracle Database assists organisations by providing various ways to cut operational costs and makes it more cost-effective to operate than multiple databases. Individuals who pursue this training are better able to acquire the knowledge and abilities that will ultimately expand their employment options and raise their income.

In this 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 recovering the whole database. Our highly professional trainer with years of experience in teaching such courses will conduct this training course and will help you get a complete understanding of this course.

Course Objectives:

  • To monitor the backup and recovery environment 
  • To disable automatic memory management and configure the database 
  • To obtain metadata and historical data for transactions 
  • To configure the database for the flashback transaction feature 
  • To enable or disable all automated maintenance tasks for all windows 

At the end of this training, delegates will be able to configure a database for automatic undo management. They will also be able to restore and recover database files efficiently.

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

Classroom (3 days)

Online Self-paced (24 hours)

Oracle Database 19c Administration Training Course Outline

Module 1: Introduction to Oracle Database

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

Module 2: Oracle Database Architecture

  • Overview
  • 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 Course is designed for individuals who are looking to develop expertise in managing Oracle Database 19c environments. This course can benefit a wide range of professionals, including:

  • Database Administrators (DBAs)
  • System Administrators
  • Oracle Database Developers
  • IT Managers
  • Technical Consultants
  • Data Security Officers

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 is a Relational Database Management System which is the most reliable and commonly used relational database engine. The Oracle database has its own network component which supports relational and non-relational data types, including eXtensible Mark-up Language and JavaScript Object Notation. This training is intended to assist learners with setting up a network environment as well as creating and managing database storage structures. This training will help businesses with increasing performance, security, and application development opportunities that will allow them to make important business choices. Understanding how to administer, monitor, and manage an Oracle database will enable learners to take advantage of several successful career possibilities at numerous organisations.

This 3-day Oracle Database 19c Administration training course 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 acquire knowledge of how to use the job scheduler and configure a database for backup and recovery. Our highly skilled tutor will conduct this course and help delegates become proficient in administering, monitoring, tuning, and troubleshooting an Oracle database. 

Course Objectives: 

  • To create and manage database storage 
  • To monitor and tune database performance 
  • To manage automated maintenance tasks 
  • To understand how to create and administer an Oracle database 
  • To learn how to create and manage tablespaces 

At the end of this training, delegates will be able to monitor the database performance, resource allocation with the resource manager. They will also be able to manage users, profiles, privileges and roles.

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)

Classroom (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 the 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 course will benefit various professionals, including:

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

Prerequisites of the Oracle 18c DBA Fundamentals Course

There are no formal prerequisites to attend this training course. However, a basic understanding of Database concepts, SQL fundamentals, and operating system would be beneficial for the delegates.

Oracle 18c DBA Fundamentals​ Course Overview

A database administrator is in charge of organising, maintaining, and managing a company's data. The primary goal of a database administrator is to ensure authorised users have access to the data they need at the right time. Studying this training helps learners enable them to select Oracle Security solutions to satisfy organisational security requirements by helping them comprehend database security requirements. It provides significant benefits to organisations by reducing operations costs, providing a secure hybrid cloud environment, and improving identity management and user controls. Pursuing this training equips learners with the skills and strategies they need to ultimately increase their work prospects and financial situation.

In this 2-day Oracle 18c DBA Fundamentals Training, delegates will gain in-depth knowledge of managing integrity constraints, object dependencies, object name resolution, and editions. During this training, delegates will learn about planning for master databases and materialised view databases. They will also learn about managing global names in a distributed system, creating database links, and using shared database links. 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 configure automated maintenance tasks and maintenance windows
  • To create and alter different types of hash clusters
  • To manage views, sequences, and synonyms
  • To diagnose problems with database links
  • To plan capacity for database objects

At the end of this training, delegates will be able to truncate tables and clusters in a very effective manner. They will also be able to reclaim unused space and drop unused object storage.

Show moredown

What’s included in the 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 (3 days)

Classroom (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 course can benefit a wide range of professionals, including:

  • Database Beginners
  • 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. 

 

Oracle SQL Fundamentals Course Overview

Structured Query Language (SQL) is a standard programming language that is used to manage relational databases and perform various operations on the data in them. It facilitates retrieving specific information from databases that are further used for analysis. This training session aims to enhance individuals’ skills and provide them with a better understanding of the applications they work with on a daily basis. Studying this programme enables learners to adapt the skills of manipulating and retrieving data stored in a relational database. Pursuing this training helps individuals get equipped with the necessary skills and techniques to enhance their career opportunities and ultimately increase their earnings.

This 3-day Oracle SQL Fundamentals Training course is designed to teach delegates the fundamental concepts of SQL. During this training, delegates will gain a thorough understanding of database management, which includes monitoring, administering, and maintaining a database and its groups in the enterprise. They will also acquire knowledge of sequential numbers that are produced by the sequence generator to generate unique primary keys automatically and coordinate keys across multiple rows or tables. Our highly skilled trainer with years of teaching experience will conduct this training and equip delegates with comprehensive knowledge of the SQL language.

Course Objectives

  • To understand what a database schema is and how it is used 
  • To query records and display them in an ascending or descending order
  • To manage a single database or thousands of instances with apparent scalability
  • To learn how Oracle handles hierarchical queries,
  • To gain an understanding of automatically Collect statistics on tables.
  • To track statistics for improving database performance

After successfully completing this training course, delegates will be able to create Oracle SQL statements to query database tables and use standard aggregate functions. They will also be able to 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 (2 days)

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

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

An Oracle database is a set of data that is handled as a single entity. A database's function is to store and retrieve relevant information. On the other hand, a database server is essential for resolving information management issues. Each database necessitates the presence of at least one database administrator. The primary aim of Oracle Database is to accelerate the provisioning of pluggable databases. This training will help learners monitor and optimise database performance, as well as plan for backup and recovery of database data. Individuals who complete this training course will be able to achieve rapid and significant professional growth as well as expand their career opportunities in this field.

In this 2-day Oracle Database 12c R2: New Features for 12c R1 Administrators Ed 1 course, delegates will gain a thorough understanding of 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. They will also learn how to update and drop the catalogue without using the DROP CATALOG and UPGRADE CATALOG commands. Our highly experienced trainer will deliver this training course, who will put in their best efforts to make delegates understand things easily.

Course Objectives:

  • To understand how to create a PDB from CDB seed enhancements
  • To know about transporting data across platforms and steps to recover a table
  • To learn about how to optimise joined columns by creating join groups
  • To manage the procedure of database deployment, backup, and recovery automatic
  • To get in touch with how to manage the PDB lockdown profiles
  • To create audit policies for users to whom the role is granted directly

At the end of this training, Delegates will be able to manage SGA and PGA at the PDB level and view CDB and PDB ADDM analysis. They will also be able to use cross-platform Non-CDB or PDB backup sets to import into a CDB.

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)

Classroom (3 days)

Online Self-paced (24 hours)

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

Module 1: Oracle Database Multitenant Architecture Overview

  • Oracle Database 12cR2 Architecture Overview
  • An Overview of a Container Database (CDB)
  • Benefits of Multitenant Architecture
  • Root Container
  • 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 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 12cR2, 18c, and 19c New features for administrators’ course is designed to provide knowledge of how to use new non-container database features that have been introduced in Oracle Database 12cR2, 18c, and 19c. Delegates will acquire knowledge of how the enhanced features of Oracle Database 12cR2, 18c, and 19c can be implemented at their own site.

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

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

Show moredown

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

Classroom (1 days)

Online Self-paced (8 hours)

Oracle SQL Advanced Training​ Course Outline

Module 1: Access Control

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

Module 2: Retrieve Data Using Subqueries

  • ANY, ALL, or SOME Operators
  • Correlated Subqueries
  • In-Line Views
  • 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 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

Structured Query Language (SQL) is the collection of statements that all programmes and users use to retrieve data from an Oracle database. Oracle tools and application programmes frequently allow users to access the database without explicitly using SQL, despite the fact that these apps must use SQL to fulfil the user's request. This training will teach you how SQL provides an interface for relational databases such as Oracle Database, and SQL statements are database instructions. This Oracle SQL Advanced Training session equips learners with the SQL statements to work with data at the logical level and manipulate it as per the user’s needs. Having the ability to handle data using SQL subqueries enables individuals to get higher designations as Database Administrators, Application Programmers, etc.

The Knowledge Academy’s 1-day Oracle SQL Advanced Training provides delegates with the SQL statements and how to create analytic and hierarchical queries. During this training, delegates will acquire knowledge of how to implement GROUPING and GROUPING_ID functions. They will acquire knowledge of how to create and use external tables, perform flashback operations, and control user access to database objects. This course will be led by our highly skilled instructor who has years of teaching experience in technical courses.

Course Objectives

  • To change the authentication characteristics of a database user
  • To grant and revoke privileges on functions and procedures in Oracle
  • To test the presence of any record in a subquery with the EXISTS operator
  • To implement a single transformation using an optimiser with ANY condition
  • To give users system privileges and roles, use the GRANT SQL statement
  • To update the data in the column with the given values using the PL/SQL engine

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

Classroom (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 training course. However, a basic knowledge of databases would be beneficial for the delegates.

Oracle SQL & PL/SQL Fundamentals​ Course Overview

PL/SQL is a procedural language that incorporates SQL statements into its syntax, making it easy to write and read, and it includes a variety of built-in optimisations and security features. The Oracle Database server compiles and stores PL/SQL programme units within the database. PL/SQL and SQL are executed within the same server process, resulting in maximum performance. This training will help learners gain a good understanding of PL/SQL to move along with the Oracle database. Having knowledge of Oracle SQL and PL/SQL Fundamentals will help individuals become more valuable and productive in their respective fields. 

This 3-day Oracle SQL & PL/SQL Fundamentals Training course aims to provide delegates with a comprehensive knowledge of SQL concepts. During this course, delegates will gain an understanding of how to write SQL statements and scripts using Oracle SQL. Furthermore, delegates will acquire in-depth knowledge about how to select statements by using where clause, OR condition, sorting ascending or descending order, etc. Our highly skilled trainer with years of teaching experience will conduct this course and equip delegates with the writing and running of PL/SQL programs and their functions.

Course Objectives: 

  • To learn about the select command to sort the records
  • To get familiar with the data manipulation language
  • To recognise strategies for joining tables using Oracle syntax
  • To acquire knowledge of single and multiple rows subqueries
  • To determine the invoking functions in SQL expressions

After completing the training course, delegates will be able to perform various functions to solve calculations and implement statements. They will also be able to create object-oriented programs, SQL packages, and tables.

Show moredown

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

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

Show moredown

Online Instructor-led (2 days)

Classroom (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 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 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 Payables has a completely responsive, multi-window Graphical User Interface with a complete point-and-click capability. It provides comprehensive support for all of the business's needs on a global scale, including currency conversions, global tax arrangements, and payments due in the future. Studying this training equips learners with the skills to manage suppliers' data and daily tasks, also including managing the voucher process. It is important because it helps to increase margins, promote organisational and economic discipline, and strengthen commercial ties. Pursuing this training helps individuals get equipped with the necessary skills and techniques that will ultimately enhance their career opportunities and upgrade their earnings.

The Knowledge Academy’s 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, unposting, 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 important topics. Our highly professional trainer, who has years of teaching experience, will conduct this course and make delegates practise managing transactions successfully.

Course Objectives

  • To set up and maintain suppliers to record information about individuals
  • To enter expense reports into Oracle projects and transfer them to payables
  • To understand recurring vouchers and work with recurring vouchers
  • To create payment for foreign currency and convert payment lines
  • To learn about manual payments for existing vouchers
  • To maintain accurate data and cultivate a positive relationship with suppliers

At the end of this training, delegates will be able to use Oracle Payables to manage the payables process. They will also be able to manage suppliers, close accounts payable periods, and transfer accounting details to the general ledger.

Show moredown

What’s included in the 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)

Classroom (2 days)

Online Self-paced (16 hours)

Oracle Database 18c Administration Training​ Course Outline

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

Module 1: Oracle Database Architecture Overview

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

Module 2: Oracle Database Cloud Overview

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

Oracle Database 18c Administration Training​ Course Overview

Oracle Database 18c is a new version of the accessible database that can be implemented on-premises or in the cloud. For the secure deployment of transactional and analytical workloads on-premises and in cloud environments, such database technologies are extremely fast, reliable, and scalable. This training will introduce several new features and updates, including in-memory column stores, crucial capabilities, native database sharding, and multitenant architecture. This Oracle Database 18c training will assist learners to create a database storage structure appropriate for the organisation's applications supported by the created database. Individuals who pursue this training are better able to acquire the knowledge and abilities that will ultimately expand their employment options and raise their income.

In this 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. They will also learn about transporting data at different levels from one database to another and eventually convert transported data into the desired format. This course will be led by our highly professional trainer who has years of teaching experience and will help you get a complete understanding of it.

Course Objectives:

  • To create and maintain a database password file
  • To manage initialisation parameters using a server parameter file
  • To get familiar with SRVCTL and CRSCTL command reference
  • To learn about Oracle database configuration for shared server
  • To improve query performance with the Oracle database in-memory

At the end of this training, delegates will be able to create and manage Database Cloud Service deployments and configure the database to support an application, as well as manage the database security and implement auditing. They will also be able to create databases with DBCA and databases with 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 (2 days)

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

PL/SQL is a procedural language that incorporates SQL statements into its syntax, making it easy to write and read, and it includes a variety of built-in optimisations and security features. The Oracle Database server compiles and stores PL/SQL programme units within the database. At runtime, both PL/SQL and SQL are executed within the same server process, resulting in maximum performance. The goal of this training is to increase the productivity of individuals as programmers by allowing them to query, alter, and update data in a database. This training teaches learners how to use PL/SQL to submit a complete block of statements to a database at once. Working with PL/SQL can help individuals achieve rapid and significant professional growth and expand career opportunities through various high-profile job roles.

Our 2-day Oracle Program Training with PL/SQL training course provides delegates with a comprehensive knowledge of various basic to advanced concepts of SQL. Delegates will learn various concepts such as cursor operations, how to create variables and assign values, types of declaring records, nested records, etc. They will also understand the parameters of the procedure, function result cache, exception types, and many more. Our highly experienced trainer will conduct this training and provide delegates with an in-depth knowledge of PL/SQL.

Apart from the above, delegates will also cover the following concepts, such as:

  • Program logic fundamentals
  • System-raised exceptions
  • User-declared exceptions and application errors
  • Automatic program sublining
  • Oracle-supplied packages

After successfully completing this training course, delegates will be able to create Oracle SQL or SQL developer output using PL/SQL components. They will also be able to implement various programming loops through program logic 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 (2 days)

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

There are no formal prerequisites to attend this training 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

This Oracle Database DBA Performance Tuning & Management course introduces the Database Administrator to the main concept of Oracle Database performance tuning and management. DBAs will acquire knowledge of how to analyse and tune database performance. Performance tuning is the process to optimise Oracle performance by streamlining the execution of SQL statements. This course describes the tools for evaluating SQL statements, SQL optimiser, sorts, and indexes. The optimiser compares the plans and choose the plan with the lowest cost.

In this course, delegates will learn how to use tuning goals and methodologies for identifying tuning contentions in an Oracle database. They will also gain an understanding of how to take corrective action as well as to detect and tune common database performance problems. This course describes how to use the database advisor to tune a database proactively and utilise several tools by Oracle to tune the database.

During this course, delegates will be equipped with the knowledge of how to identify and correct problem SQL statements and use tools to monitor and diagnose SQL trace performance issues. Delegates will learn about tuning memory components, shared pool, SGA, and data block buffers. They will also acquire knowledge of setting the SGA and shared a pool, tuning the data block buffers, using automatic memory management, setting the PGA and temporary space. This course also explains tuning block space, monitoring statistics and wait for events, baselines, AWR, and ADDM. It gathers, processes and maintains performance stats used for problem detection and self-tuning the databases. Automatic Database Diagnostic Monitoring Report analyses the AWR data on a regular basis, to give an overview of the root cause of the problem, which is affecting the database’s performance.

Show moredown

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

  • 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 01344203999 or Enquire.

Oracle Training FAQs

FAQ's

Please arrive at the venue at 8:45am.
Please see our Oracle Training courses available in the United Kingdom
The Knowledge Academy is the Leading global training provider for Oracle Training.
The price for Oracle Training certification in the United Kingdom starts from £2495.

Why we're the go to training provider for you

icon

Best price in the industry

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

icon

Trusted & Approved

We are accredited by PeopleCert on behalf of AXELOS

icon

Many delivery methods

Flexible delivery methods are available depending on your learning style.

icon

High quality resources

Resources are included for a comprehensive learning experience.

barclays Logo
deloitte Logo
Thames Water Logo

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

Joshua Davies, Thames Water

santander logo
bmw Logo
Google Logo

Looking for more information on Oracle Training