Perform a search on the site.

Your currency
Labs inclus
Real-world practice environments to test what you’ve learnt
Formateurs
certifiés
Formation dispensée par un formateur spécialisé
Cours officiel
Official training from an Accredited Training Provider

PostgreSQL: getting started and database administration

Your applications rely on well-administered databases. With PostgreSQL, connect configuration, operations and maintenance to work more systematically. Build your autonomy and ability to monitor the environment against service requirements.

Program PDF
3 days 21 hours
POS01FR Code
IT – Database administration (PostgreSQL option) Certification
IT – Database administration (PostgreSQL option)

Accredited training for the IT – Database administration (PostgreSQL option) certification.

Presentation

PostgreSQL provides an object-relational database management system (ORDBMS). It is free to use under an open-source BSD licence. It is a genuine competitor to leading proprietary and open-source database management systems.

You will explore the basics of installing and administering PostgreSQL version 10.x. Following an introduction to its tools and core features, you will install PostgreSQL and carry out the initial configuration required to run it. You will then explore instance management, clusters and solutions for handling failures. In particular, you will learn to secure your PostgreSQL server, review logs and optimise resources. Finally, you will cover key aspects of PostgreSQL administration, data backup and recovery, before concluding with extensions.

You will also obtain the IT - Administration d'une base de données certification by taking an online examination. This credential targets digital professions, particularly database administrators and designers. It recognises your ability to implement a database in line with defined management rules, insert and update data, ensure security, perform backups and restores, and carry out maintenance.

Objectives

By completing the PostgreSQL 10.x: getting started and administration course, you will be able to:

  • understand how PostgreSQL works, its constraints and its features;
  • install and configure a PostgreSQL instance;
  • administer one or more databases;
  • import and export PostgreSQL databases;
  • secure databases, including instance access, roles and access rights;
  • manage transactions, including commits and rollbacks;
  • schedule database backup and recovery operations;
  • perform PostgreSQL database maintenance tasks.
Last update: 24/09/2026