PostgreSQL Administration

Course code: POSQLA

This PostgreSQL training class teaches the configuration, security management, administration, backup and restore, and optimization of PostgreSQL databases.

510 EUR

617 EUR including VAT

The earliest date from 10.10.2022

Selection of dates
daniel
Do you have a question?
+420 731 175 867 edu@edutrainings.cz

Professional
and certified lecturers

Internationally
recognized certifications

Wide range of technical
and soft skills courses

Great customer
service

Making courses
exactly to measure your needs

Course dates

Starting date: 10.10.2022

Type: Virtual

Course duration: 2 days

Language: cz

Price without VAT: 510 EUR

Register

Starting date: 17.10.2022

Type: Virtual

Course duration: 2 days

Language: en

Price without VAT: 510 EUR

Register

Starting date: 05.12.2022

Type: Virtual

Course duration: 2 days

Language: cz

Price without VAT: 510 EUR

Register

Starting date: 12.12.2022

Type: Virtual

Course duration: 2 days

Language: en

Price without VAT: 510 EUR

Register

Starting date: Individual

Type: Individual

Course duration: 2 days

Language: en

Price without VAT: 510 EUR

Register

Starting
date
Place
Type Course
duration
Language Price without VAT
10.10.2022 Virtual 2 days cz 510 EUR Register
17.10.2022 Virtual 2 days en 510 EUR Register
05.12.2022 Virtual 2 days cz 510 EUR Register
12.12.2022 Virtual 2 days en 510 EUR Register
Individual Individual 2 days en 510 EUR Register
G Guaranteed course

Didn't find a suitable date?

Write to us about listing an alternative tailor-made date.

Contact

Course description

This PostgreSQL training class teaches the configuration, security management, administration, backup and restore, and optimization of PostgreSQL databases.

Course structure

Installation and data files

  • PostgreSQL versions
  • Download and installation
  • Initial database initialization
  • Database engine startup
  • Starting and stopping of database engine
  • Resolving startup failures

Configuration and data files

  • psql client
    • Connecting to database
    • Common connection problems
  • Configuration files
    • main conf
  • Physical storage and file layout
  • Tablespaces
  • Roles & privileges
    • Roles and attributes
  • Client authentication
    • File conf
    • Postgresql identity mapping
  • Databases, schemas

Basic operations

  • Working with search_paths
  • Purpose of information_schema
    • Database inspection
  • customizing psql
    • Magic psql commangs
    • psql configuration files
    • Automating autentication with .pgpass and environmenta variables

Monitoring & maintenance

  • PostgreSQL logging behaviour
  • Statistics tables
  • Monitoring
    • database activity
    • client connections
    • slow queries
    • locks
  • Vacuum and autovacuum

Transaction and WALs

  • How transactions works
  • Transaction isolations levels
  • Write Ahead Logs
    • Transaction implementation

Backup and restore

  • PostgreSQL internal backup_mode
  • Filesystem backup
  • PostgreSQL backups
  • Replication-based backups
  • Point In Time Restore

Tips and tricks

  • Basic parameters tuning
  • Customizing PostgreSQL client
  • Replication types overview

Follow-up courses

MongoDB Developer cz/sk en

Vendor: EDU Trainings

Area: Databases

Price from

1 080 EUR without VAT

MongoDB Administration cz/sk en

Vendor: EDU Trainings

Area: Databases

Price from

1 080 EUR without VAT

MySQL Administration cz/sk

Vendor: EDU Trainings

Area: Databases

Price from

510 EUR without VAT

MySQL Performance cz/sk en

Vendor: EDU Trainings

Area: Databases

Price from

510 EUR without VAT

PostgreSQL for DB Developers cz/sk en

Vendor: EDU Trainings

Area: Databases

Price from

510 EUR without VAT

PostgreSQL Performance cz/sk en

Vendor: EDU Trainings

Area: Databases

Price from

510 EUR without VAT

SQL for beginners en

Vendor: EDU Trainings

Area: Databases

Price from

300 EUR without VAT

Guaranteed

SQL for intermediate users cz/sk en

Vendor: EDU Trainings

Area: Databases

Price from

300 EUR without VAT

MS SQL Server administration comprehensively and efficiently cz/sk

Vendor: EDU Trainings

Area: Databases

Price from

1 210 EUR without VAT

Optimization and monitoring of T-SQL queries cz/sk en

Vendor: EDU Trainings

Area: Databases

Price from

790 EUR without VAT

ComGate payment gateway MasterCard Logo Visa logo