Infrastructure at your Service

PostgreSQL for Dev/Ops

dbi InSite Workshops

PostgreSQL is becoming increasingly popular in the Dev/Ops world. This is not only because PostgreSQL is easy and fast to deploy, but also because PostgreSQL comes with many features that make it the perfect choice for rapid development. Going a step further, many companies today adopt public Clouds and choose a managed PostgreSQL service, so they don’t need to take care about operating systems, patching and backup & restore procedures.

Even if PostgreSQL is managed by a public Cloud provider you need to understand the concepts and basic tuning techniques. If you want to gain a fundamental knowledge of PostgreSQL, from architecture to monitoring, from command line psql to graphical interfaces, from loading and unloading data to basic performance tuning topics, this course is for you.

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

-5% for SOUG, SwissPUG, or DOAG members
Members of the SOUG (Swiss Oracle User Group), SwissPUG (Swiss PostgreSQL User Group) or DOAG (Deutsche Oracle-Anwendergruppe) are entitled to a discount of 5% on our trainings

Training objectives

  • Create databases
  • Get used to the command line interface: psql
  • Learn how to get data into and out of PostgreSQL
  • Understand extensions in PostgreSQL
  • Understand monitoring tools
  • Learn how the Cost Based Optimizer optimizes the access to your data
  • Know everything about execution plan operations (sequential scans, index access, sorts, etc.)
  • Monitor the performance with standard PostgreSQL tools and extensions
  • Learn the tuning of queries via features available to the developer and/or DBA
  • Understand the PostgreSQL index types

Content

  • PostgreSQL architecture: processes, cluster, instance, database
  • Optimizer statistics
  • Vacuum
  • MVCC: Multiversion concurrency control
  • ACID
  • psql, the flexible command line interface
  • Extensions: pl/pgsql, pl/perl, pl/python
  • Memory Sizing: shared_buffers, work_mem, …
  • CBO, cardinality, cost, optimization, execution plan, parameters
  • Statistics
  • Sequential scans and indexing
  • Sorts and groups
  • Join methods
  • pg_stat_statements, pg_buffercache
  • Connection handling
  • Transaction isolation levels
  • Performance relevant logging parameters

Method

  • Presentation with many practical exercises
  • Case studies, live demos and discussions
  • Networking during coffee breaks, lunch, and apĂ©ro on the last day (included in price, except for on-site/online workshops)

Target group

  • Developers and DBAs using PostgreSQL as a service, no matter if in a public or private Cloud

Language & documentation

  • Workshop held in English or German
  • Documentation: content details, scripts, case study solutions as PDF file (in English)

Equipment

  • On-site/virtual training: Participants must be equipped with a laptop with access to a browser.

    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 - request & information

      You want dbi services to hold an "on-site" (in your premises) 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 ?