Infrastructure at your Service

Migrating to PostgreSQL

dbi InSite Workshops

Migrations to PostgreSQL are a hot topic and a lot of companies are considering this transition. If this is a subject for you as well, you should take part in this two-day workshop. Our experts share their experiences and knowledge on migrations to PostgreSQL. Through various practical exercises and live demos, you will understand how PostgreSQL is different from other databases and what tools are available to assist migrations to PostgreSQL. You will also learn which workarounds you can apply if you are dependent on a specific functionality of your source database that is either not available in PostgreSQL or implemented in another way.

Training’s dates

2 days
CHF 1800.- *

Trainers

  • Daniel Westermann
    Daniel Westermann

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

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

Training objectives

  • Understand database migrations in general
  • Get an overview of tools that support in migrations to PostgreSQL
  • Key points to consider when migrating to PostgreSQL
  • PostgreSQL data types
  • Logical replication
  • Online and offline migrations
  • Loading data in PostgreSQL

Topics

  • PostgreSQL MVCC
  • NULL handling in PostgreSQL
  • Constraints in PostgreSQL
  • Not null constraints in PostgreSQL
  • Migration tools with exercises
  • Foreign data wrappers
  • PostgreSQL partitioning
  • Functions and procedures
  • Differences with other database systems

Method

  • Presentation with countless practical exercises and trainings
  • Case studies, live demos, discussions
  • Networking during coffee break, lunch, and apéro on last day (included in price, except for on-site/online workshop courses)

Target groups

  • Database administrators (DBAs) and developers who want to get deep understanding of migrations to PostgreSQL

Language & documentation

  • Workshop training normally held in English; French or German possible instead as course languages
  • Documentation: content details, scripts, case study solutions as PDF file (in English)

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 ?



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 ?