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.

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

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

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)

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)

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

You want dbi services to hold an "on-site" workshop inside your organisation? 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 ?