Oracle Database 23ai: Administration Workshop Training in Saudi Arabia

  • Learn via: Classroom / Virtual Classroom / Online
  • Duration: 5 Days
  • Level: Intermediate
  • Price: From €5,390+VAT
  • Upcoming Date:
  • UK & Türkiye Based Global Training Provider

This comprehensive and advanced-level Oracle Database 23ai: Administration Workshop Training in Saudi Arabia is designed for Database Administrators (DBAs) aiming to specialize in installing, configuring, monitoring, and securing Oracle Database 23ai systems. Throughout the course, participants will engage in hands-on and in-depth instruction across Oracle architecture, multitenant database structures (CDB/PDB), network services, user and privilege management, data security, performance tuning, data transport, and automated maintenance tasks.

We can organize this training at your preferred date and location. Contact Us!
HAVELSAN
ASELSAN
PepsiCo Türkiye
JTI TÜTÜN ÜRÜNLERİ SANAYİ A.Ş.
ING Bank
DHL
MASTERCARD
Huawei
TotalEnergies
Mercedes-Benz Türk A.Ş.
Goodyear
FORD OTOMOTIV SANAYI A.S.
3M COMPANY
Schneider Electric
Central Bank of Azerbaijan
BP Petrolleri
Procter & Gamble (P&G)
Qatar Foundation
Bank Of China
GlaxoSmithKline (GSK)
MORGAN STANLEY & CO Inc
Novo Nordisk
DEUTSCHE BANK
Azerbaycan Cumhuriyeti Emek ve Ahalinin Sosyal Güvenliği Bakanlığı
ACCENTURE

Prerequisites

Oracle Database 23ai: SQL Workshop (or equivalent knowledge)

What You Will Learn

By the end of this Oracle Database 23ai: Administration Workshop Training in Saudi Arabia, you will have gained knowledge and skills in the following areas:

  • Understand Oracle Database architecture in detail

  • Perform database installations using GUI (DBCA) and command-line tools

  • Configure Oracle Net Services and manage connectivity

  • Manage Pluggable Databases (PDBs) effectively

  • Administer storage structures, tablespaces, and undo segments

  • Configure and manage user accounts, roles, and profiles

  • Set up auditing policies, including FGA (Fine Grained Auditing)

  • Use SQL*Loader, Data Pump, and external tables for data loading/migration

  • Leverage RMAN and cross-platform data transport capabilities

  • Monitor and tune systems using Oracle Enterprise Manager

  • Schedule and manage automated maintenance tasks for high availability

Training Outline

1. Introduction to Oracle Database Architecture

  • Oracle instance components (SGA, PGA)

  • Background processes (SMON, PMON, LGWR, DBWR)

  • Understanding CDB and PDB structures

  • Memory and process diagrams, introduction to sharding

2. Database Access and Tools

  • SQL*Plus, SQL Developer, DBCA, OEM, Cloud Control 13c

  • Configuration and management interfaces

3. Database Creation Using DBCA

  • Selecting templates, setting character sets, silent mode execution

4. Database Creation Using SQL

  • CREATE DATABASE, ENABLE PLUGGABLE DATABASE

  • Configuring SEED file directories and mappings

5. Starting and Shutting Down the Database

  • STARTUP, SHUTDOWN modes, managing PDB openings, auto start

6. Instance and Parameter Management

  • Initialization parameters (spfile, init.ora)

  • Alert logs, trace files, V$ dynamic views

7. Oracle Net Services

  • Understanding listener components and architecture

  • Differences between Dedicated and Shared Servers

8. Naming Methods

  • Easy Connect, Local Naming, Directory Naming

  • Using DB Services for workload management

9. Configuring the Listener

  • Static and dynamic service registration

  • Modifying listener.ora

10. Shared Server Architecture

  • Configuration, session handling, performance considerations

11. Creating PDBs

  • CREATE PLUGGABLE DATABASE syntax

  • Use of FILE_NAME_CONVERT, OMF integration

12. Cloning and Migrating PDBs

  • DBMS_PDB, GoldenGate replication

  • Remote cloning, unplug/plug methods

13. Managing PDBs

  • Opening/closing PDBs, parameter configuration, PDB removal

  • Hostname and port assignment per PDB

14. Database Storage Architecture

  • Segments, extents, blocks, and physical structures

  • SYSTEM, SYSAUX, USERS tablespaces explained

15. Tablespace Creation and Management

  • Permanent and temporary tablespaces

  • File relocation, renaming, and OMF usage

16. Storage Optimization

  • Compression techniques, shrinking segments

  • Resumable Space Allocation setup and use

17. Undo Management

  • Undo types, UNDO_RETENTION, temporary undo features

18. User Account Management

  • Common vs local users, password authentication

  • OS Authentication and quota management

19. Privileges and Roles

  • System vs object privileges

  • Role-based access control, Oracle default roles

20. Resource Limits (Profiles)

  • Profile creation, password policies, resource assignments

