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 Key Concepts
- The necessity of database migrations
- Understanding how Flyway operates
- Supported databases
Module 2: Flyway Building Blocks
- Defining a migration
- Understanding Callbacks
- Overriding Errors
Module 3: Mastering Available Commands
- Executing a migration
- Utilizing the pipeline: Migrate, Clean, Info, Validate
- Utilizing the pipeline: Undo, Baseline, Repair
Module 4: Interaction Methods with Flyway
- Command-line approach
- Using the Java API
- Integrating Flyway with Maven
- Integrating Flyway with Gradle
- Interpreting error codes
Module 5: Configuring Flyway
- Available parameters
- The role of environment variables
- Using configuration files
- Understanding placeholders
- Implementing SSL security
- Managing authentication
- Storing secrets securely
Module 6: Advanced Concepts
- What constitutes a repeatable migration
- Reverting a migration
- Considerations for Java-based migrations
- Injecting code into the Flyway lifecycle via callbacks
- Leveraging error overrides effectively
- The critical importance of dry runs
Summary and Conclusion
Requirements
- Experience with database management and database management systems
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.
