Thank you for sending your enquiry! One of our team members will contact you shortly.
Thank you for sending your booking! One of our team members will contact you shortly.
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)
personalised to our understanding and data
Vincent Long - ASSMANG PTY LTD
Course - Business Intelligence with SSAS
The training instruments provided.
- UNIFI
Course - NoSQL Database with Microsoft Azure Cosmos DB
The adjustment made in the lecture/lessons by the trainer once he understood the current SSIS application that we are bound to maintain. The topics became more suitable/usable to us.
