Every report, dashboard and forecast depends on someone getting data out of source systems, cleaning it and making it available in a usable shape. Over ten days, newcomers build that skill from the ground up. You begin with how databases work: tables, keys, relationships, normalisation, entity relationship diagrams and SQL for querying, joining, aggregating and modifying data. Early sessions also cover data types, indexing, transactions and the difference between transactional and analytical systems.
The programme then introduces data engineering practice: extracting data from files, APIs and operational databases, transforming it with SQL and Python, loading it into a warehouse or data mart, and scheduling and monitoring pipelines. A dedicated block explains how ERP systems such as SAP, Oracle and Odoo organise master and transactional data across finance, procurement, inventory, sales and human resources, and how to extract and reconcile it for reporting. The course suits graduates, ICT and database staff, business and data analysts, ERP users and super-users, accountants and auditors. By the end you can design a small database and a working pipeline. Delivery is classroom, online or in-house, with a CPD-accredited certificate.
Organisations in Africa are digitising finance, supply chains, service delivery and customer channels, and the data these systems generate is growing quickly. Yet reporting teams spend most of their time finding, cleaning and reconciling data by hand, and ERP implementations often disappoint because the data inside them is poorly understood. Foundational data engineering skills close this gap.
The Fundamentals of Data Engineering, Databases & ERP Data Training Course assumes no prior programming experience. The first four days teach relational database concepts, data modelling and SQL, from basic queries to joins, subqueries, views and performance basics. Days five to seven introduce Python, data cleaning, extract-transform-load design, workflow scheduling and data quality checks. The next part of the programme covers data warehousing, dimensional modelling and the principles that make analytics dependable. The final days focus on enterprise resource planning data, including table structures, master data, document flows and how to extract data for reporting and migration.
Every topic is taught through laboratories using realistic business datasets. Participants complete a capstone project in which they model a database, build a pipeline from an ERP-style source into a warehouse, and present a simple report that proves the data is reliable.
After completing the programme, participants will be able to:
Participants leave with:
The course is built for beginners and relies on guided practice. Learning methods include:
Day 1: Databases and the Relational Model
Day 2: SQL for Querying Data
Day 3: Joins, Subqueries and Data Modification
Day 4: Data Modelling and Database Design
Day 5: Python and Data Preparation
Day 6: Building ETL Pipelines
Day 7: Data Quality, Testing and Version Control
Day 8: Data Warehousing and Dimensional Modelling
Day 9: ERP Data Structures
Day 10: ERP Extraction, Reporting and Capstone
The course is designed for people starting out with data, as well as users of business systems who want to understand what lies beneath them, including:
A CPD-accredited Certificate of Completion, issued by Vision Reach Global Consultancy, is awarded to participants who attend the ten days and complete the labs and the capstone project.
Upcoming cohorts
CPD-Accredited
Official invoice & confirmation letter provided
Team discount for 3+ seats
Need help with this booking?
Our training team can help with group pricing, invoicing, or picking the right schedule.
Everything you need to know about this course before you register.
By the end of the Fundamentals of Data Engineering, Databases & ERP Data programme, you'll be able to explain how relational databases store and relate data using tables, keys and constraints, design a normalised database and document it with an entity relationship diagram, write sql queries that filter, join, group, summarise and update data, and build a simple extract, transform and load pipeline using sql and python. The full breakdown of topics is covered session by session in the Course Outline tab above.
The course is designed for people starting out with data, as well as users of business systems who want to understand what lies beneath them, including: Graduates and trainees entering ICT, data or analytics roles, Database administrators and ICT support officers, Business and data analysts, ERP end users, super-users and implementation team members, Accountants, finance analysts and auditors who query system data, Monitoring and evaluation and research data officers, Procurement, inventory and operations analysts, Software developers new to databases, and Managers who supervise reporting and data teams.
Fundamentals of Data Engineering, Databases & ERP Data Training Course typically runs as 10 Days. It's available as in-person classroom, live virtual, and in-house corporate training — every course can also be delivered on-site for your team on dates that suit you.
Fundamentals of Data Engineering, Databases & ERP Data Training Course is scheduled in-classroom in Nairobi, Kenya, Mombasa, Kenya, Naivasha, Kenya, and Kisumu, Kenya, and 14 other locations, plus a live interactive virtual classroom you can join from anywhere. Check the schedule panel above for exact upcoming dates and fees in each location.
The next live virtual cohort of Fundamentals of Data Engineering, Databases & ERP Data starts October 12, 2026, with new classroom cohorts also running on a rolling basis. Pick a date and location in the schedule panel above, then click "Register for the Course" — it takes a few minutes and your seat is confirmed once payment or a signed purchase order is received.
Yes — delegates who meet the attendance requirement receive a Certificate of Completion for Fundamentals of Data Engineering, Databases & ERP Data Training Course from Vision Reach Global Consultancy, issued in the name you register with, so double-check the spelling at checkout.
Fundamentals of Data Engineering, Databases & ERP Data Training Course is pitched at beginner professionals. If you're unsure whether it's the right fit for your current role or background, message our training advisors before you register and they'll help you confirm.
Fees for Fundamentals of Data Engineering, Databases & ERP Data Training Course vary by delivery location and format and are shown in real time in the schedule panel above once you pick a date. Register 3 or more delegates on the same course together and a 5% team discount is applied automatically — larger cohorts can request a custom corporate quote.
Yes — Fundamentals of Data Engineering, Databases & ERP Data Training Course can be delivered on-site at your offices (or virtually for distributed teams), with case studies and examples tailored to your industry and the specific challenges your team is working through. Switch to the "In-House" tab in the schedule panel above to request a proposal.
Related Training
Key Skills You'll Learn
Vision Reach Global
From $3,000 · KSh 230,000
Key Skills You'll Learn
Vision Reach Global
From $3,000 · KSh 230,000
Key Skills You'll Learn
Vision Reach Global
From $3,000 · KSh 230,000
Swipe to see more courses →
VRG brings strategic discipline to complex organizational challenges. Their approach is structured, data-driven, and outcome-focused.
Levis Wabwire
Managing Director
They facilitated our strategy review, we improved departmental KPI alignment by 35% and reduced operational bottlenecks significantly.
David Oketch
Strategy Lead
Employee engagement scores increased following the leadership training program. The difference in accountability culture is evident.
Wendy Albright
Program Manager