21. Oracle Audit Configuration

  • Unified audit policies, Fine-Grained Auditing (FGA)

  • Archiving and purging audit records

22. Introduction to Data Transfer

  • SQL*Loader, Data Pump, RMAN overview and use cases

23. Data Loading Techniques

  • Creating control files, using Express mode

  • Table-level loading examples

24. Data Transport Methods

  • PDB-to-PDB transfer via Data Pump

  • RMAN cross-platform transport, endian format checks

25. Loading with External Tables

  • ORACLE_LOADER and ORACLE_DATAPUMP drivers

26. Introduction to Automated Maintenance

  • Task types, maintenance windows explained

27. Managing Automated Tasks

  • Creating schedules, enabling/disabling jobs

  • Resource allocation configuration

28. Fundamentals of Performance Monitoring

  • AWR, ADDM, and advisory tools introduction

29. Advanced Performance Tracking

  • Wait events, sessions and services monitoring

  • Gathering statistics and setting thresholds

30. SQL Analysis and Access Path Optimization

  • Optimizer Statistics, SQL Tuning Advisor, Access Advisor

  • Adaptive Execution Plans in Oracle 23ai

Why Choose Bilginç IT Academy

At Bilginç IT Academy, we combine our strong presence in both the UK and Türkiye to deliver high-quality, practical training solutions for organizations worldwide.

International Presence with Local Expertise
With operations in the United Kingdom and Türkiye, we bring together global standards and local market understanding to deliver effective training experiences across regions.

Expert Instructors with Real-World Experience
Our courses are delivered by certified trainers with extensive industry experience, ensuring you gain practical knowledge that can be applied immediately.

Corporate-Focused Training Approach
We specialize in training corporate teams, tailoring our programs to meet your organization’s goals, technologies, and project requirements.

Flexible Training Delivery Worldwide
We offer classroom, virtual classroom, and onsite training options globally, tailored to your organization’s needs.

Hands-On, Practical Learning
Our training sessions include real-world scenarios, case studies, and interactive exercises to ensure lasting understanding and skill development.

Proven Track Record
With over 10 years of experience, we have successfully trained professionals from leading organizations across different industries and regions.
Contact us for more detail about our trainings and for all other enquiries!

Avaible Training Dates

Join our public courses in our Saudi Arabia facilities. Private class trainings will be organized at the location of your preference, according to your schedule.

We can organize this training at your preferred date and location.
27 Shawwal 1447 (5 Days)
Riyadh, Jeddah, Dammam, Neom
€5,390 +VAT
07 Dhuʻl-Qiʻdah 1447 (5 Days)
Riyadh, Jeddah, Dammam, Neom
€5,390 +VAT
18 Dhuʻl-Qiʻdah 1447 (5 Days)
Riyadh, Jeddah, Dammam, Neom
€5,390 +VAT
20 Dhuʻl-Qiʻdah 1447 (5 Days)
Riyadh, Jeddah, Dammam, Neom
€5,390 +VAT
22 Dhuʻl-Qiʻdah 1447 (5 Days)
Riyadh, Jeddah, Dammam, Neom
€5,390 +VAT
15 Dhuʻl-Hijjah 1447 (5 Days)
Riyadh, Jeddah, Dammam, Neom
€5,390 +VAT
16 Dhuʻl-Hijjah 1447 (5 Days)
Riyadh, Jeddah, Dammam, Neom
€5,390 +VAT
18 Dhuʻl-Hijjah 1447 (5 Days)
Riyadh, Jeddah, Dammam, Neom
€5,390 +VAT

Blog posts related to Oracle Database 23ai: Administration Workshop Training Course

WHO IS AN ORACLE DATABASE ADMINISTRATOR (DBA)?

An Oracle Database Administrator (DBA) is a technical specialist responsible for ensuring the stability, security, performance, and availability of Oracle database systems.

What Is Oracle 23ai? What Has Changed Compared to Previous Versions?

Oracle Database 23ai represents Oracle’s strategic shift toward an AI-native database architecture. Unlike Oracle 19c (long-term support) and 21c (innovation-focused), 23ai embeds artificial intelligence directly into the database engine.

Saudi Arabia is currently undergoing one of the most significant digital transformations in modern history under the umbrella of Vision 2030. Riyadh, Jeddah, and the revolutionary smart-city project NEOM are at the forefront of this technological leap, focusing on non-oil economic growth through digital innovation. The Kingdom is investing billions into cloud infrastructure, AI research, and cybersecurity to protect its national interests and support a burgeoning private tech sector. Our educational frameworks in Saudi Arabia are aligned with this national transformation, providing the workforce with essential skills to manage mega-scale digital projects. We empower Saudi professionals to take the lead in building a tech-driven future that honors the Kingdom's heritage while embracing the possibilities of the Fourth Industrial Revolution.

Bilginç IT Academy All Rights Reserved

By using this website you agree to let us use cookies. For further information about our use of cookies, check out our Cookie Policy.