Database Migration Made Easy: From Manual Changes to Automated CI/CD Pipelines
15
People
2
Days
About Course
Important Notes:
- This course supports both Liquibase and Flyway.
- Participants may choose to focus on Liquibase or Flyway, depending on their preference and requirements.
- Hands-on labs and tool-specific topics will be adjusted based on the selected focus.
- The course outline and content are subject to change based on participant requirements, team context, and time constraints.
DAY 1 – Database Migration Foundations
- This course supports both Liquibase and Flyway.
- Participants may choose to focus on Liquibase or Flyway, depending on their preference and requirements.
- Hands-on labs and tool-specific topics will be adjusted based on the selected focus.
- The course outline and content are subject to change based on participant requirements, team context, and time constraints.
DAY 1 – Database Migration Foundations
- Problems and risks caused by manual database changes
- Schema Versioning concepts and the Database Migration Lifecycle
- Liquibase vs Flyway: concepts, strengths, and trade-offs
- Hands-on: Setting up a database migration project
- Hands-on: Creating and running migrations (based on the selected tool: Liquibase or Flyway)
- Managing rollback, migration conflicts, and baseline databases
DAY 2 – GitLab CI/CD Integration
- Overview of GitLab CI/CD pipelines for database deployment
- Managing secrets and environment variables in CI/CD
- Hands-on:
- Validating database migrations in CI
- Automatically applying migrations to test / staging environments
- Designing rollback and fail-safe strategies
- Best practices for database migration in team-based and microservices environments
- Final Lab:
- Build an end-to-end database migration pipeline using the selected tool
Instructor
Jirat Chokdeeanan
Software Engineer
