Oracle Database 18c: Administration Workshop

Duration : 5 Days (40 Hours)

Oracle Database 18c: Administration Workshop Course Overview:

The Oracle Database Administration Workshop course is designed for individuals with a basic understanding of the Oracle platform, aiming to enhance the skills of Database Administrators, Application Developers, and System Administrators. The course covers various topics, including database architecture, storage, security, backup and recovery, data warehousing, high availability, and disaster recovery technologies. Learners will gain comprehensive knowledge of administering, upgrading, monitoring, and troubleshooting different Oracle Database versions. By the end of the course, participants will be confident in managing Oracle Databases, understanding their performance characteristics, configuring backups and recovery, and optimizing performance.

Intended Audience:

  1. Technical professionals experienced in information technology, databases, and administration.
  2. IT professionals with a good understanding of core concepts related to Oracle Database Administration.
  3. Professionals who wish to upgrade their existing skill set to gain in-depth knowledge of Oracle Database Administration.
  4. System and database administrators looking to enhance their skills in deploying, configuring, managing, monitoring, upgrading, and troubleshooting Oracle Databases.
  5. Security administrators seeking to improve their expertise in Oracle Database security.
  6. IT managers responsible for overseeing database administration and operations within their organizations.

Learning Objectives of Oracle Database 18c: Administration Workshop:

1. Understand and deploy Oracle Database architecture, components and features.
2. Learn how to install, configure and customize Oracle Database, CDBs and PDBs.
3. Monitor, optimize and upgrade Oracle Database instances.
4. Manage users, privileges and roles.
5. Design, implement and manage storage and memory.
6. Troubleshoot and solve Oracle Database-related problems.
7. Create and maintain effective database backup and recovery strategies.
8. Monitor performance and diagnose and rectify issues causing performance degradation.
9. Create and manage database objects such as tables, indexes and views.
10. Manage database security and access control.
11. Understand the population, transformation and migration of data within the Oracle Database environment.
12. Understand the use of Data Guard, Oracle Enterprise Manager and Database-as-a-Service.

 Module 1: Introduction
  • Oracle Database Editions, Options, and Management Packs
  • Oracle Cloud Overview
  • Sample HR Schema
  • Oracle Database Server Architecture
  • Oracle Database Instance Configurations
  • Connecting to the Database Instance
  • Oracle Database Memory and Process Structures
  • Logical and Physical Database Structures
  • Multitenant Architecture
  • Automatic Storage Management (ASM) Overview
  • Oracle Database Cloud Service Architecture
  • Features and Tooling
  • Automated Database Provisioning
  • Input to the Creation Wizard
  • SSH Key Pairs
  • Database File Storage
  • SQL*Plus
  • SQL Developer
  • Database Configuration Assistant (DBCA)
  • Oracle enterprise Manager Database Express
  • Oracle Enterprise Manager Cloud Control
  • Oracle Database Cloud Service Tools
  • Managing the Compute Node
  • Managing Network Access to DBCS
  • Scaling a Database Deployment
  • Patching a Database Deployment
  • Initialization Parameter Files
  • Starting Up Oracle Database Instances
  • Shutting Down Oracle Database Instances
  • Automatic Diagnostic Repository (ADR)
  • Alert Log and Trace Files
  • Dynamic Performance Views
  • Data Dictionary Views
  • Oracle Net Listener Overview
  • Connecting to an Oracle Database Instance
  • Naming Methods
  • Oracle Net Services Administration Tools
  • Configuring Communication Between Database Instances
  • Comparing Dedicated and Shared Server Configurations
  • Managing Oracle Cloud Users, Privileges, and Roles
  • Managing Oracle Database Users, Privileges, and Roles
  • User Authentication
  • Creating and Assigning Profiles
  • Assigning Quotas to Users
  • Applying the Principal of Least Privilege
  • Methods and Tools to Create PDBs
  • Creating PDBs from Seed
  • Cloning PDBs
  • Unplugging and Plugging in PDBs
  • Dropping PDBs
  • Encryption in Oracle Database Cloud Service
  • Overview of Transparent Data Encryption (TDE)
  • CDB and PDB Master Encryption Keys
  • Creating and Activating an Encryption Key
  • Table Data Storage
  • Creating, Altering and Dropping Tablespaces
  • Viewing Tablespace Information
  • Implementing Oracle Managed Files
  • Moving and Renaming Online Data Files
  • Tablespace Encryption by Default in DBCS
  • Oracle Database Space Management Features
  • Block Space Management
  • Types of Segments
  • Deferred Segment Creation
  • Space-Saving Features
  • Table and Row Compression
  • Shrinkable Segments
  • Resumable Space Allocation
  • Transactions and Undo Data
  • Storing Undo Information
  • Comparing Undo Data and Redo Data
  • Comparing Local Undo Mode and Shared Undo Mode
  • Configuring Undo Rentention
  • Temporary Undo
  • Oracle Data Pump
  • SQL*Loader
  • External Tables
  • Migrating to Oracle Database Cloud Service
  • Categories of Failure
  • Instance Recovery
  • Complete Recovery
  • Point-in-time Recovery
  • Flashback Technology
  • Configuring and Monitoring the Fast Recovery Area
  • Multiplexing Control Files
  • Multiplexing Redo Log Files
  • Archive Redo Log Files
  • Configuring ARCHIVELOG Mode
  • Backup Terminology
  • Using Recovery Manager (RMAN)
  • RMAN Backup Types
  • Automatic Backups on Database Cloud Service (DBCS)
  • On-Demand Backups on DBCS
  • Database Recovery Advisor
  • Recovering Data Files in NOARCHELOG Mode
  • Recovering Data Files in ARCHIVELOG Mode
  • Recovery Options in Database Cloud Service (DBCS)
  • Performance Planning Considerations
  • Automatic Workload Repository (AWR)
  • Automatic Database Diagnostic Monitor (ADDM)
  • Advisory Framework
  • Managing Metric Thresholds and Alerts
  • Monitoring Wait Events, Sessions, and Services
  • Performance Tuning Methodology
  • Managing Memory Components
  • SQL Tuning Process
  • Oracle Optimizer
  • Optimizer Statistics
  • SQL Tuning Advisor
  • SQL Access Advisor
  • SQL Performance Analyzer

Oracle Database 18c: Administration Workshop Course Prerequisites:

The recommended prerequisite for taking Oracle Database: Administration Workshop Training course is to have a basic understanding of relational database terminology, knowledge of the Linux operating system and a basic knowledge of SQL.

Discover the perfect fit for your learning journey

Choose Learning Modality

Live Online

  • Convenience
  • Cost-effective
  • Self-paced learning
  • Scalability


  • Interaction and collaboration
  • Networking opportunities
  • Real-time feedback
  • Personal attention


  • Familiar environment
  • Confidentiality
  • Team building
  • Immediate application

Training Exclusives

This course comes with following benefits:

  • Practice Labs.
  • Get Trained by Certified Trainers.
  • Access to the recordings of your class sessions for 90 days.
  • Digital courseware
  • Experience 24*7 learner support.

Got more questions? We’re all ears and ready to assist!

Request More Details

Please enable JavaScript in your browser to complete this form.

Subscribe to our Newsletter

Please enable JavaScript in your browser to complete this form.