Move data from its source to the warehouse, automatically and without loss.
Next intake: Monday 5 October, with enrolment open until 2 October. The following one starts on 4 January 2027.
Write advanced SQL queries: joins, window functions, common table expressions
Read an execution plan and fix a costly query
Extract and transform data with Python and pandas
Process a volume of data that does not fit in memory
Build a pipeline of dependent tasks, scheduled and re-runnable
Model a star-schema warehouse and keep the history of a dimension
Set up data quality tests and maintain a data catalogue
Systematic alternation between short theory sessions and practical work, with most of the time spent on practice
Progression from simple to complex: each module builds on what was learnt in the previous one
Realistic role-plays drawn from Cameroonian business cases
Considered use of generative AI as a working tool, in line with the common core
Regular formative assessments and a final integrative project drawing on all four modules
Formative assessment at the end of each module (graded role-play and practical exercises)
Practical work assessed against competency sheets
Final integrative project, presented and defended before the trainer
One graded assignment per module in the online course space
PostgreSQL — advanced SQL and demonstration warehouse
Python, pandas and a columnar format (Parquet)
A pipeline scheduler (Airflow or a lightweight equivalent)
dbt or equivalent for transformations and tests
An SQL client and an interactive notebook
Sessions open every quarter. Apply now or request the detailed brochure — our advisers will get back to you.