Infrastructure at your Service

PostgreSQL for Developers Workshop

dbi InSite Workshops

Do you want to start developing an application on PostgreSQL or are you already developing on PostgreSQL and want to avoid common mistakes? In this case you should try our training PostgreSQL for developers. In this two-day workshop you will understand what PostgreSQL can do for you from a development perspective. The topics range from basic concepts such as data types and permissions to more advanced topics like PL/pgSQL, partitioning and working with JSON.

Training’s dates

Nyon (in English) 05-06.10.2021
Zurich 01-02.12.2021
OnSite/InSite On demand
2 days
CHF 1800.- *

Trainers

  • Daniel Westermann
    Daniel Westermann
  • Karsten Lenz
    Karsten Lenz

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

  • Understand users, roles  schemas and relations
  • Grant and revoke permissions
  • Understand referential integrity (constraints, foreign keys, primary keys)
  • Get data into and out of PostgreSQL
  • Understand triggers
  • Work with JSON in the database
  • Implement full text search with PostgreSQL

Topics

  • Why developers need to understand the database
  • Defining the requirements for the sample application
  • Using a graphical user interface
  • Making your database secure “instead of Roles and access permissions”
  • Selecting the correct data types
  • Generating data for testing
  • Using identity columns
  • Encrypting and decrypting data
  • Correctly implementing constraints and triggers
  • Using the power of default permissions
  • Implementing row level security
  • Transactional DDL
  • Table partitioning
  • How to use the database for handling JSON data
  • Doing full text search with PostgreSQL

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)
  • Graphical tool courtesy of DB Visualizer

Target groups

  • Developers who want to start working with PostgreSQL
  • Developers already working on PostgreSQL who want to strengthen their database skills
  • Database administrators (DBA) who want to learn more from a development perspective

Language & documentation

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

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 - 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 ?