MySQL Continuous Database Delivery with Flyway
Pluralsight
Course Summary
Delivering database changes pose a unique set of challenges that force many to treat database changes as a second class citizen when releasing software. In this course, you'll learn how to use Flyway to version changes to a MySQL database. You'll also learn how to leverage versioned changes from your code repository to get early feedback about potential problems, including how to simulate a production database update every time someone checks in a database change.
-
+
Course Description
Continuous Delivery can dramatically decrease turn-around time between customer need and delivered software to fulfill that need. Combining discipline with the right practices and tools leads to early feedback about potential problems, a system of safety nets, the highest level of accountability, and an overall boost in confidence when releasing software. Delivering database changes poses a unique set of challenges that force many to treat database changes as a second class citizen when releasing software. This leads to delays and a lack of realizing the full potential of Continuous Delivery. In this course, you'll learn the fundamentals to make managing database change a breeze and how to make it a first class citizen in your Continuous Delivery pipeline. You'll learn how to use Flyway to version changes to a MySQL database. You'll also learn how to leverage versioned changes from your code repository to get early feedback about potential problems, including how to simulate a production database update every time someone checks in a database change.
-
+
Course Syllabus
Continuous Database Delivery- 38m 30s
—Welcome to the Course 2m 35s
—Shared Development Databases 7m 7s
—What Changed? 8m 17s
—Manual Database Updates 4m 16s
—Continuous Database Delivery 4m 41s
—What Makes this Approach Worthwhile? 9m 20s
—What You'll Learn in This Course 2m 10sTracking Changes- 51m 13s
—Introduction 1m 6s
—Tracking and Applying Changes 4m 24s
—Introducing Flyway 3m 51s
—How We're Going to Build a New Payroll DB. 2m 37s
—Setting up MySQL Locally for a Dedicated Development DB 3m 19s
—Downloading Flyway 1m 32s
—Creating a Payroll DB 9m 15s
—Adding a First Employee Table 7m 22s
—How to Name Change Scripts 3m 42s
—Adding a Second Titles Table 2m 58s
—Dropping and Recreating Dev DBs at the Push of a Button 2m 26s
—Adding Table Relationships with Employee Titles 3m 43s
—Adding an Employee Positions View 2m 32s
—Recap 2m 19sDevelopment Workflow- 42m 40sReverse Engineering Dev DB Changes- 22m 14sPulling Changes- 26m 8sDelivery Workflow- 45m 17sTransition Existing Databases- 46m 9sRethinking How We Develop- 47m 30s