Advanced SQL Querying Training

Data Science, Digital M&E & AI · 10 Days

Course Overview

Structured Query Language remains the backbone of data work in government agencies, development organizations, financial institutions and enterprises across Africa. As datasets grow in size and complexity, basic SELECT statements are no longer enough. Analysts and developers need advanced techniques to extract, reshape and summarize data accurately and efficiently. This ten-day, hands-on programme takes delegates from a solid foundation to advanced proficiency. Through practical labs built on realistic programme, finance, health and survey datasets, participants learn multi-table joins, subqueries, common table expressions, window functions, recursive queries, data transformation, indexing and performance tuning. The course also covers procedural logic, views, stored procedures, transactions and data quality practices, so delegates can build reusable, secure and production-ready database solutions. By the end, participants will be able to design analytical queries that support dashboards, M&E reporting, audits and strategic planning with confidence.

Who Should Attend

  • Data analysts and data scientists
  • Monitoring, evaluation and learning officers working with databases
  • Database administrators and developers
  • Business intelligence and reporting specialists
  • Software developers and IT officers
  • Research and statistics officers
  • Finance and audit analysts who work with large datasets
  • Graduates and professionals seeking to move from basic to advanced SQL

Learning Objectives

  • Write complex multi-table queries using all join types and set operations
  • Apply subqueries and common table expressions to solve layered analytical problems
  • Use window functions for ranking, running totals, moving averages and period comparisons
  • Transform, clean and reshape data using string, date and conditional functions
  • Diagnose slow queries using execution plans and improve them through indexing and rewriting
  • Create views, stored procedures and functions for reusable logic
  • Manage transactions and enforce data integrity and security
  • Build analytical queries that feed dashboards and operational reports

Key Takeaways

Course Curriculum

1

Relational Database Concepts and SQL Refresher

2

Mastering Joins

3

Set Operations and Subqueries

4

Common Table Expressions and Recursive Queries

5

Window Functions: Ranking and Partitioning

6

Window Functions: Aggregates and Time Analysis

7

Data Transformation and Cleaning

8

Advanced Aggregation and Analytical Reporting

9

Query Performance and Execution Plans

10

Views, Functions and Stored Procedures

11

Transactions, Concurrency and Data Integrity

12

Security, Governance and Working with Large Datasets

13

Capstone Project: End-to-End Analytical Solution

Requirements

Participants should have a working knowledge of basic SQL, including SELECT, WHERE, GROUP BY and simple joins. Familiarity with relational database concepts is recommended. Delegates should bring a laptop with administrative rights for installing the course software.

Certification

Delegates who complete the programme receive a Certificate of Completion issued by EcoTrio Impact Growth and Development Centre (EIGDC).

Frequently Asked Questions

What are the prerequisites for attending this course?

Participants should have a working knowledge of basic SQL, including SELECT, WHERE, GROUP BY and simple joins. Familiarity with relational database concepts is recommended. Delegates should bring a laptop with administrative rights for installing the course software.

Will I receive a certificate upon completing the course?

Delegates who complete the programme receive a Certificate of Completion issued by EcoTrio Impact Growth and Development Centre (EIGDC).

Can this training be delivered on-site for our organisation?

Yes. Ecotrio Impact Growth and Development Centre (EIGDC) offers a bespoke in-house delivery option for Advanced SQL Querying, tailored to your organisation's context within Data Science, Digital M&E & AI. Contact our training team to discuss customisation, scheduling and group pricing.

Is this course available online for participants who cannot travel?

Yes. Selected cohorts of this course are available as live virtual sessions delivered over video conferencing by an experienced facilitator, with the same certificate issued on completion as the in-person format.

What will I be able to do after completing this course?

By the end of this course, you will be able to write complex multi-table queries using all join types and set operations, apply subqueries and common table expressions to solve layered analytical problems, use window functions for ranking, running totals, moving averages and period comparisons, transform, clean and reshape data using string, date and conditional functions, diagnose slow queries using execution plans and improve them through indexing and rewriting, create views, stored procedures and functions for reusable logic, manage transactions and enforce data integrity and security, and build analytical queries that feed dashboards and operational reports. The programme is designed to be immediately applicable to your day-to-day role.

Upcoming Sessions

LocationDatesMode
Pretoria, South Africa 09 Nov 2026 – 18 Nov 2026 Classroom Register →
Zanzibar, Tanzania 09 Nov 2026 – 18 Nov 2026 Classroom Register →
Mombasa, Kenya 09 Nov 2026 – 18 Nov 2026 Classroom Register →
Kampala, Uganda 09 Nov 2026 – 18 Nov 2026 Classroom Register →
Johannesburg, South Africa 09 Nov 2026 – 18 Nov 2026 Classroom Register →
Live Virtual 09 Nov 2026 – 18 Nov 2026 Online Register →
Nairobi, Kenya 09 Nov 2026 – 18 Nov 2026 Classroom Register →
Kigali, Rwanda 16 Nov 2026 – 25 Nov 2026 Classroom Register →
Cape Town, South Africa 16 Nov 2026 – 25 Nov 2026 Classroom Register →
Dubai, United Arab Emirates 16 Nov 2026 – 25 Nov 2026 Classroom Register →
Dar es Salaam, Tanzania 23 Nov 2026 – 02 Dec 2026 Classroom Register →
Cairo, Egypt 23 Nov 2026 – 02 Dec 2026 Classroom Register →

Ready to Register for Advanced SQL Querying Training?

See full pricing, exact upcoming dates across South Africa, Tanzania, Kenya, and secure your seat online in minutes.

Book This Training →