Live Online Fundamentals of Data Engineering, Databases & ERP Data Training Course
Live online, instructor-led · next cohort Nov 9, 2026 · from USD 1,700
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.
At a Glance
How Live Online Training Works
Live online training, led by a trainer in real time, for participants anywhere.
More about live online training →- Format
- Live online, instructor-led
- Duration
- Mon - Fri (10 Days)
- Fee
- USD 1,700 (KES 160,000)
- Next start dates
- Nov 9, 2026, Dec 7, 2026, Jan 4, 2027
- Certificate
- Certificate of Completion
- What you need
- A computer with a reliable internet connection, a webcam and a headset
About this course
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.
Training Objectives
After completing the programme, participants will 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.
- Build a simple extract, transform and load pipeline using SQL and Python.
- Apply data cleaning and data quality tests to incoming data.
- Design a star schema for reporting and analytics.
- Explain how ERP modules store master and transactional data and how they relate.
- Extract and reconcile ERP data for reporting or migration.
What you'll learn
Key Takeaways
Participants leave with:
- A working relational database designed from a business scenario.
- A library of SQL queries for common reporting tasks.
- A small automated pipeline that loads and checks data on a schedule.
- A star schema design for a reporting use case.
- A map of how major ERP modules share data and where reports draw from.
- A study path and portfolio project to continue building their data skills.
Training Methodology
The course is built for beginners and relies on guided practice. Learning methods include:
- Short explanations followed immediately by laboratory exercises
- Realistic business datasets from finance, procurement and sales
- Pair programming and troubleshooting clinics for new learners
- Walkthroughs of ERP screens, tables and reports
- A capstone project presented to peers for feedback
Day 1: Databases and the Relational Model
- What data engineers do and where databases fit
- Tables, rows, columns, primary and foreign keys
- Data types and constraints
- Setting up PostgreSQL or MySQL and a client tool
- Reading a schema and exploring a database
- Lab: first queries on a business database
Day 2: SQL for Querying Data
- SELECT, WHERE, ORDER BY and LIMIT
- Functions for text, dates and numbers
- Aggregation with GROUP BY and HAVING
- Handling nulls and duplicates
- Writing readable and reusable queries
- Lab: answering business questions with SQL
Day 3: Joins, Subqueries and Data Modification
- Inner, left, right and full joins
- Subqueries and common table expressions
- Views and their uses
- INSERT, UPDATE and DELETE with care
- Transactions and data integrity
- Lab: combining customer, order and product tables
Day 4: Data Modelling and Database Design
- Entity relationship diagrams
- Normalisation and its trade-offs
- Indexing and query performance basics
- Backup, security and access roles
- Operational versus analytical design
- Project: designing a database for a business process
Day 5: Python and Data Preparation
- Python basics for data work
- Reading CSV, Excel and JSON files with pandas
- Cleaning, reshaping and merging datasets
- Connecting Python to a database
- Writing clean and reproducible scripts
- Lab: cleaning a messy dataset and loading it to SQL
Day 6: Building ETL Pipelines
- Extract, transform and load patterns
- Working with files, APIs and operational databases
- Incremental versus full loads
- Scheduling and orchestration concepts
- Logging, error handling and monitoring
- Lab: building and scheduling a pipeline
Day 7: Data Quality, Testing and Version Control
- Data quality checks at each pipeline stage
- Reconciliation and control totals
- Unit tests for data transformations
- Git basics for scripts and SQL
- Documentation and data lineage
- Lab: adding quality tests to the pipeline
Day 8: Data Warehousing and Dimensional Modelling
- Data warehouse, data mart and data lake concepts
- Facts, dimensions and star schemas
- Slowly changing dimensions
- Loading a warehouse and building aggregates
- Connecting reporting tools to the warehouse
- Lab: designing and loading a sales star schema
Day 9: ERP Data Structures
- ERP architecture and module integration
- Master data: customers, vendors, materials and accounts
- Transactional data and document flow in finance, procurement and inventory
- Organisational structures and configuration data
- Tables and naming in SAP, Oracle and Odoo examples
- Exercise: tracing a purchase-to-pay transaction through its tables
Day 10: ERP Extraction, Reporting and Capstone
- Extraction methods: reports, exports, views and APIs
- Data migration, mapping and cleansing for ERP projects
- Reconciling ERP data to financial reports
- Governance, access and audit trails for ERP data
- Capstone: pipeline from an ERP-style source to a warehouse report
- Presentations and learning plan
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
- Managers who supervise reporting and data teams
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.
Choose Where You Want to Learn
Fundamentals of Data Engineering, Databases & ERP Data Training Course Venues
KenyaNairobiNext Nov 9· 13 dates$3,000- KenyaMombasaNext Oct 26· 13 dates$3,200
- KenyaNaivashaNext Nov 2· 13 dates$3,000
- KenyaKisumuNext Oct 26· 13 dates$3,000
- KenyaMachakosNext Nov 2· 13 dates$3,200
UgandaKampalaNext Nov 2· 13 dates$3,800
RwandaKigaliNext Oct 26· 13 dates$3,800
TanzaniaArushaNext Nov 9· 13 dates$3,800- TanzaniaDodomaNext Oct 26· 13 dates$3,600
- TanzaniaDar es SalaamNext Oct 26· 13 dates$4,000
- TanzaniaZanzibarNext Nov 16· 13 dates$5,200
NigeriaLagosNext Nov 16· 13 dates$5,600- NigeriaAbujaNext Nov 9· 13 dates$5,600
South AfricaPretoriaNext Nov 2· 13 dates$6,400- South AfricaJohannesburgNext Nov 2· 13 dates$6,800
- South AfricaCape TownNext Oct 26· 13 dates$7,600
UAEDubaiNext Oct 26· 13 dates$7,600
GhanaAccraNext Nov 16· 13 dates$9,000
Scroll sideways to see all 18 cities →
Frequently Asked Questions About Live Online Fundamentals of Data Engineering, Databases & ERP Data Training Course
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 November 9, 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
More Database Management Systems Courses
Structured Query Language (SQL) Fundamentals Training Course
Key Skills You'll Learn
- Understand core structured query language (SQL) fundamentals principles and how they fit together in practice.
- Apply practical techniques for SQL syntax and structure in day-to-day implementation.
Vision Reach Global
From $3,000 · KSh 230,000
Database Architect Training Course
Key Skills You'll Learn
- Understand core database architect principles and how they fit together in practice.
- Apply practical techniques for OLTP vs. OLAP processing in day-to-day implementation.
Vision Reach Global
From $3,000 · KSh 230,000
Database Integration using SQL Server Integration Services (SSIS) Training
Key Skills You'll Learn
- Understand core database integration using SQL server integration services (SSIS) principles and how they fit together in practice.
- Apply practical techniques for error handling & logging in day-to-day implementation.
Vision Reach Global
From $3,000 · KSh 230,000
Data Modeling and Database Design Training Course
Key Skills You'll Learn
- Understand core data modeling and database design principles and how they fit together in practice.
- Apply practical techniques for entity and data modeling in day-to-day implementation.
Vision Reach Global
From $3,000 · KSh 230,000
Also Live Online
Other Live Online Courses
A-Z for Risk, Reliability and Safety Management Training
Key Skills You'll Learn
- Master core concepts and frameworks in a-z for risk, reliability and safety man
- Apply practical tools and methodologies to your own organizational context
Vision Reach Global
From $1,500 · KSh 115,000
Accounting for NGOs Using QuickBooks Training
Key Skills You'll Learn
- Master core accounting for ngos using quickbooks training concepts and frameworks.
- Apply relevant tools and techniques in your organizational context.
Vision Reach Global
From $1,500 · KSh 115,000
Accounts Payable and Operations Training Course
Key Skills You'll Learn
- Understand core accounts payable and operations principles and how they fit together in practice.
- Apply practical techniques for accounts payable and operations in day-to-day implementation.
Vision Reach Global
From $1,500 · KSh 110,000
Accounts Receivable Management and Development of Credit Policies Training
Key Skills You'll Learn
- Understand core accounts receivable management and development of credit policies principles and how they fit together in practice.
- Apply practical techniques for accounts receivable module 1 in day-to-day implementation.
Vision Reach Global
From $1,500 · KSh 115,000
Achievement of Gender Equity in Development Projects Training
Key Skills You'll Learn
- Master core achievement of gender equity in development projects training concepts and frameworks.
- Apply relevant tools and techniques in your organizational context.
Vision Reach Global
From $1,500 · KSh 115,000
Achieving Strategy through Leadership: Strategy and Innovation Training Course
Key Skills You'll Learn
- Understand core achieving strategy through leadership: strategy and innovation principles and how they fit together in practice.
- Apply practical techniques for managing strategic risks in day-to-day implementation.
Vision Reach Global
From $1,500 · KSh 115,000
What Our Clients Say
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
Looking for a different city or delivery format? See every date for Fundamentals of Data Engineering, Databases & ERP Data Training Course or browse every live online course.