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

Delivery Options

Private Group Training

Our identity is rooted in delivering exactly what our clients need.

  • Pre-course call with your trainer
  • Customisation of the learning experience to achieve your goals -
    • Bespoke outlines
    • Practical hands-on exercises containing data / scenarios recognisable to the learners
  • Training scheduled on a date of your choice
  • Delivered online, onsite/classroom or hybrid by experts sharing real world experience

Private Group Prices RRP from €4560 online delivery, based on a group of 2 delegates, €1440 per additional delegate (excludes any certification / exam costs). We recommend a maximum group size of 12 for most learning events.

Contact us for an exact quote and to hear our latest promotions


Public Training

Please see our public courses

Provisional Upcoming Courses (Contact Us For More Information)

Related Categories