Course : PostgreSQL, Administration

Practical course - 3d - 21h00 - Ref. PGA
Price : 2000 CHF E.T.

PostgreSQL, Administration



Required course



INTER
IN-HOUSE
CUSTOM

Practical course in person or remote class
Disponible en anglais, à la demande

Ref. PGA
  3d - 21h00
2000 CHF E.T.






Teaching objectives
At the end of the training, the participant will be able to:
Installing the PostgreSQL DBMS
Determining the main features of PostgreSQL database administration
Creating and managing a database
Managing access to users
Managing database security.
Participants

Course schedule

1
» Overview of PostgreSQL

  • Overview of projects and tools.
  • Comparison with other RDBMS engines.

2
» Installation

  • Steps of installation.
  • Linux distributions: From RPM or source code.
  • Binaries for MS-Windows. Installation wizard. Preparing the operating system.

3
» Initializing and executing an instance

  • Principle. Shutting down and rebooting the server.
  • Server process architecture.
  • Creating additional instances.

4
» Connections and administrative tools

  • Sessions. Server side (pg_hba.conf). Security (SSL, etc.).
  • Access rights Role management (users and groups). Granting and revoking privileges.
  • Comand line and graphical tools. psql (shell SQL). PgAdminIII, phpPgAdmin, Pgpool.

5
» Defining data

  • Creating schemas, tables, indices, domains, etc.
  • Types of data, operators, and functions.

6
» Programming for administration

  • Server side Stored procedures. PL/pgSQL. PL/Perl. C extensions. Triggers.
  • Stored functions.
  • Client side. PHP Web applications. PostgreSQL and PDO drivers. Java Web applications.

7
» Routine administration

  • Defining files. Creating namespaces (tablespaces, files).
  • Directory tree and server files.
  • Server administration. Configuration. Binary logs and memory.
  • The statistics collector and activity logs.
  • Maintenance and operating tasks. Analyzing queries with Explain.
  • Analyzing and cleaning up table and index spaces with Vacuum.
  • Reconstructing indexes with Reindex.

8
» Backups and restores

  • Backups with pg_dump and pg_dumpall.
  • Restores with pg_restore and psql.
  • Binary logs: Write Ahead Logging (WAL).


Customer reviews
4,1 / 5
Customer reviews are based on end-of-course evaluations. The score is calculated from all evaluations within the past year. Only reviews with a textual comment are displayed.
DOMINIKA M.
16/11/26
4 / 5

As far as I’m concerned, some explanations are missing from the slides. Several important options for completing the exercises are explained only verbally and do not appear in the course materials. This means I have to take additional notes to understand how to use them. Adding these explanations to the slides would make it easier to follow along and complete the exercises.
ALEXANDRE P.
16/11/26
5 / 5

An excellent trainer; the course is very theory-based and requires prior knowledge of DBMS. The content of the course materials is really good – it covers all the main functions and will be very useful for learnt the relevant commands!
ENORA M.
16/11/26
4 / 5

It could have been made clear that the course would be run primarily on Linux and that a working knowledge of it was a prerequisite. This made it more difficult for me to understand the course.



Publication date : 02/21/2024



This programme is an original creation, developed by the teaching teams at ORSYS Formation. Any reproduction, representation, adaptation or use, in whole or in part, without the prior written authorisation of ORSYS, is strictly prohibited. ORSYS reserves the right to take any action necessary to protect its intellectual property rights.

Dates and locations

Dernières places
Date garantie en présentiel ou à distance
Session garantie
From 7 to 9 December 2026 *
FR
Remote class
Registration
From 18 to 20 January 2027
FR
Remote class
Registration
From 3 to 5 February 2027
FR
Remote class
Registration
From 3 to 5 February 2027
EN
Remote class
Registration
From 22 to 24 March 2027
FR
Remote class
Registration
From 26 to 28 April 2027 *
FR
Remote class
Registration
From 26 to 28 April 2027
EN
Remote class
Registration
From 3 to 5 May 2027
FR
Remote class
Registration
From 27 to 29 September 2027 *
FR
Remote class
Registration
From 27 to 29 September 2027
EN
Remote class
Registration
From 8 to 10 November 2027 *
FR
Remote class
Registration
From 8 to 10 November 2027
EN
Remote class
Registration

REMOTE CLASS
2026 : 7 Dec.

2027 : 18 Jan., 3 Feb., 3 Feb., 22 Mar., 26 Apr., 26 Apr., 3 May, 27 Sep., 27 Sep., 8 Nov., 8 Nov.



This programme is an original creation, developed by the teaching teams at ORSYS Formation. Any reproduction, representation, adaptation or use, in whole or in part, without the prior written authorisation of ORSYS, is strictly prohibited. ORSYS reserves the right to take any action necessary to protect its intellectual property rights.