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.

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 ?


[anr_nocaptcha g-recaptcha-response]

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 ?