Infrastructure at your Service

PostgreSQL DBA essentials workshop

dbi InSite Workshops

You may have PostgreSQL databases running on your IT infrastructure and need to acquire the best practices in database administration (DBA) to get the best out of PostgreSQL You want to know more on PostgreSQL backup and security strategy? In this case you should try our training PostgreSQL Essentials for DBAs. In this two-day workshop course you will understand the PostgreSQL architecture, acquire the best practices in PostgreSQL DBA and experience how to safely perform backups. Additionally you will learn about the various high-availability options and setup a hot standby database.

Training’s dates

Nyon 27-28.05.2021
Basel 17-18.06.2021
Zurich 17-18.06.2021
Bern 17-18.06.2021
On-site/Online On demand
2 days
CHF 1800.- *

Company package for groups**
CHF 6990.-

Trainers

  • Daniel Westermann
    Daniel Westermann
  • Mouhamadou Diaw
    Mouhamadou Diaw

By booking a dbi services’ InSite workshop, the customer commits to respecting the Sales and Service General Conditions

(*) Prices are to be considered per participant and without VAT

(**) Flat-rate offer for groups (4-6 participants of the same company). Beyond 6 participants, on request

SOUG (Swiss Oracle User Group) The members of the SOUG (Swiss Oracle User Group) benefit from a 5 % reduction.

Training objectives

  • Understand the PostgreSQL architecture
  • Installing PostgreSQL from source
  • Understand what is common to and what is different from other databases such as Oracle
  • Create databases
  • Get used to the command line interface: psql
  • Understand backup and restore procedures in PostgreSQL
  • Understand extensions in PostgreSQL
  • Create a hot standby database
  • Understand the optimizer, statistics and vacuum
  • Understand monitoring tools
  • Upgrades in PostgreSQL

PostgreSQL Training Topics

  • PostgreSQL installation methods: from source code, using operating systems vendor packages, using graphical installers
  • PostgreSQL architecture: processes, cluster, instance, database
  • How PostgreSQL organizes the files on disk
  • Dumping, restoring, point in time recovery
  • Standby databases
  • Optimizer statistics
  • Vacuum
  • MVCC: Multiversion concurrency control
  • ACID
  • psql, the flexible command line interface
  • Extentions: pl/pgsql, pl/perl, pl/python
  • Tablespaces
  • WAL, the write ahead log
  • The client authentication system

Training Method

  • Presentation with numerous exercises, case studies, and live demos
  • Discussions and networking during coffee break, lunch, and apĂ©ro on last day (included in price, except for on-site workshop courses)

Target groups

  • Database administrators (DBA) as well as network, system and application administrators responsible for or supporting PostgreSQL databases

Language & documentation

  • The workshop will be held in French in Lausanne and Geneva and in German in Basel, Zurich and Bern.
  • Documentation: content details, scripts, case study solutions as PDF file (in English

Equipment

  • On-site training: As this training is provided on a Cloud platform, participants must be equipped with a laptop in order to access the Cloud infrastructure through an ssh client.

For your information

    dbi InSite Workshop - book now!

    You want to book a dbi InSite Workshop or get more information on our IT trainings? Please fill in the entry form below. We will confirm your participation or come back to you as soon as possible. If, to our regret, the workshop is already fully booked, we will inform you on other dates or alternative solutions.

    Training sessions :




    Please contact me via :

    E-mailPhone

    Where did you know dbi services ?


      dbi InSite Workshop on-site/online - request & information

      You want dbi services to hold an "on-site" workshop (in your premises) or an online workshop for you ? You have special requirements, e. g. regarding the content, the duration, the date, or the number of participants?
      We have good news for you: Our dbi InSite Workshops can be flexibly adapted to your needs! Please just fill in the form below and we will come back to you as soon as possible. You may also use this form to inquire on the future dates of our dbi InSite Workshops.





      Please contact me via :

      E-mailPhone

      Where did you know dbi services ?


      [anr_nocaptcha g-recaptcha-response]