Database Foundations
Certification validating fundamental skills in designing, administering, and querying relational and NoSQL databases.
Key skills
- ✓Database modelling and normalisation
- ✓Advanced SQL proficiency (complex queries, joins, subqueries)
- ✓Database management system administration (PostgreSQL, MySQL, MongoDB)
- ✓Performance optimisation and indexing
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:
- →Backend and full-stack developers
- →Junior database administrators
- →Data analysts and business intelligence developers
✗ This certification is not suitable if:
- →Beginners with no SQL experience: start with basic SQL training before aiming for this certification.
- →Experienced data architects: consider the Data Architecture Master 801 or Data Engineering Fellow Series for expert-level skills.
Prerequisites & eligibility
Online registration, secure payment, identity verification via webcam during the exam.
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
Relational modelling
Design normalised schemas (3NF/BCNF) and robust entity-relationship models.
Advanced SQL
Master complex joins, CTEs, window functions and performance queries.
Database management system administration
Manage users, backups, replication and high availability on PostgreSQL/MySQL.
NoSQL & optimisation
Understand MongoDB, Redis, optimise indexes and analyse execution plans.
Exam format
Curriculum
Modelling and design
Analysis of business needs and translation into a conceptual model. Entities, attributes, associations and cardinalities. Transition from conceptual model (MCD) to logical model (MLD) then physical model (MPD). Normal forms: 1NF, 2NF, 3NF, BCNF and controlled denormalisation. Referential integrity constraints, primary and foreign keys. ERD diagrams and modelling tools (draw.io, dbdiagram.io).
SQL and advanced querying
Complete SQL syntax: SELECT, FROM, WHERE, GROUP BY, HAVING, ORDER BY. Inner and outer joins (INNER, LEFT, RIGHT, FULL OUTER, CROSS). Scalar, tabular and correlated subqueries. Common Table Expressions (WITH, recursive CTEs). Window functions (ROW_NUMBER, RANK, LAG, LEAD, partitioning). Complex aggregations and PIVOT. Transaction management (BEGIN, COMMIT, ROLLBACK), ACID isolation levels. Stored procedures and triggers.
Administration and security
Installation and configuration of PostgreSQL and MySQL. User, role and privilege management (GRANT, REVOKE). Backup strategies: logical dump (pg_dump, mysqldump), physical backup, PITR. Master-slave replication and high availability. Transaction logs and audit trail. Performance monitoring (pg_stat, slow query log). Memory configuration (shared_buffers, work_mem). Security: SSL encryption, authentication, SQL injection protection.
Performance and NoSQL databases
Indexing strategies: B-tree, hash, GIN, GiST, partial and covering indexes. Execution plan analysis with EXPLAIN and EXPLAIN ANALYZE. Query optimisation: rewriting, hints, statistics. Horizontal and vertical partitioning. Introduction to NoSQL databases: MongoDB (BSON documents, collections, aggregations), Redis (key-value structures, pub/sub, cache). CAP theorem and consistency choices. Use cases: when to choose relational vs NoSQL.
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
Which database management systems are covered by the exam?
The exam focuses on PostgreSQL and MySQL for relational databases, with questions on MongoDB and Redis for NoSQL. The concepts are transferable to Oracle, SQL Server or MariaDB.
Do I need to know a programming language?
Not mandatory, but knowledge of Python, Java or PHP facilitates understanding of application interactions with databases. The exam focuses on pure SQL.
Are there practical exercises in a real environment?
The exam environment simulates an SQL terminal with automatic result validation.
Does this certification replace Oracle Database SQL Certified Associate?
Our graduates master PostgreSQL, MySQL and NoSQL in addition to SQL standards.
What is the difference with university database courses?
PROVA Database Foundations validates operational skills immediately applicable in business, with a focus on real-world administration and optimisation. Academic training covers more relational theory.
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.
