PostgreSQL Administration

Learn via : Virtual Classroom / Online
Duration : 3 Days
  1. Home
  2. /
  3. PostgreSQL Administration


    PostgreSQL is an open-source, platform-independent, advanced object-relational (ORDBMS) database management system that keeps data fast and secure, and uses SQL language by developing it. PostgreSQL, which has powerful features and advantages, has many new features compatible with today’s digital transformation projects and technologies as well as corporate database features that will compete with the leading commercial database products in the sector. Taking advantage of the storability, security and scalability features of the SQL language, PostgreSQL is increasingly preferred every day for database and system administrators, architects, developers and institutions thanks to its many innovative features.

    Participants in this PostgreSQL Management training become able to manage PostgreSQL effectively.


    What You’ll Learn

    • Basic working logic of PostgreSQL
    • Installing PostgreSQL service and running commands with a connected client
    • PostgreSQL access restrictions and security settings
    • PostgreSQL maintenance operations
    • Reviewing the logs of the PostgreSQL service
    • Backup and disaster recovery in PostgreSQL
    • Inheritance, partitioning, and Tablespaces
    • Managing free spaces
    • PostgreSQL Security
    • Creating high accessibility and high performance solutions


    Who should attend

    Database admins

    Software developers

    System managers

    Anyone responsible for managing the PostgreSQL database


Installing and Managing PostgreSQL

PostgreSQL Overview

psql client

pgAdmin III client

Server Settings

Database Management

User Management

Authorization and Security




Knowledge of essential Linux and relational database.