Database Administration Professional
Certifies operational mastery of relational and NoSQL database administration, from design to production optimisation.
Key skills
- ✓Installation and configuration of DBMS (PostgreSQL, MySQL, MongoDB)
- ✓Performance optimisation and SQL query tuning
- ✓Backup, restoration and business continuity plans
- ✓Access security and GDPR compliance
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 and intermediate database administrators
- →DevOps engineers managing data infrastructures
- →Back-end developers wishing to deepen their optimisation skills
✗ This certification is not suitable if:
- →Beginners with no prior database experience: first consider a fundamental course in SQL and data architecture.
- →Senior data architects: consider the Master 801 Data Architecture & Strategy certification for a strategic level of responsibility.
Prerequisites & eligibility
No formal prerequisites, but at least 1 year of practical experience in database administration is strongly recommended.
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
Multi-DBMS Administration
Operational mastery of PostgreSQL, MySQL, SQL Server and MongoDB in a production environment.
Performance Tuning
Query optimisation, strategic indexing and execution plan analysis to maximise performance.
High Availability
Implementation of replication, clustering and backup strategies to ensure service continuity.
Security and Compliance
Application of data security best practices and compliance with GDPR and ISO 27001 requirements.
Exam format
Curriculum
DBMS Architecture and Installation
Client-server architecture and internal processes. Installation and configuration of PostgreSQL (versions 13-16), MySQL/MariaDB (8.x), SQL Server on Linux, MongoDB (6.x). Setting postgresql.conf, my.cnf, shared memory management (shared_buffers, innodb_buffer_pool). Network and port configuration. Management of multiple instances.
Modelling and Design
Normal forms (1NF to BCNF), strategic denormalisation. Relational schema design, choice of data types (NUMERIC vs DECIMAL, TEXT vs VARCHAR, JSONB). Integrity constraints (PRIMARY KEY, FOREIGN KEY, CHECK, UNIQUE). NoSQL modelling: MongoDB collections, document-oriented design, embedded vs referenced. Modelling patterns for high performance.
Optimisation and Performance
Analysis with EXPLAIN and EXPLAIN ANALYZE. Execution plans: sequential scan, index scan, bitmap scan, hash join, nested loop. Indexing strategies: B-tree, Hash, GiST, GIN, BRIN. Partial and covering indexes. Optimisation of complex queries (CTE, window functions). Partitioning by range, list and hash. VACUUM, ANALYZE, REINDEX. Monitoring with pg_stat_statements, MySQL slow query log, MongoDB profiler. Configuration of performance parameters (work_mem, effective_cache_size, max_connections).
High Availability and Backup
PostgreSQL streaming replication (asynchronous and synchronous), MySQL replication (binlog-based, GTID), MongoDB replica sets. Hot standby and read replicas configuration. Automatic failover with Patroni, repmgr, ProxySQL. Clustering with Galera Cluster (MariaDB). Backup strategies: pg_dump, pg_basebackup, mysqldump, mongodump, Percona XtraBackup. Incremental and differential backups. Point-in-time recovery (PITR) with WAL. Restoration tests. Business continuity plans: RTO, RPO, DR/BCP documentation.
Security and Compliance
Role and privilege management (GRANT, REVOKE). Principle of least privilege. Authentication: pg_hba.conf, PAM, LDAP, Kerberos. SSL/TLS for encrypted connections. Encryption at rest (Transparent Data Encryption). PostgreSQL row-level security. Audit trail and logging (pgaudit, MySQL Enterprise Audit). Application of the GDPR: identification of personal data, right to be forgotten, anonymisation with pg_anonymize, pseudonymisation. Compliance with ISO 27001 and PCI-DSS.
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 — €420 incl. VAT
Secure online payment by credit card (Stripe).
Business rate: €550 excl. VAT
Business — custom quote
Teams, cohorts or private catalogue: a quote tailored to your volumes and goals.
Frequently asked questions
Which DBMS are covered by this certification?
The exam mainly covers PostgreSQL and MySQL for relational, MongoDB for NoSQL. The concepts also apply to SQL Server, MariaDB and Oracle. The focus is on transferable skills rather than a single technology.
Do I need to know all DBMS to pass the exam?
No. The questions are designed to assess your understanding of fundamental administration concepts. In-depth mastery of at least one relational DBMS (PostgreSQL or MySQL) and knowledge of NoSQL are sufficient.
Does this certification replace vendor certifications?
It demonstrates a cross-functional skill valued in multi-DBMS environments, increasingly common in Europe.
What is the technical level of the exam?
The exam assesses operational skills at an intermediate to advanced level: you must be able to install, configure, optimise and secure production databases.
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.
