PostgreSQL Immersion

IT spetsialistile

The main coal of this class is for the students to understand how the database works and makes its decisions. 

This course combines three shorter classes - covering administration, performance, advanced development, and replication - into a continuous sequence. Ideal if you want to learn quickly. Hands-on workshop exercises are provided for the performance and replication classes.  The examples target current versions PostgreSQL. 

After finishing this course student has gained skills and understanding regarding postgreSQL:

  • database administration
  • development
  • performance
  • replication
  • recovery


Students must have a working knowledge of SQL. Using the command line interface to a Linux system and some basic UNIX shell programming experience is needed to complete all of the replication workshop exercises.

Investeering: 1500,00 € + km
Lektor: Hannu Krosing
Päevade arv: 5
Tundide arv: 40 akadeemilist tundi

Sihtgrupp:To this class we welcome database administrators, systems administrators, or developers with working knowledge of database usage.

  • Introduction to PostgreSQL
  • Server Configuration
  • Database Administration
  • User Administration
  • Understanding Database Object Types
  • Permissions & Security
  • Running SQL
  • Monitoring
  • VACUUM, Freezing & Avoiding Wraparound
  • Maintenance
  • Server Architecture & Caching
  • Tuning Parameters
  • Locking & Concurrency
  • Database design alternatives
  • Advanced Development Summary
  • Reading EXPLAINs
  • Workload Analysis, Benchmarking and Profiling
  • Join Planning
  • Indexes
  • SQL Performance Tips & Tricks
  • Logical Backup
  • Replication Overview
  • Replication Terminology
  • Replication Transport
  • Replication Startup & Setup
  • Disconnection and Reconnection
  • Switchover, Failover and Failback
  • Physical Streaming Replication
  • repmgr
  • Logical Streaming Replication & pglogical
  • Bi-Directional Replication
  • Logical Decoding
  • Online Upgrade
  • Connection Pooling
  • Sharding and Scale Out
  • Physical Backup
  • Point In Time Recovery
  • Barman

Learning methods: Practical exercise, independent work.

Assesment methods: Execution of independent work.

Assesment form: Independent practical tasks on relevant topics.

Küsi lisa