Course Outline
Introduction
Module 1. Concept Review
- The necessity of database migrations
- How Flyway operates
- Supported databases
Module 2. Flyway Fundamentals
- Defining a migration
- Understanding Callbacks
- Overriding Errors
Module 3. Command Overview
- Executing a migration
- Utilizing the pipeline: Migrate, Clean, Info, Validate
- Utilizing the pipeline: Undo, Baseline, Repair
Module 4. Interaction Methods for Flyway
- Command-line interface
- Using the Java API
- Integrating Maven with Flyway
- Integrating Gradle with Flyway
- Error codes
Module 5. Configuring Flyway
- Available parameters
- The role of environment variables
- Using configuration files
- Understanding placeholders
- Ensuring security via SSL
- Managing authentication
- Storing secrets
Module 6. Advanced Concepts
- What constitutes a repeatable migration
- Undoing a migration
- Implementing Java-based migrations
- Injecting code into the Flyway lifecycle via callbacks
- Effectively using error overrides
- The critical role of dry runs
Summary and Conclusion
Requirements
- Experience with database management systems and database administration.
Audience
- Database administrators.
Custom Corporate Training
Training solutions designed exclusively for businesses.
- Customized Content: We adapt the syllabus and practical exercises to the real goals and needs of your project.
- Flexible Schedule: Dates and times adapted to your team's agenda.
- Format: Online (live), In-company (at your offices), or Hybrid.
Price per private group, online live training, starting from 2600 € + VAT*
Contact us for an exact quote and to hear our latest promotions
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.
