Beplugged Tech — home
All courses
Oracle

Oracle Database SQL for Data Teams

Five days of hands-on SQL on Oracle Database: SELECT queries, joins, subqueries, grouping and aggregation, data manipulation, table design, and writing queries that perform well. The course uses realistic datasets from banking, telecoms and government — the sectors where Oracle Database is most widely deployed in Africa.

Prepares for Oracle Database SQL Certified Associate certification

Duration
5 days
Level
Beginner
Delivery
In Pretoria, at your offices, or live online
Group size
Individuals or whole teams
What you will learn
  • Write SELECT queries with filtering, sorting and joins
  • Use subqueries, grouping and aggregation for analysis
  • Insert, update and delete data safely
  • Create tables, constraints and indexes
  • Write queries that perform well on large datasets
Course outline
  1. 1Database concepts and SELECT. Relational concepts, tables, the SELECT statement, WHERE, ORDER BY and aliases.
  2. 2Joins and subqueries. Inner, outer and cross joins; correlated and non-correlated subqueries.
  3. 3Grouping and aggregation. GROUP BY, HAVING, aggregate functions and analytical functions.
  4. 4Data manipulation. INSERT, UPDATE, DELETE, MERGE and transaction control (COMMIT, ROLLBACK).
  5. 5Tables, constraints and performance. CREATE TABLE, primary and foreign keys, indexes, EXPLAIN PLAN and query tuning.
Upcoming dates
10–14 Feb 2027Live online12 seats left
Book

Need a different date? Tell us when suits you — we schedule courses on demand for teams and individuals.

Who it is for

Data analysts, database administrators, developers and reporting staff who work with Oracle databases.

Before you start

None. No prior SQL or database experience needed.

How the training runs
  • In person in Pretoria, South Africa; at your offices anywhere; or live online on Microsoft Teams or Google Meet.
  • International delegates are welcome in Pretoria — we arrange invitation letters for visa applications and recommend hotels near the venue.
  • Run for your team only, on dates that suit you, with examples from your own work; or join an open course.
  • Hands-on throughout: learners practise each step on their own device, not just watch.
  • A certificate of completion that can be verified online.
Questions
Which Oracle Database version is used?

Exercises run on Oracle Database 19c or 21c, or Oracle Autonomous Database. The SQL covered applies to any recent Oracle version.

Where is the training held?

At your offices anywhere in South Africa or at our training centre in Pretoria. For international delegates, we arrange training in Pretoria with joining instructions and hotel recommendations. Live online delivery on Microsoft Teams or Google Meet is also available.

Do you train organisations outside South Africa?

Yes. We work with organisations across Africa and beyond. International delegates can attend in person in Pretoria, South Africa, or join live online. We arrange invitation letters for visa applications and handle all logistics.

Can the course be run for our team only?

Yes. Most courses are run in-house for one organisation, on dates that suit you, with examples from your own work. Larger teams are split into groups.

What do learners receive?

A Beplugged Tech certificate of completion that anyone can verify online. Where a course prepares for a certification exam (Certiport, Microsoft, Oracle, Google), the exam can be arranged at our testing centre or through the certification body.

How do we book, and what does it cost?

Send the enquiry form on this page with the number of people and your preferred dates. We reply within one working day with dates, the full outline and a quote.

Related courses