PostgreSQL Training Course
- Price
- Duration
- Number of Hours
Each session will take place even if only one person is registered (except in cases of force majeure).
Description
PostgreSQL has become one of the most widely adopted DBMSs in critical and cloud environments. Robust, scalable and open source, it nevertheless requires rigorous administration to get the most out of its performance.
This PostgreSQL training course guides you through the implementation, daily administration and security of a PostgreSQL server. Through practical workshops, you will learn how to deploy a server, structure data, manage users, optimise queries and ensure high availability.
Format
Remote (recorded sessions).
GOOD TO KNOW
This training course includes numerous exercises (60% practical) to enhance learning. Even if you are the only one registered, the session will still take place (except in cases of force majeure). A preliminary interview is held between the participant and/or a company representative in order to fully assess the participant’s profile (level, needs, professional context, challenges, etc.).
Assessment : during the training course, the trainer assesses the participants’ progress through multiple-choice questions, role-playing exercises and practical work. Participants receive a certificate of completion at the end of the training course.
objectives of this PostgreSQL Training Course
By the end, each participant will be able to :
- Install and configure a secure PostgreSQL server
- Create and administer databases and user roles
- Structure schemas, types, and indexes for performance
- Implement a backup/restore policy
- Monitor activity and diagnose common problems
- Optimise queries and fine-tune the engine
Prerequisites for this PostgreSQL Training Course
- Basic knowledge of SQL
- Experience with a Unix/Linux system
- No prior knowledge of PostgreSQL required
- Because each participant has a unique background and expectations, a preliminary interview with our expert allows us to precisely identify their objectives, level and professional challenges.
This enables us to tailor the training content to ensure relevant and personalised learning.
Target Audience
A must-have for developers, system administrators, or DBAs who wish to use PostgreSQL in a demanding professional environment.
Detailed of this PostgreSQL Training Course
Introduction et architecture PostgreSQL
Internal operation, processes, configuration files, schemas, and roles.
Installation and configuration
Linux installation (apt/yum), postgresql.conf configuration, authentication, network security.
Database and user management
Creation of databases, management of roles, rights and privileges, isolation and concurrent access.
Backup and restore
Logical backups (pg_dump, pg_restore) and physical backups (pg_basebackup), disaster recovery strategies.
Optimisation and supervision
Index, execution plan analysis, EXPLAIN, server tuning, monitoring tools (pgAdmin, Prometheus, etc.).
Safety and best practices
Connection security, SSL, logs, auditing, version upgrades, extension management.
The advantages of this training course
This training course :
Combines theoretical approach and practical workshops
Focuses on production deployment (not just installation)
Covers performance, security and incident management
Suitable for both on-premise and cloud environments (AWS RDS, GCP Cloud SQL, etc.)
Our related training courses
Would you like to know about upcoming sessions ?
Would you like to schedule this PostgreSQL Training Course on a specific date ? Contact us by email or by filling out the contact form.