PostgreSQL Eğitimleri

Açık kaynak kodlu veritabanların kullanımının hızla arttığı günümüzde, PostgreSQL teknolojisininin temel kavramlarını ve nasıl yönetileceğini anlatmak için sizlere sunduğumuz eğitimlerimizi inceleyebilirsiniz.  

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: 

Days

kisspng-oracle-sql-developer-oracle-data