Course Outline
Introduction
Module 1. Refreshing the concepts
- Why we need database migrations
- How Flyway works
- Supported databases
Module 2. Flyway building blocks
- What is a migration
- Understanding Callbacks
- Overriding Errors
Module 3. Understanding the Commands available
- Let's do a migration
- Using the pipeline: Migrate, Clean, Info, Validate
- Using the pipeline: Undo, Baseline, Repair
Module 4. Using different ways to interact with Flyway
- Approaching the command line
- Using the API on Java
- How to use Maven with Flyway
- How to use Gradle with Flyway
- The error codes
Module 5. How to configure Flyway
- The available parameters
- The role of the Environment variables
- Using configuration files
- Understanding placeholders
- Using security via SSL
- How to manage authentication
- How to store secrets
Module 6. Using Advanced concepts
- What is a repeatable migration
- How to undo a migration
- Think about a Java-based migration
- Injecting code into flyway lifecycle via callbacks
- Using error overrides in a productive way
- The essential role of a dry run
Summary and Conclusion
Requirements
- Experience with database management and database management systems
Audience
- Database administrators
Testimonials (6)
Our group was not that big so every time we asked a question we received an extensive answer with examples. So everything was well explained and it can be noticed that trainer has a great knowledge.
Iwona - Universal-Investment-Gesellschaft mit beschränkter Haftung
Course - Access Intermediate
Organizacja i praktyczne podejście do tematy
Adam Cedrowicz - Unilever Poland Services sp. z o.o
Course - Access - podstawy
Szkolenie przeprowadzone gruntownie od zagadnień podstawowych po te bardzo zaawansowane. Trener przyjazny, chętnie udzielający odpowiedzi na zadawane pytania.
Anna Gerlich - UBS Business Solutions Poland Sp. z o.o.
Course - SQL in Microsoft Access
Spora wiedza prowadzącego
Marcin Doleżyk
Course - Visual Basic for Applications (VBA) w Microsoft Office Access i Excel
Training Room and quite location and all the stuff.
Abdullah Adelyar - USAID - Kabul Afghanistan
Course - Access VBA
perfect level of knowledge transfair