Course Name

Oracle Database 19c: Administration Workshop

  • Code: D81246GC22
  • Duration: 5 Day(s)
  • Date: On Request
  • Price: R21, 750.00 (excl. VAT)
Call me back
Get Overview
Book now!

Course Introduction

The Oracle Database 19c: Administration Workshop will teach you about the Oracle Database architecture. You will discover how to effectively manage an Oracle Database instance, configure the Oracle Network Environment, and perform database maintenance

Course Delivery Method

Our courses have flexible delivery options:

  • In-person classroom training at the Impactful training
    facilities

  • Virtual instructor-led training
  • Nationally: on-site at the client

Course Intended Audience

This course is intended for:

  • Database Administrator
  • Systems Administrator

Course Prerequisites

  • Unix and Linux Essentials
  • Oracle Database: Introduction to SQL

Course Objectives

  • Back up, restore, and patch DBCS database deployments
  • Describe the DBaaS and on-premises Oracle Database architectures
  • Manage database instances
  • Manage UNDO data
  • Move data between databases
  • Implement basic backup and recovery procedures
  • Monitor and tune database performance
  • Tune SQL to improve performance
  • Manage resources with Oracle Database Resource Manager
  • Create pluggable databases (PDBs)
  • Configure the Oracle network environment
  • Administer user security and implement auditing
  • Create and manage tablespaces
  • Manage storage space
  • Create and manage Database as a Cloud Service (DBCS) database deployments
  • Register databases and manage performance with Enterprise Manager Cloud Control

Course Content

  • Module 1: Getting Started
  • Module 2: Exploring Oracle Database Architecture
  • Module 3: Managing Database Instances
  • Module 4: Creating PDBs
  • Module 5: Configuring the Oracle Network Environment
  • Module 6: Administering User Security
  • Module 7: Creating and Managing Tablespaces
  • Module 8: Managing Storage Space
  • Module 9: Managing UNDO Data
  • Module 10: Moving Data
  • Module 11: Backup and Recovery Concepts
  • Module 12: Monitoring and Tuning Database Performance
  • Module 13: SQL Tuning
  • Module 14: Oracle Database Resource Manager
  • Module 15: Enterprise Manager Cloud Control
  • Module 16: Introduction to Oracle Database Cloud
  • Module 17: Creating DBCS Database Deployments
  • Module 18: Managing DBCS Database Deployments
  • Module 19: Backing Up and Restoring DBCS Database Deployments
  • Module 20: Patching DBCS Database Deployments
  • Module 21: Creating Master Encryption Keys for PDBs
  • Module 22: Tablespace Encryption by Default

Course Associated Exam and Certification

1Z0-072

L❤ ve this. Share it now!

Need additional information?

We are here to support your growth every step of the way

Please call me

Get in touch

Contact the Impactful team if you need any assistance.
Email: impactful@lrmg.co.za
Tel: +27 87 941 5764

Course Introduction

The Oracle Database 19c: Administration Workshop will teach you about the Oracle Database architecture. You will discover how to effectively manage an Oracle Database instance, configure the Oracle Network Environment, and perform database maintenance

Course Delivery Method

Our courses have flexible delivery options:

  • In-person classroom training at the Impactful training
    facilities

  • Virtual instructor-led training
  • Nationally: on-site at the client

Course Intended Audience

This course is intended for:

  • Database Administrator
  • Systems Administrator

Course Prerequisites

  • Unix and Linux Essentials
  • Oracle Database: Introduction to SQL

Course Objectives

  • Back up, restore, and patch DBCS database deployments
  • Describe the DBaaS and on-premises Oracle Database architectures
  • Manage database instances
  • Manage UNDO data
  • Move data between databases
  • Implement basic backup and recovery procedures
  • Monitor and tune database performance
  • Tune SQL to improve performance
  • Manage resources with Oracle Database Resource Manager
  • Create pluggable databases (PDBs)
  • Configure the Oracle network environment
  • Administer user security and implement auditing
  • Create and manage tablespaces
  • Manage storage space
  • Create and manage Database as a Cloud Service (DBCS) database deployments
  • Register databases and manage performance with Enterprise Manager Cloud Control

Course Content

  • Module 1: Getting Started
  • Module 2: Exploring Oracle Database Architecture
  • Module 3: Managing Database Instances
  • Module 4: Creating PDBs
  • Module 5: Configuring the Oracle Network Environment
  • Module 6: Administering User Security
  • Module 7: Creating and Managing Tablespaces
  • Module 8: Managing Storage Space
  • Module 9: Managing UNDO Data
  • Module 10: Moving Data
  • Module 11: Backup and Recovery Concepts
  • Module 12: Monitoring and Tuning Database Performance
  • Module 13: SQL Tuning
  • Module 14: Oracle Database Resource Manager
  • Module 15: Enterprise Manager Cloud Control
  • Module 16: Introduction to Oracle Database Cloud
  • Module 17: Creating DBCS Database Deployments
  • Module 18: Managing DBCS Database Deployments
  • Module 19: Backing Up and Restoring DBCS Database Deployments
  • Module 20: Patching DBCS Database Deployments
  • Module 21: Creating Master Encryption Keys for PDBs
  • Module 22: Tablespace Encryption by Default

Course Exam And Certification

1Z0-072

Are you ready to start?

Sign Up
Download Overview

Certified global best practices in the new technologies…

Amazon Web Services Impactful Partner
PeopleCert Logo
Impactful is an Accredited Oracle University Partner
Impactful Partner Microsoft logo

Get ahead with your IT and Digital Talent development

Please complete the form with your information and one of our experts will get back to you soon.

Get in touch

Contact the Impactful team if you need any assistance.

Email: impactful@lrmg.co.za
Tel: +27 87 941 5764

About LRMG

Testing Elementor conditions

Testing Elementor conditions

Testing Elementor conditions

Testing Elementor conditions

CONTACT US