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

Requirements

  • Experience with database management and database management systems

Audience

  • Database administrators
  14 Hours
 

Testimonials (3)

Related Courses

Related Categories