Login | Create new business account

Courses: RLPG201 - PostgreSQL Advanced DBA

Classroom3 daysFull-timeCoursesEnglish

This three-day course provides everything included in the standard DBA, with some more depth.


It also covers topics like replication, high availability clustering and tuning.


Course Format

This class is 90% theory and 10% informal labs. The course is held in local language or English. Documentation is only provided in English.





Day 1: 

  • Introduction and Architecture
  • Installation of PostgreSQL
  • PgAdmin and psql
  • Data design and Data types
  • Using large objects
  • MVCC in PostgreSQL


Day 2:

  • Basic configurations
  • Security
  • Logging and Monitoring
  • Routine maintenance
  • Indexing and fulltext indexing


Day 3:

  • Partitioning 
  • Backup and recovery 
  • Performance and tuning 
  • Basic high availability
  • Warm standby and Slony
  • SQL Optimization


SQL, basic knowledge about database administration in any RDBMS.

Target audience

DBAs who administer and maintain installations of PostgreSQL.


Magnus Hagander

Senior database architect, developer and systems administrator with a broad experience through most of the stack, from hardware to application development. Part of the core developer team for the PostgreSQL open-source relational database. Experienced course instructor and public speaker.

RLPG201 - PostgreSQL Advanced DBA

Start here
100% secure form
Takes a minute to complete
Quick response

Fields marked with * are mandatory
Preferred currency *
Date and place *
How many? (Gift card)
Evt. kampanjekode (Gift card)
Kampanjekoden er korrekt og rabatt er lagt til.
Fant ingen kampanje. Skrev du kampanjekoden riktig?
Kampanjekode er korrekt, men kampanjen gir ikke bedre pris enn nåværende kampanje.
Delegate {{$index+1}}
{{item.is_required ? item.title + '*' : item.title}} {{item.tooltip}}
Filen ble lastet opp
Filen ble fjernet
Laster opp... {{item.upload_progress}}%
{{ file.file.name }} Fjern
{{ctrl.total_price-ctrl.total_with_discount | fprice}} kr {{ctrl.currency}}
{{ctrl.total_vat | fprice}} kr {{ctrl.currency}}

MVA per produkt:

Number: 1+2 *
Please correct the following and try again
Submitting ...
Wait until the file upload is complete

Payment will be made via Payex (VISA, MasterCard, Diners Club, Eurocard and others)

Powered by