PostgreSQL Administration

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

Description

    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


Outline

Installing and Managing PostgreSQL

PostgreSQL Overview

psql client

pgAdmin III client

Server Settings

Database Management

User Management

Authorization and Security

Monitoring

MVCC and VACUUM

Prerequisites

Knowledge of essential Linux and relational database.