Live Online Practical Data Engineering, Databases & ERP Data Training Course
Live online, instructor-led · next cohort Nov 2, 2026 · from USD 1,700
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.
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 2, 2026, Nov 30, 2026, Dec 28, 2026
- Certificate
- Certificate of Completion
- What you need
- A computer with a reliable internet connection, a webcam and a headset
About this course
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.
Training Objectives
By the end of the course, participants will 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.
- Build and schedule ETL and ELT pipelines with logging and error handling.
- Model a dimensional data warehouse using fact and dimension tables.
- Extract and interpret master and transactional data from ERP systems.
- Implement data quality rules, reconciliation checks and access controls.
- Publish curated datasets to Power BI or similar reporting tools.
What you'll learn
Key Takeaways
Participants leave the course with:
- A normalised database design with a documented data dictionary.
- A library of tested SQL queries and reusable Python scripts.
- A working scheduled pipeline from source system to warehouse.
- A star schema warehouse built from sample ERP data.
- Data quality and reconciliation checks they can reuse.
- A finished capstone project they can show to employers or managers.
Training Methodology
The course is more than three-quarters hands-on, with every concept followed by a lab. Participants will experience:
- Daily computer labs using PostgreSQL or SQL Server, Python, Jupyter and Power BI
- Sample ERP databases with realistic finance, procurement and inventory data
- Code walk-throughs and pair programming with trainer feedback
- Short architecture briefings that connect each skill to the whole data flow
- A ten-day capstone that grows from the labs into a documented pipeline
Day 1: Data Engineering and Relational Foundations
- The role of the data engineer and the modern data stack
- Relational model: tables, keys, relationships and constraints
- Entity relationship diagrams and requirements gathering
- Normalisation to third normal form and when to denormalise
- Setting up the lab environment and sample databases
- Lab: designing a schema for a procurement process
Day 2: SQL Essentials
- SELECT, filtering, sorting and aggregation
- Inner, outer and cross joins
- Subqueries and common table expressions
- Data definition and manipulation statements
- Transactions and data integrity
- Lab: answering business questions from a sales database
Day 3: Advanced SQL and Performance
- Window functions for ranking, running totals and comparisons
- Views, stored procedures and functions
- Indexes and reading execution plans
- Partitioning and handling large tables
- Query style, testing and version control
- Lab: tuning slow queries and building reporting views
Day 4: Python for Data Work
- Python basics for data engineers and virtual environments
- Reading CSV, Excel, JSON and database sources with pandas
- Cleaning, reshaping and merging data frames
- Handling dates, missing values and duplicates
- Connecting Python to databases and APIs
- Lab: cleaning a messy supplier master file
Day 5: Data Architecture and Warehousing Concepts
- Operational systems versus analytical systems
- Staging, warehouse, data mart and data lake layers
- Dimensional modelling: facts, dimensions and grain
- Slowly changing dimensions
- ETL compared with ELT and cloud warehouses
- Exercise: designing a star schema for finance reporting
Day 6: Understanding ERP Data
- ERP modules and the data each one holds
- Master data and transactional data in finance, procurement and inventory
- Typical table structures in SAP, Oracle, Dynamics and Odoo style systems
- Extraction options: database access, APIs, reports and change data capture
- Security, permissions and impact on production systems
- Lab: exploring and profiling an ERP sample database
Day 7: Building ETL Pipelines
- Pipeline design: extract, validate, transform and load
- Incremental loads and handling late or changed records
- Error handling, logging and restartability
- Configuration, secrets and environment management
- Testing pipelines with sample and edge-case data
- Lab: building an incremental load from ERP to staging
Day 8: Orchestration and Cloud Data Services
- Scheduling and dependency management with Apache Airflow
- Monitoring, alerting and service level targets
- Cloud storage, managed databases and warehouses
- Cost control and sizing
- Version control and deployment with Git
- Lab: scheduling a multi-step pipeline with alerts
Day 9: Data Quality, Governance and Reporting Layers
- Data quality dimensions and automated rule checks
- Reconciliation of warehouse totals to ERP ledgers
- Data lineage, cataloguing and documentation
- Access control, masking and privacy considerations
- Publishing curated datasets to Power BI
- Lab: adding quality gates and a semantic layer
Day 10: Capstone Project and Review
- Capstone brief: ERP tables to a documented warehouse and dashboard
- Guided build time with trainer support
- Presentation of designs, code and data quality evidence
- Peer review and improvement suggestions
- Career paths and next steps in data engineering
- Personal action plan and course review
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
- Graduates entering data engineering careers
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.
Choose Where You Want to Learn
Practical 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 Practical Data Engineering, Databases & ERP Data Training Course
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
More Big Data Analytics, Data Science and Data Engineering Courses
Natural Language Processing (NLP) Training Course
Key Skills You'll Learn
- Understand core natural language processing (NLP) principles and how they fit together in practice.
- Apply practical techniques for natural language processing (NLP) in day-to-day implementation.
Vision Reach Global
From $3,000 · KSh 230,000
Healthcare Analytics and Data Management Training Course
Key Skills You'll Learn
- Understand core healthcare analytics and data management principles and how they fit together in practice.
- Apply practical techniques for healthcare analytics and data management in day-to-day implementation.
Vision Reach Global
From $3,000 · KSh 230,000
Data Wrangling and Cleaning Techniques Training Course
Key Skills You'll Learn
- Understand core data wrangling and cleaning techniques principles and how they fit together in practice.
- Apply practical techniques for data wrangling and cleaning techniques in day-to-day implementation.
Vision Reach Global
From $3,000 · KSh 230,000
Data Strategy and Governance for Digital Transformation Training Course
Key Skills You'll Learn
- Understand core data strategy and governance for digital transformation principles and how they fit together in practice.
- Apply practical techniques for data strategy and governance for digital transformation in day-to-day implementation.
Vision Reach Global
From $1,500 · KSh 115,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 Practical Data Engineering, Databases & ERP Data Training Course or browse every live online course.