Course Outline
Introduction
Module 1. Refreshing the concepts
- Why we need database migrations
- How Flyway works
- Supported databases
Module 2. Flyway building blocks
- What is a migration
- Understanding Callbacks
- Overriding Errors
Module 3. Understanding the Commands available
- Let's do a migration
- Using the pipeline: Migrate, Clean, Info, Validate
- Using the pipeline: Undo, Baseline, Repair
Module 4. Using different ways to interact with Flyway
- Approaching the command line
- Using the API on Java
- How to use Maven with Flyway
- How to use Gradle with Flyway
- The error codes
Module 5. How to configure Flyway
- The available parameters
- The role of the Environment variables
- Using configuration files
- Understanding placeholders
- Using security via SSL
- How to manage authentication
- How to store secrets
Module 6. Using Advanced concepts
- What is a repeatable migration
- How to undo a migration
- Think about a Java-based migration
- Injecting code into flyway lifecycle via callbacks
- Using error overrides in a productive way
- The essential role of a dry run
Summary and Conclusion
Requirements
- Experience with database management and database management systems
Audience
- Database administrators
Testimonials (4)
Our group was not that big so every time we asked a question we received an extensive answer with examples. So everything was well explained and it can be noticed that trainer has a great knowledge.
Iwona - Universal-Investment-Gesellschaft mit beschränkter Haftung
Course - Access Intermediate
Training Room and quite location and all the stuff.
Abdullah Adelyar - USAID - Kabul Afghanistan
Course - Access VBA
perfect level of knowledge transfair
Pascal - Diehl
Course - Access Advanced
The situation was atypical because an intensive training for developers was to be conducted with non-developers. Lukasz took up this challenge with empathy and a lot of humour. Through his intelligent and flexible manner, he was able to ensure that a concrete learning gain was achieved for everyone. I enjoyed this very much and would gladly take a seminar with Lukasz again.