Duration
14 hours (usually 2 days including breaks)
Requirements
- Experience with database management and database management systems
Audience
- Database administrators
- Developers
Overview
Flyway is an open-source database migration tool that automates SQL or Java-based database migrations. Flyway helps software teams manage changes to their databases, simulate updates, and predict potential issues.
This instructor-led, live training (online or onsite) is aimed at database administrators and developers who wish to install, configure, and manage Flyway to track and apply changes in their continuous database delivery efforts.
By the end of this training, participants will be able to implement, track, reverse, and manage database workflows and changes to improve their continuous database delivery.
Format of the Course
- Interactive lecture and discussion.
- Lots of exercises and practice.
- Hands-on implementation in a live-lab environment.
Course Customization Options
- To request a customized training for this course, please contact us to arrange.
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