Oracle Database 23ai: SQL Workshop Training in Bahrain

  • Delivery Method: Online Instructor-Led / Classroom Based / Onsite
  • Participation Model: Public Training / Private / In-House Training
  • Duration: 5 Days
  • Level: Intermediate
  • Price: From €6,100 +TAX
  • Upcoming Date:

Oracle Database 23ai: SQL Workshop is designed for developers and database administrators who want to build a solid understanding of relational database concepts and practical SQL usage.

The course begins with the fundamentals of relational databases and the SQL language, then progresses to querying one or multiple tables, filtering and sorting data, manipulating table contents, and creating database objects. Participants also learn how to create and work with sequences, synonyms, indexes, and views, manage schema objects, retrieve and modify data through subqueries, control user access, and handle date and time data across different time zones.

Note: The course is applicable to client environments using Oracle Database 18c, 19c, 21c, and 23ai.


For corporate groups, we can organize this training as an on-site private group.
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

Participants are expected to have basic familiarity with:

  • Data processing concepts and techniques
  • Programming languages

Who Should Attend

This course is intended for:

  • Developers
  • Database Administrators

What You Will Learn

By the end of the course, participants will be able to:

  • Explain the core concepts of Oracle Database 23c and related products.
  • Understand relational database management concepts and terminology.
  • Use SQL effectively to query Oracle databases.
  • Retrieve, restrict, and sort data with SQL statements.
  • Customize query output with single-row functions.
  • Convert data types and apply conditional expressions.
  • Produce aggregated reports with group functions.
  • Retrieve data from multiple tables by using joins.
  • Solve more complex queries with subqueries.
  • Manipulate result sets with set operators.
  • Manage table data through DML statements.
  • Create and maintain database objects such as sequences, synonyms, indexes, and views.
  • Control user privileges and access.
  • Work with date and time data across multiple time zones.

Training Outline

1. Introduction

  • Overview of Oracle Database 23c and related products
  • Relational Database Management concepts and terminology
  • Introduction to SQL and SQL development environments
  • Oracle Database 23c SQL documentation and additional learning resources

2. Retrieving Data with the SQL SELECT Statement

  • Capabilities of SQL SELECT statements
  • Arithmetic expressions and NULL values in SELECT
  • Using column aliases
  • The DESCRIBE command

3. Restricting and Sorting Data

  • Restricting returned rows with the WHERE clause
  • Sorting query results with the ORDER BY clause
  • Using the SQL Row Limiting Clause
  • Working with substitution variables
  • Assigning values to variables

4. Customizing Output with Single-Row Functions

  • Single-row SQL functions
  • Character functions
  • Number functions
  • Working with date values
  • Date functions

5. Using Conversion Functions and Conditional Expressions

  • Implicit and explicit data type conversion
  • TO_CHAR, TO_DATE, and TO_NUMBER
  • General-purpose functions: NVL, NVL2, NULLIF, COALESCE
  • Conditional expressions with CASE and DECODE
  • JSON functions

6. Reporting Aggregated Data with Group Functions

  • Group functions
  • Grouping rows
  • Nested group functions

7. Displaying Data from Multiple Tables with Joins

  • Join types and syntax
  • Natural Join
  • Joins using the USING clause
  • Joins using the ON clause
  • Self-Joins
  • Nonequijoins
  • Outer Joins
  • Cartesian Products

8. Solving Queries with Subqueries

  • Subquery types, syntax, and usage guidelines
  • Single-row subqueries
  • Multiple-row subqueries
  • Multiple-column subqueries
  • Handling NULL values in subqueries

9. Using Set Operators

  • Set operator types and usage guidelines
  • UNION and UNION ALL
  • INTERSECT
  • MINUS
  • Matching SELECT statements
  • Applying ORDER BY to set operation results

10. Managing Tables with DML Statements

  • Adding rows to a table
  • Updating table data
  • Removing rows from a table
  • Database transaction control
  • Read consistency
  • Manual data locking

11. Introduction to Data Definition Language

  • Database objects
  • The CREATE TABLE statement
  • Constraints
  • The ALTER TABLE statement
  • The DROP TABLE statement

12. Introduction to Data Dictionary Views

  • Understanding the Data Dictionary
  • Querying dictionary views
  • Adding comments to tables

13. Creating Sequences, Synonyms, and Indexes

  • Creating, maintaining, and using sequences
  • Creating private and public synonyms
  • Creating and maintaining indexes

14. Creating Views

  • Overview of views
  • Creating, modifying, and retrieving data through views
  • Performing DML operations on views
  • Dropping views

15. Managing Schema Objects

  • Managing constraints
  • Creating and using temporary tables
  • Creating and using external tables

16. Retrieving Data with Subqueries

  • Using a subquery as a data source
  • Using scalar subqueries in SQL
  • Solving problems with correlated subqueries
  • Using EXISTS and NOT EXISTS
  • Working with the WITH clause

17. Manipulating Data with Subqueries

  • Using subqueries in data manipulation operations
  • Inserting values by using a subquery as the target
  • Applying WITH CHECK OPTION in DML statements
  • Updating and deleting rows with correlated subqueries

18. Controlling User Access

  • Distinguishing system privileges from object privileges
  • Creating roles
  • Granting and revoking object privileges

19. Manipulating Data with Advanced Queries

  • Specifying explicit default values in INSERT and UPDATE statements
  • Performing Multitable INSERT operations
  • Merging rows in a table
  • Performing Flashback operations
  • Tracking changes in data over time

