Data Modeling and Database Design Training

Cybersecurity & Information Systems · 10 Days

Course Overview

Reliable decisions, programme reporting and digital services all depend on well-structured data. Poorly designed databases lead to duplicated records, inconsistent reports, slow systems and costly rework. This course gives delegates a rigorous grounding in data modelling and database design principles so that information systems are built right from the start. Over ten days, participants move from requirements gathering and entity-relationship modelling through normalisation, dimensional modelling, SQL implementation, indexing and performance tuning. They also explore NoSQL approaches, data security, governance, migration and documentation, using practical exercises drawn from government, NGO, financial services and development-sector contexts across Africa. By the end of the programme, delegates will be able to translate business needs into sound logical and physical data models, implement them in a relational database, and maintain them in a secure, documented and sustainable way.

Who Should Attend

  • Database administrators and developers
  • IT officers and systems analysts
  • Data analysts and data engineers
  • Monitoring and evaluation information systems officers
  • Business intelligence and reporting specialists
  • Software developers and technical project leads
  • Data managers in NGOs, government and the private sector
  • Graduates and early-career professionals entering data and IT roles

Learning Objectives

  • Elicit and document data requirements from business stakeholders
  • Build conceptual, logical and physical data models using entity-relationship techniques
  • Apply normalisation and denormalisation appropriately
  • Implement relational databases using SQL with proper keys and constraints
  • Design dimensional models for analytics and reporting
  • Optimise database performance through indexing and query tuning
  • Apply data security, integrity and governance controls
  • Select suitable relational or NoSQL approaches for different use cases
  • Plan data migration and produce clear model documentation

Key Takeaways

Course Curriculum

1

Foundations of Data and Database Systems

2

Requirements Gathering and Business Analysis

3

Conceptual Modelling with Entity-Relationship Diagrams

4

The Relational Model and Logical Design

5

Normalisation and Denormalisation

6

SQL for Database Implementation

7

Advanced SQL, Transactions and Stored Logic

8

Physical Design, Indexing and Performance Tuning

9

Dimensional Modelling for Analytics

10

NoSQL and Modern Data Architectures

11

Data Quality, Security and Governance

12

Data Migration, Integration and Documentation

13

Capstone Database Design Project

Requirements

Participants should have basic computer literacy and general familiarity with spreadsheets or data records. Prior exposure to databases or SQL is helpful but not required. Delegates should bring a laptop capable of running database software.

Certification

Participants who complete the programme receive a Certificate of Completion issued by EcoTrio Impact Growth and Development Centre (EIGDC).

Frequently Asked Questions

What background knowledge is expected before attending?

Participants should have basic computer literacy and general familiarity with spreadsheets or data records. Prior exposure to databases or SQL is helpful but not required. Delegates should bring a laptop capable of running database software.

Is a certificate issued upon completion?

Participants who complete the programme receive a Certificate of Completion issued by EcoTrio Impact Growth and Development Centre (EIGDC).

Can Ecotrio deliver this course in-house for our team?

Yes. Ecotrio Impact Growth and Development Centre (EIGDC) offers a bespoke in-house delivery option for Data Modeling and Database Design, tailored to your organisation's context within Cybersecurity & Information Systems. Contact our training team to discuss customisation, scheduling and group pricing.

Can I attend this course virtually instead of in person?

Yes. Selected cohorts of this course are available as live virtual sessions delivered over video conferencing by an experienced facilitator, with the same certificate issued on completion as the in-person format.

What are the key learning outcomes of this course?

By the end of this course, you will be able to elicit and document data requirements from business stakeholders, build conceptual, logical and physical data models using entity-relationship techniques, apply normalisation and denormalisation appropriately, implement relational databases using SQL with proper keys and constraints, design dimensional models for analytics and reporting, optimise database performance through indexing and query tuning, apply data security, integrity and governance controls, select suitable relational or NoSQL approaches for different use cases, and plan data migration and produce clear model documentation. The programme is designed to be immediately applicable to your day-to-day role.

Upcoming Sessions

LocationDatesMode
Johannesburg, South Africa 09 Nov 2026 – 18 Nov 2026 Classroom Register →
Kigali, Rwanda 09 Nov 2026 – 18 Nov 2026 Classroom Register →
Kampala, Uganda 09 Nov 2026 – 18 Nov 2026 Classroom Register →
Dubai, United Arab Emirates 09 Nov 2026 – 18 Nov 2026 Classroom Register →
Cape Town, South Africa 09 Nov 2026 – 18 Nov 2026 Classroom Register →
Nairobi, Kenya 09 Nov 2026 – 18 Nov 2026 Classroom Register →
Accra, Ghana 16 Nov 2026 – 25 Nov 2026 Classroom Register →
Dar es Salaam, Tanzania 16 Nov 2026 – 25 Nov 2026 Classroom Register →
Cairo, Egypt 16 Nov 2026 – 25 Nov 2026 Classroom Register →
Live Virtual 23 Nov 2026 – 02 Dec 2026 Online Register →
Zanzibar, Tanzania 23 Nov 2026 – 02 Dec 2026 Classroom Register →
Pretoria, South Africa 23 Nov 2026 – 02 Dec 2026 Classroom Register →

Ready to Register for Data Modeling and Database Design Training?

See full pricing, exact upcoming dates across South Africa, Rwanda, Uganda, and secure your seat online in minutes.

Book This Training →