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