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 Review
- The necessity of database migrations
- How Flyway functions
- Supported databases
Module 2: Core Components of Flyway
- Defining a migration
- Understanding Callbacks
- Overriding Errors
Module 3: Command Reference
- Executing a migration
- Utilizing the pipeline: Migrate, Clean, Info, Validate
- Utilizing the pipeline: Undo, Baseline, Repair
Module 4: Interaction Methods with Flyway
- Command-line interface basics
- Using the Java API
- Integrating Maven with Flyway
- Integrating Gradle with Flyway
- Error codes and their meanings
Module 5: Flyway Configuration
- Available configuration parameters
- The role of environment variables
- Utilizing configuration files
- Working with placeholders
- Implementing security via SSL
- Managing authentication
- Best practices for storing secrets
Module 6: Advanced Concepts
- Understanding repeatable migrations
- Performing a migration rollback
- Exploring Java-based migrations
- Injecting code into the Flyway lifecycle via callbacks
- Effectively using error overrides
- The critical importance of dry runs
Summary and Conclusion
Requirements
- Prior experience with database management and Database Management Systems (DBMS)
Target 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.
