Course Outline
Introduction
Overview of Flyway for Continuous Database Delivery
- Flyway concepts and API
- Shared development databases
- Manual database updates
- Supported platforms
Getting Started with Flyway
- Tracking and applying changes
- Installing and configuring Flyway
- Adding tables
- Changing scripts
Working with Development Workflows
- Establishing a robust development workflow
- Backup and restore
- Database migration
- Migration reversal
- Fixing errors in migration
Working with Reverse Engineering Workflows
- Establishing a robust reverse engineering workflow
- Comparing databases with a backup
- Creating a comparison database from migrations
Pulling Changes with Flyway
- Applying and finding changes
- Database migration on app startup
- Validating past changes on app startup
Working with Delivery Workflows
- Continuous integration
- Testing changes
- Kicking off testing automatically
- Database release pretesting
- Capturing timing information
Transitioning Existing Databases
- Setting up development and production databases
- Alignment strategies to production
- Change scripts
- Marking and migrating productions
- Drift detection
Troubleshooting
Summary and Conclusion
Requirements
- Experience with database management and database management systems
Audience
- Database administrators
- Developers
Testimonials (7)
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
Ćwiczenia praktyczne z trenerem
Zuzanna Szcześniewska - Narodowy Fundusz Zdrowia
Course - Access - Data Base Designing
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