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)
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