Course Outline
Introduction
Module 1. Refreshing the concepts
- The need for database migrations.
- How Flyway operates.
- Supported databases.
Module 2. Flyway building blocks
- Defining a migration.
- Understanding Callbacks.
- Overriding Errors.
Module 3. Understanding the available Commands
- Executing a migration.
- Using the pipeline: Migrate, Clean, Info, Validate.
- Using the pipeline: Undo, Baseline, Repair.
Module 4. Methods for interacting with Flyway
- Approaching the command line.
- Using the API in Java.
- Integrating Maven with Flyway.
- Integrating Gradle with Flyway.
- Interpreting error codes.
Module 5. Configuring Flyway
- Available parameters.
- The role of Environment variables.
- Utilizing configuration files.
- Understanding placeholders.
- Implementing security via SSL.
- Managing authentication.
- Storing secrets securely.
Module 6. Advanced concepts
- Understanding repeatable migrations.
- Undoing a migration.
- Considering Java-based migrations.
- Injecting code into the Flyway lifecycle via callbacks.
- Using error overrides effectively.
- The essential role of a dry run.
Summary and Conclusion
Requirements
- Prior experience with database management and database management systems.
Audience
- Database administrators.
Testimonials (4)
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.
- UNIFI
Course - NoSQL Database with Microsoft Azure Cosmos DB
Learning about a new tool, the practices help a lot in understanding the topics, and that was what I liked the most.
David Vargas Alpizar - BANCO BAC SAN JOSE S.A
Course - Oracle Database 19c: Administration
Machine Translated
