Course Outline
Introduction
Overview of Flyway for Continuous Database Delivery
- Flyway concepts and API
- Shared development databases
- Manual database updates
- Supported platforms
Getting Started with Flyway
- Tracking and applying changes
- Installing and configuring Flyway
- Adding tables
- Changing scripts
Working with Development Workflows
- Establishing a robust development workflow
- Backup and restore
- Database migration
- Migration reversal
- Fixing errors in migration
Working with Reverse Engineering Workflows
- Establishing a robust reverse engineering workflow
- Comparing databases with a backup
- Creating a comparison database from migrations
Pulling Changes with Flyway
- Applying and finding changes
- Database migration on app startup
- Validating past changes on app startup
Working with Delivery Workflows
- Continuous integration
- Testing changes
- Kicking off testing automatically
- Database release pretesting
- Capturing timing information
Transitioning Existing Databases
- Setting up development and production databases
- Alignment strategies to production
- Change scripts
- Marking and migrating productions
- Drift detection
Troubleshooting
Summary and Conclusion
Requirements
- Experience with database management and database management systems
Audience
- Database administrators
- Developers
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.