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: Concept Refresher
- The necessity of database migrations.
- Understanding Flyway's operational mechanics.
- Overview of supported databases.
Module 2: Core Components of Flyway
- Defining what constitutes a migration.
- Comprehending Callbacks.
- Techniques for overriding Errors.
Module 3: Exploring Available Commands
- Executing a migration.
- Utilizing the pipeline: Migrate, Clean, Info, and Validate.
- Utilizing the pipeline: Undo, Baseline, and Repair.
Module 4: Interaction Methods with Flyway
- Command-line interface approaches.
- Utilizing the Java API.
- Integrating Maven with Flyway.
- Integrating Gradle with Flyway.
- Decoding error codes.
Module 5: Configuring Flyway
- Overview of available parameters.
- The function of Environment variables.
- Implementing configuration files.
- Understanding placeholders.
- Ensuring security via SSL.
- Managing authentication processes.
- Secure storage of secrets.
Module 6: Advanced Concepts
- Defining repeatable migrations.
- Procedures for undoing a migration.
- Considerations for Java-based migrations.
- Injecting code into the Flyway lifecycle via callbacks.
- Effectively utilizing error overrides.
- The critical importance of dry runs.
Summary and Conclusion
Requirements
- Prior experience with database management and Database Management Systems (DBMS) is required.
Target Audience
- Database administrators.
14 Hours
Testimonials (3)
good explanation on each points and provide assignment for practices.
Piseth Ben - ACLEDA Bank Plc.
Course - Oracle Database 19c: SQL Tuning Workshop
personalised to our understanding and data
Vincent Long - ASSMANG PTY LTD
Course - Business Intelligence with SSAS
The training instruments provided.
