Certificate 1
Certificate 2
Pack 8 — Databases & Advanced SQL

From modeling to optimization — harnessing the power of structured data.

Who it's for: Developers, analysts, junior DBAs, BTS/Master's computer science students.

Program

2 certificates

Certificate 1 — SQL, NoSQL & Database Administration (PostgreSQL / MongoDB)

40h · 5 days · 30% theory / 70% practice

Master the design, querying and administration of SQL/NoSQL databases.

  • Relational modeling (ERD, logical model, 1NF-3NF normalization)
  • Fundamental & advanced PostgreSQL SQL (SELECT, JOIN, subqueries, window functions, stored procedures, triggers)
  • NoSQL MongoDB (documents, collections, aggregation)
  • Administration & optimization (users, backups, indexing, execution plans)
Prerequisites: None (spreadsheet/logic skills a plus)Career paths: Junior DBA · Back-End Developer · Data Analyst

Certificate 2 — Data Warehousing & Analytical System Design

40h · 5 days · 40% theory / 60% practice

Design data warehouses, feed decision-support systems with Power BI.

  • Dimensional architecture (star/snowflake schemas, fact/dimension tables)
  • ETL pipeline
  • Data mart feeding (Power BI connection)
  • Ivorian case study (retail chain / financial institution)
Prerequisites: SQL proficiency (Module 1)Career paths: Data Engineer · Data Architect · BI Consultant

Ready to start "Pack 8 — Databases & Advanced SQL"?

A 30-minute call is enough to scope your needs.