Data Foundations
Certification covering the fundamentals of data management: modelling, SQL, ETL pipelines, data quality and governance. Ideal for starting a solid data career.
Key skills
- ✓Design and modelling of relational databases
- ✓Mastery of advanced SQL and query optimisation
- ✓Construction of ETL pipelines and data integration
- ✓Data governance, quality and security
The question bank for this exam is prepared after your purchase. The exam is available no later than 48 hours after payment; you will receive an email as soon as it opens.
Is this right for you?
✓ This certification is right for you if:
- →Junior data analysts
- →Developers transitioning into data
- →Data project managers
✗ This certification is not suitable if:
- →Beginners with no data knowledge → start with a basic SQL preparatory training
- →Experienced Data Scientists → consider PROVA-DAE-801 Data Engineering Master to deepen Spark, Kafka and distributed architectures
Prerequisites & eligibility
Free online registration, exam can be taken from any location with a stable internet connection.
Purchase options
Exam voucher, LMS pathway, bundle packs — build your order
Options d'achat
Composez votre parcours — voucher d'examen, préparation LMS, packs entreprise.
Skills assessed
Robust modelling
Design normalised and performant relational schemas adapted to business needs.
Operational SQL
Write and optimise complex SQL queries to extract and transform data efficiently.
ETL pipelines
Build reliable data integration workflows with Python, Airflow or Talend.
Guaranteed quality
Implement quality controls and apply data governance principles.
Exam format
Curriculum
Database fundamentals
Relational and NoSQL DBMS architecture, ACID and BASE properties, transaction management and isolation levels, data models (hierarchical, network, relational, document, key-value), normalisation (1NF, 2NF, 3NF, BCNF), denormalisation strategies for performance, referential integrity constraints.
Advanced SQL and optimisation
Complex queries with multiple joins (INNER, LEFT, RIGHT, FULL, CROSS), correlated and non-correlated subqueries, recursive Common Table Expressions (CTE), window functions (ROW_NUMBER, RANK, LAG, LEAD), advanced aggregations (ROLLUP, CUBE, GROUPING SETS), indexing (B-tree, hash, bitmap), execution plan analysis, query optimisation, stored procedures and triggers.
Integration and ETL pipelines
ETL workflow design (Extract, Transform, Load), integration tools (Talend Open Studio, Apache Airflow, Apache NiFi, Pentaho), loading strategies (full load, incremental, CDC), error and rejection handling, orchestration and scheduling, pipeline monitoring, data transformation (cleaning, enrichment, aggregation), job dependency management.
Data governance and quality
Data governance principles and roles (data steward, data owner), quality dimensions (completeness, accuracy, consistency, freshness, uniqueness), data profiling and audit, metadata management and cataloguing, lineage and traceability, GDPR compliance (pseudonymisation, right to erasure), data security (encryption, masking, access control), Master Data Management (MDM).
How to fund your certification
3 ways to cover the cost of your certification
OPCO — Employer funding
Ask your employer to cover the cost through your OPCO (employee training plan).
Personal — €380 incl. VAT
Secure online payment by credit card (Stripe).
Business rate: €495 excl. VAT
Business — custom quote
Teams, cohorts or private catalogue: a quote tailored to your volumes and goals.
Frequently asked questions
Does this certification cover Big Data?
Data Foundations focuses on relational fundamentals and classic ETL. Big Data technologies (Hadoop, Spark) are introduced but are covered by specialised Master-level certifications.
Do I need to know Python to take the exam?
Python is not mandatory but recommended. The exam mainly assesses SQL and modelling concepts.
Can I take the exam in English?
Yes, the exam is available in French and English. You choose the language when booking your slot.
Your certification pathway
Before, during, after — the recommended progression
Droits du candidat
Transparence
Les critères de décision et le barème sont documentés et accessibles avant l'examen.
Droit d'appel
Toute décision peut être contestée dans les 30 jours. Examen par un tiers indépendant.
Plainte
Toute personne peut signaler un dysfonctionnement. Formulaire public accessible sans compte.
