Course Outline
Introduction
Overview of Flyway Features and Architecture
- Core concepts
- Existing plugins
- Supported databases
Getting Started with Flyway
- Setting up the Flyway command-line tool
- Initial configuration
- The 7 basic commands
Migrating with Flyway
- SQL-based migrations
- Java-based migrations
- Script migrations
- Transactions, query results, and schemas
Configuring Flyway
- Parameters
- Environment variables
- Config files and placeholders
- SSL support and authentication
- Secrets management
Executing Database Migrations
- Running the Flyway API
- Executing migrations with Maven plugin
- Executing migrations with Gradle plugin
Integrating Flyway into a Project with Existing Databases
- Data extract and cleanup
- Aligning the databases
- Creating baseline versions
Managing Database Migrations
- Reviewing migration status
- Creating repeatable migrations
- Undoing migrations
- Executing callbacks
- Overriding errors
- Performing dry runs
Exploring Advanced Flyway Features
- Test data management
- Backward compatible migrations
- Zero-downtime migrations
Troubleshooting
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.