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)
Los ejemplos claros que presentó el instructor
José Ernesto Cruz Pineda - Datavision digital
Course - SAP ASE for Database Administrators
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