Skip to content

SQL and Data Querying Fundamentals for Analysts

The ability to query a database directly turns an analyst from a report consumer into someone who can answer their own questions. This practical course teaches SQL from first principles, giving delegates the confidence to pull, filter and combine data without waiting on the IT team. Every concept is reinforced through exercises on business datasets that reflect local operations.

Ready to book? Secure your place on this programme.

Register for this course

What you will be able to do

  • Retrieve and filter data using core SQL query statements.
  • Sort, group and summarise data to answer business questions.
  • Combine data from multiple tables using joins.
  • Use functions to clean and transform values within queries.
  • Write subqueries to answer more complex analytical questions.
  • Structure queries that are readable and easy to maintain.

Course outline

  1. 01How Relational Databases Store Data
  2. 02Selecting and Filtering Records
  3. 03Sorting and Grouping Results
  4. 04Summarising with Aggregate Functions
  5. 05Joining Multiple Tables
  6. 06Cleaning Data with Functions
  7. 07Subqueries and Nested Logic
  8. 08Writing Readable, Reliable Queries

Who should attend

Business and data analysts, finance staff, and reporting professionals who want to query databases directly.

Dates, venues and fees

DatesVenueDaysFeeCalendarRegister
28 to 30 Sep 2026Kampala3US$1,500Closed
29 Sep to 1 Oct 2026Accra3US$1,500Register
30 Sep to 2 Oct 2026Lagos3US$1,500Register
5 to 7 Oct 2026Cairo3US$1,500Register
6 to 8 Oct 2026Mauritius3US$1,500Register
7 to 9 Oct 2026Dubai3US$1,500Register
12 to 14 Oct 2026Online3US$900Register
4 to 6 Nov 2026Johannesburg3R13,000Register
9 to 11 Nov 2026Cape Town3R13,000Register
10 to 12 Nov 2026Durban3R13,000Register
11 to 13 Nov 2026Pretoria3R13,000Register
16 to 18 Nov 2026Windhoek3US$1,500Register
17 to 19 Nov 2026Gaborone3US$1,500Register
18 to 20 Nov 2026Maseru3US$1,500Register
23 to 25 Nov 2026Mbabane3US$1,500Register
24 to 26 Nov 2026Lusaka3US$1,500Register
25 to 27 Nov 2026Harare3US$1,500Register
30 Nov to 2 Dec 2026Lilongwe3US$1,500Register
1 to 3 Dec 2026Blantyre3US$1,500Register
2 to 4 Dec 2026Mozambique3US$1,500Register
7 to 9 Dec 2026Nairobi3US$1,500Register
8 to 10 Dec 2026Dar es Salaam3US$1,500Register
9 to 11 Dec 2026Kigali3US$1,500Register

Fees are per delegate. South African venues are priced in rand; other locations and online in US dollars. Fees exclude 15% VAT where applicable. Group bookings of three or more delegates from the same organisation qualify for a reduced rate; contact us for a quotation.

Related courses in Data, Digital and Cyber Security

Data, Digital and Cyber Security

Cyber Security Fundamentals for Business Teams

Most breaches begin with an ordinary employee making a reasonable decision on incomplete information.

Next session
29 Sep to 1 Oct 2026
Venue
Mbabane
3 day programme
FromR13,000
Data, Digital and Cyber SecurityNew

Artificial Intelligence for Business Managers

Artificial intelligence has moved from novelty to something managers are expected to have an opinion on.

Next session
29 Sep to 1 Oct 2026
Venue
Maseru
3 day programme
FromR13,000
See all Data, Digital and Cyber Security courses