Reports are only as good as the data pipelines beneath them, and many organisations still rebuild the same spreadsheets by hand from ERP exports. Engineers who can move, clean and model data reliably are in short supply. This ten-day, lab-driven programme turns analysts, developers and ERP users into capable data engineers. The first week covers relational design, normalisation, entity relationship diagrams, advanced SQL with joins, window functions and indexing, and Python with pandas for transformation, together with PostgreSQL and SQL Server style administration basics.
The second week applies these skills to real integration work: extracting data from SAP, Oracle, Microsoft Dynamics and Odoo style ERP modules, building ETL and ELT pipelines, scheduling with Airflow, modelling star schema warehouses, validating data quality, handling cloud storage and publishing curated tables to Power BI. A final project delivers an end-to-end pipeline from ERP tables to a dashboard. Data analysts, BI developers, database administrators, ERP super users, software developers, finance systems staff and ICT officers in banks, utilities, government and NGOs will find it immediately useful. Classroom, online and in-house delivery is available with a CPD-accredited certificate. Afterwards you can design, build and maintain dependable data flows.
Modern organisations generate data in dozens of systems, with the ERP at the centre holding finance, procurement, inventory, sales and human resources records. Getting that data into a form that analysts and leaders can trust requires engineering, not just exporting files. Manual extracts break, definitions drift between departments and reports disagree, which erodes confidence in the numbers.
This practical programme runs for ten days and builds data engineering skills from the ground up. Participants start with relational database design and structured query language, working through normalisation, keys and constraints, complex queries, window functions, views, stored procedures and performance tuning. They then learn Python for data work, using pandas to read, reshape, validate and combine data from files, databases and web services. The middle of the course introduces data architecture, including staging areas, data warehouses and lakes, dimensional modelling, and the difference between ETL and ELT.
The second half concentrates on ERP data. Participants study typical ERP table structures and master and transactional data, extract data through database connections, APIs and reports, and resolve problems such as inconsistent codes, duplicates and history. They build scheduled pipelines, implement quality checks and logging, apply security and access controls, and publish curated datasets for analytics. The programme closes with a capstone project in which each participant delivers a documented pipeline and warehouse for a realistic business case.
By the end of the course, participants will be able to:
Participants leave the course with:
The course is more than three-quarters hands-on, with every concept followed by a lab. Participants will experience:
Day 1: Data Engineering and Relational Foundations
Day 2: SQL Essentials
Day 3: Advanced SQL and Performance
Day 4: Python for Data Work
Day 5: Data Architecture and Warehousing Concepts
Day 6: Understanding ERP Data
Day 7: Building ETL Pipelines
Day 8: Orchestration and Cloud Data Services
Day 9: Data Quality, Governance and Reporting Layers
Day 10: Capstone Project and Review
The course is designed for technical and semi-technical professionals who work with organisational data, including:
Participants who attend the ten days, complete the daily labs and submit the capstone project receive a CPD-accredited Certificate of Completion issued by Vision Reach Global Consultancy.
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 Practical Data Engineering, Databases & ERP Data programme, you'll be able to design normalised relational schemas and document them with entity relationship diagrams, write advanced sql queries, views and procedures and tune their performance, use python and pandas to clean, transform and combine data from multiple sources, and build and schedule etl and elt pipelines with logging and error handling. The full breakdown of topics is covered session by session in the Course Outline tab above.
The course is designed for technical and semi-technical professionals who work with organisational data, including: Data analysts and business intelligence developers, Database administrators and systems administrators, ERP super users, functional consultants and finance systems officers, Software developers moving into data roles, Statisticians and M&E data officers in NGOs and government, ICT officers in banks, utilities, telecoms and public institutions, Internal auditors who analyse ERP data, and Graduates entering data engineering careers.
Practical 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.
Practical 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 Practical Data Engineering, Databases & ERP Data starts November 2, 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 Practical 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.
Practical Data Engineering, Databases & ERP Data Training Course is pitched at intermediate 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 Practical 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 — Practical 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