Oracle Database 23ai: SQL Workshop Training in Ireland

Oracle Database 23ai: SQL Workshop is a hands-on and in-depth training designed for professionals aiming to master the fundamentals and advanced capabilities of SQL within Oracle’s latest 23c architecture. More than theory, it offers real-world data manipulation scenarios and end-to-end database practice.

You’ll benefit most if you have:

• A basic understanding of data processing concepts

• Familiarity with any programming language (e.g., Python, Java, C#)

• No prior SQL experience required—but a technical mindset helps

This course is ideal for:

• Software Developers (Backend, Full Stack, Data-Driven Roles)

• Database Administrators (DBAs)

• Data Analysts and Reporting Specialists

• IT Professionals Reskilling into SQL

• Anyone working in Oracle environments

• Beginners looking to learn SQL properly

Upon completion, participants will be able to:

• Understand Oracle 23c database architecture and SQL’s role

• Query and filter data from single and multiple tables

• Use single-row and multi-row functions to customize output

• Handle subqueries, joins, views, sequences, indexes, and synonyms

• Perform data insertion, updates, and deletion with DML

• Manage users, roles, and object-level privileges

• Work with different time zones and temporal data

• Write powerful, performance-tuned, and secure SQL statements

• Gain readiness for real-world enterprise database environments

1. Introduction to Oracle 23c

• Architecture & Products

• RDBMS concepts & terminology

• SQL Development Tools & Documentation

2. Retrieving Data with SELECT

• SELECT capabilities

• Arithmetic expressions & NULL

• Column aliases, DESCRIBE command

3. Filtering & Sorting Data

• WHERE clause

• ORDER BY and sorting

• Substitution variables & row limiting

4. Single-Row Functions

• String, number, and date functions

• Customizing query output

5. Conversion & Conditional Expressions

• Implicit/explicit conversions

• TO_CHAR, TO_DATE, CASE, DECODE, JSON support

6. Aggregating Data with Group Functions

• SUM, COUNT, AVG, MAX, MIN

• Nested aggregation, grouping logic

7. Joins: Working with Multiple Tables

• INNER, OUTER, SELF, CARTESIAN joins

• USING, ON, NATURAL JOIN syntax

8. Solving Queries with Subqueries

• Single-row & multi-row subqueries

• EXISTS, NOT EXISTS, correlated subqueries

9. Set Operators

• UNION, UNION ALL, INTERSECT, MINUS

• Combining query results cleanly

10. Managing Tables with DML

• INSERT, UPDATE, DELETE

• Transactions, read consistency, locking

11. Data Definition Language (DDL)

• Creating tables & constraints

• ALTER and DROP operations

12. Exploring Data Dictionary Views

• Oracle system views

• Querying metadata, adding comments

13. Working with Sequences, Synonyms, Indexes

• Automating values (SEQUENCE)

• Synonyms for aliasing

• Performance through indexing

14. Creating and Using Views

• View creation, modification

• DML with views, dropping views

15. Schema Object Management

• Temporary & external tables

• Managing constraints and structural integrity

16. Retrieving Data via Subqueries

• Using subqueries as data sources

• Scalar and correlated subquery usage

17. Data Manipulation with Subqueries

• Inserting, updating, deleting using subqueries

• WITH CHECK OPTION, update restrictions

18. Controlling User Access

• Object vs system privileges

• Creating roles, granting/revoking access

19. Advanced SQL Techniques

• Default values, multitable inserts

• MERGE operations, Flashback, data tracking

20. Time Zone & Temporal Data Management

• CURRENT_TIMESTAMP, DBTIMEZONE, LOCALTIMESTAMP

• Using SYSDATE, INTERVAL, and temporal queries effectively