Database Design and SQL Querying
Well designed databases and clear queries underpin almost every business application. This course covers how to design relational databases and retrieve data using SQL. Participants model data, build tables, and write queries against realistic datasets.
Course outline
What this programme covers, module by module.
- 01Modelling business data into related tables
- 02Applying normalisation to reduce redundancy
- 03Creating tables, keys, and constraints
- 04Writing SQL queries to retrieve data
- 05Joining, filtering, grouping, and aggregating results
- 06Updating and deleting data safely
- 07Understanding indexes and query performance
What you will gain
- Model data into related tables
- Apply normalisation principles
- Create tables and constraints
- Write queries to retrieve data
- Join, filter, and aggregate results
- Update data safely and correctly
Who should attend
- Analysts and report writers
- Application developers
- Database administrators
- Technical staff working with data
Upcoming sessions
| Date | City | Duration | Fees | Book |
|---|---|---|---|---|
| 26 to 30 Oct 2026 | Johannesburg | 5 Days | R18,000 | |
| 16 to 20 Nov 2026 | London | 5 Days | US$1,800 | |
| 30 Nov to 4 Dec 2026 | Dubai | 5 Days | US$1,800 | |
| 11 to 15 Jan 2027 | Pretoria | 5 Days | R18,000 | |
| 1 to 5 Mar 2027 | Durban | 5 Days | R18,000 | |
| 3 to 7 May 2027 | Cape Town | 5 Days | R18,000 | |
| 5 to 9 Jul 2027 | Johannesburg | 5 Days | R18,000 |
Fees are per delegate and exclude VAT. Public intakes are confirmed once minimum numbers are met. We also deliver this course on your own schedule, in-house or live online.
Enquire about this course
Register your team or ask for a tailored in-house quote. We reply within one working day.
WhatsApp usCourse brochure (PDF)- Fees from
- R18,000 per delegate
- Duration
- 5 Days
- Field
- IT & Digital Skills
- Formats
- In-house, public, online
More in IT & Digital Skills
Cybersecurity Fundamentals for Professionals
Every organisation now depends on systems and data that attackers actively seek to exploit. This course builds a practical understanding of cyber threats and the defences that reduce them. Participants study common attacks, security controls, and the response to incidents.
Spreadsheet to Database Migration for Teams
Teams outgrow a shared spreadsheet long before they admit it, usually at the point where two people are editing different copies. This course covers moving that work into something that holds.
Cloud Computing Foundations
Cloud services have changed how organisations build, run, and pay for technology. This course explains the concepts, models, and benefits of cloud computing in plain terms. Participants examine service models, deployment options, and the basics of cost and security.