Duration
14 hours (usually 2 days including breaks)
Requirements
- Experience with database management and database management systems
Audience
- Database administrators
Overview
Flyway is an open-source database migration tool. It strongly favors simplicity and convention over configuration.
This instructor-led, live training (online or onsite) will teach how to configure and run flyway to build a migration pipeline in SQL. Database-specific syntax such as PL/SQL and T-SQL are supported, as well as Java (for advanced data transformations or for dealing with LOBs). Practical scenarios will help to understand real-world usages.
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
Module 1. Refreshing the concepts
- Why we need database migrations
- How Flyway works
- Supported databases
Module 2. Flyway building blocks
- What is a migration
- Understanding Callbacks
- Overriding Errors
Module 3. Understanding the Commands available
- Let’s do a migration
- Using the pipeline: Migrate, Clean, Info, Validate
- Using the pipeline: Undo, Baseline, Repair
Module 4. Using different ways to interact with Flyway
- Approaching the command line
- Using the API on Java
- How to use Maven with Flyway
- How to use Gradle with Flyway
- The error codes
Module 5. How to configure Flyway
- The available parameters
- The role of the Environment variables
- Using configuration files
- Understanding placeholders
- Using security via SSL
- How to manage authentication
- How to store secrets
Module 6. Using Advanced concepts
- What is a repeatable migration
- How to undo a migration
- Think about a Java-based migration
- Injecting code into flyway lifecycle via callbacks
- Using error overrides in a productive way
- The essential role of a dry run
Summary and Conclusion