PostgreSQL Trainings

​

In today's world, where the use of open source databases is increasing rapidly, you can examine our trainings we offer to explain the basic concepts of PostgreSQL technology and how to manage it.

PostgreSQL Administration 

Duration: 

3 Days

kisspng-oracle-sql-developer-oracle-data

PostgreSQL Administration

​​

  • Understand the PostgreSQL architecture

  • Installing PostgreSQL from source

  • Create databases

  • Learn command line interface: psql

  • Understand backup and restore 

  • Create a hot standby database

  • Understand the optimizer, statistics and vacuum

  • Understand monitoring tools

  • Upgrades in PostgreSQL

​

Monitoring PostgreSQL

Monitoring PostgreSQL

​

  • Database Statistics

  • The Statistics Collector

  • Database Statistic Tables

  • Operating System Process Monitoring

  • Current Sessions and Locks

  • Log Slow Running Queries

  • Disk Usage

Duration: 2 Days

kisspng-oracle-sql-developer-oracle-data

Backup and Recovery

Backup and Recovery 

​​

  • Backup Types

  • SQL Dump

  • Cluster Dump

  • Offline Copy Backup

  • Continuous Archiving

  • pg_basebackup

  • Point-In Time Recovery

  • pg_upgrade

Duration: 

2 Days

kisspng-oracle-sql-developer-oracle-data

Configuration PostgreSQL

Configuration PostgreSQL

​​

  • Setting PostgreSQL Parameters

  • Access Control

  • Connection Settings

  • Security and Authentication

  • Settings

  • Memory Settings

  • Query Planner Settings

  • WAL Settings

  • Log Management​

Duration: 

2 Days

kisspng-oracle-sql-developer-oracle-data