20. Managing Data Across Different Time Zones

  • CURRENT_DATE, CURRENT_TIMESTAMP, and LOCALTIMESTAMP
  • DBTIMEZONE and SESSIONTIMEZONE
  • TIMESTAMP and INTERVAL data types
  • Additional date functions
  • Handling date and time values with SYSDATE and SYSTIMESTAMP

Why Choose Us

Leading UK-based global training provider since 1995.

Experience Oracle Database 23ai: SQL Workshop in Bahrain through Bilginç IT Academy's live and interactive virtual classroom environment. Join a Public course as an individual delegate or arrange a dedicated Private / In-house online training program exclusively for your organization.

  • Delivery Method: Online Instructor-Led
  • Participation Model: Public / Private (In-house)
  • Live and Interactive Training: Connect with your instructor in real time and actively participate through discussions, Q&A sessions, practical exercises, and group activities.
  • Flexible Participation: Join the training from your home, office, or any location with a suitable internet connection.
  • Expert Trainer Network: Learn from experienced trainers with strong industry backgrounds and practical field expertise.
  • Over 30 Years of Training Expertise: Benefit from Bilginç IT Academy's professional training experience since 1995.
  • Worldwide Access: Join our live virtual classrooms from Bahrain or anywhere else in the world, or arrange a dedicated online training program for your organization.

Experience Oracle Database 23ai: SQL Workshop through face-to-face Classroom Based training in Bahrain. Training can be delivered as a Public course open to individual delegates or as a dedicated Private / In-house class for your organization.

  • Delivery Method: Classroom Based
  • Participation Model: Public / Private (In-house)
  • Face-to-Face Learning: Interact directly with your instructor and fellow delegates in an engaging classroom environment.
  • Experienced Trainers: Learn from specialists with extensive industry experience and practical real-world knowledge.
  • Professional Training Environment: Attend training in comfortable, well-equipped classrooms designed to support effective learning.
  • Practical Learning: Depending on the course, reinforce your knowledge through hands-on exercises, scenarios, case studies, and instructor-led activities.

Arrange Oracle Database 23ai: SQL Workshop in Bahrain as a dedicated Onsite training program for your organization. Bilginç IT Academy trainers can deliver the training at your office or another location of your choice, with the program planned around your team's requirements and business objectives.

  • Delivery Method: Onsite
  • Participation Model: Private (In-house)
  • Training at Your Preferred Location: Organize the training at your company's office or another location selected by your organization.
  • Tailored Course Content: Adapt the training program to your projects, team structure, existing skill levels, and specific business requirements.
  • Team-Focused Learning: Develop your team around a shared knowledge base while strengthening internal collaboration and knowledge transfer.
  • Flexible Scheduling: Plan the training dates, location, and program according to your organization's operational requirements.
  • Worldwide Onsite Delivery: Arrange the training in Bahrain or at another preferred location worldwide. Bilginç IT Academy trainers can travel to your selected location to deliver the dedicated training program.
Contact us for more detail about our trainings and for all other enquiries!

Oracle Database 23ai: SQL Workshop Training Course in Bahrain Schedule

Join our public live virtual trainings remotely from Bahrain. Private group trainings can also be organized at your preferred location in Bahrain, around your schedule.

For corporate groups, we can organize this training as an on-site private group.
01 November 2026 (5 Days)
Manama
€6,100 +TAX
07 November 2026 (5 Days)
Manama
€6,100 +TAX
10 November 2026 (5 Days)
Manama
€6,100 +TAX
12 November 2026 (5 Days)
Manama
€6,100 +TAX
18 November 2026 (5 Days)
Manama
€6,100 +TAX
21 November 2026 (5 Days)
Manama
€6,100 +TAX
26 November 2026 (5 Days)
Manama
€6,100 +TAX
01 January 2027 (5 Days)
Manama
€6,100 +TAX

Blog posts related to Oracle Database 23ai: SQL Workshop Training Course in Bahrain

The Journey to Becoming an Oracle Cloud Architect: Start with OCI from Scratch

For an IT professional looking to specialize in cloud technologies, simply knowing the names of cloud services is not enough. Designing a real cloud architecture requires an understanding of how compute, networking, storage, databases, identity, and security work together.

Oracle DBA Specialization Journey: From Administration to Performance Tuning

Oracle database administration is about much more than installing a database, creating users, or performing backups. In enterprise environments, an Oracle DBA (Database Administrator) plays a critical role in maintaining database availability, security, resource efficiency, and performance.

The Journey to Becoming an Oracle Developer: SQL, PL/SQL and 23ai

The Oracle Developer journey actually follows a fairly logical path: Learn SQL → move into PL/SQL → understand Oracle Database 23ai → build real projects. SQL teaches you how to work with data. PL/SQL allows you to build procedural logic inside the database. Oracle Database 23ai takes that foundation further with modern developer features, JSON capabilities, AI Vector Search, new SQL features, and more flexible application development options.

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.

Other trainings and courses related to the Oracle Database 23ai: SQL Workshop

Bahrain has positioned itself as the pioneering fintech and cloud capital of the Middle East, with Manama hosting the region’s first dedicated fintech hub, Bahrain FinTech Bay. As the first country in the region to adopt a 'Cloud First' policy, Bahrain has attracted global giants like AWS to establish massive data center infrastructures on its shores. The University of Bahrain and various national initiatives are focused on cultivating a workforce that is highly proficient in blockchain, open banking, and cybersecurity. Our IT education services in Bahrain are tailored to this innovation-driven market, offering advanced curriculum in Cloud Engineering, DevOps, and Information Security. We empower professionals in the Kingdom to take the lead in a digital-first economy that consistently sets the benchmark for regulatory technology and financial innovation across the Gulf.

© 2026 Bilginç IT Academy. All Rights Reserved.