Course · Intermediate
Relational Database Administration
Install, secure, back up, monitor and replicate a relational database, with PostgreSQL as the reference and MySQL as an option
- 9 modules
- 23 lessons
- 13 labs
- 18 quizzes
- 26h
Start Lesson: Training: administer a relational database
Recommended before you start: Linux, SQL (in French)
About this path · first module: 5 lessons, about 1 week
Welcome to your relational databases training path. This page lists every lesson of the course, grouped into progressive modules: the fundamentals that hold whatever the engine, then PostgreSQL and MySQL, from setup to replication. Lessons are being translated one module at a time, so some still open in French; a lesson ticked in the French edition is ticked here too.
Yes, it is a long path. Nobody follows it in one go. The first module, "Les fondamentaux, quel que soit le moteur", is 5 lessons of about 65 minutes: at one per working day, 1 week is enough, and you can already put it to use. Each module gives you a skill you can use the next day, and your progress waits for you in this browser and on the devices linked to your optional account.
Progress 0 / 23 (0%)
- Knowledge Not measured Your first quiz will show up at the end of a lesson.
- Practice Not measured Labs measure what you can do. You do not need DSOXLab to start a course.
- Proof Not measured Challenges and hands-on exams check that you can act without step-by-step instructions.
Tick lessons here, or with “Mark as read” at the end of each lesson. Progress stays in this browser; nothing is sent to the server unless you link this browser to an optional account.
-
02
- lesson quiz History of databases: why they are the way they are 25 min
- lesson quiz Data modeling: from the requirement to the relational model 35 min
- lesson quiz Transactions: what ACID and BASE promise 30 min
- lesson quiz How does a database server work? 25 min
- lesson quiz Partitioning and sharding a database: when and how to choose 30 min
-
04
- lesson PostgreSQL administration: install, configure and secure 5 min
- lesson quiz Discover PostgreSQL: architecture, vocabulary and components 45 min
- lesson lab quiz Install PostgreSQL 18 from the PGDG repository 1h10
- lesson lab quiz Administer a PostgreSQL instance with psql 1h15
- lesson lab quiz Configure PostgreSQL: memory, connections, WAL and logging 1h30
- lesson lab quiz Control access to PostgreSQL: pg_hba.conf, roles and enforced TLS 1h35
-
05
- lesson lab optional MySQL: administer a relational database in production 10 min
- lesson optional Discover MySQL: architecture, InnoDB and components 55 min
- lesson lab quiz optional Getting started with the mysql client: administer MySQL from the command line 1h55
- lesson lab quiz optional Configure MySQL: InnoDB, memory, connections and logging 1h45
- lesson lab quiz optional Secure MySQL: users, TLS, roles and least privilege 1h45
- lesson lab quiz optional Back up and restore MySQL: mysqldump, MySQL Shell and binlog PITR 1h40