SQL Server 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. You'll learn how to use Flyway to version changes to a SQL Server database, and 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 SQL Server database. We will also cover 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 37s
—Welcome to the Course 2m 42s
—Shared Development Databases 7m 7s
—What Changed? 8m 17s
—Manual Database Updates 4m 17s
—Continuous Database Delivery 4m 41s
—What Makes This Approach Worthwhile? 9m 20s
—What You'll Learn in This Course 2m 10sTracking Changes- 57m 36s
—Introduction 1m 17s
—Tracking and Applying Changes 4m 33s
—Introducing Flyway 2m 20s
—How We're Going to Build a New Payroll DB 2m 52s
—Demo: Setting up SQL Server Locally for a Dedicated Dev DB 3m 34s
—Demo: Downloading Flyway 3m 12s
—Demo: Creating a payroll DB and Connecting Flyway to the DB 14m 13s
—Demo: Adding a First Employee Table 7m 57s
—Demo: How to Name Change Scripts 2m 57s
—Demo: Adding a Second Titles Table with Data 3m 58s
—Demo: Dropping and Recreating Dev DBs at the Push of a Button 2m 5s
—Demo: Adding Table Relationships with Employee Titles 3m 33s
—Demo: Adding an Employee Positions View 3m 55s
—Recap 1m 5sDevelopment Workflow- 1h 2mReverse Engineering Dev DB Changes- 44m 4sPulling Changes- 32m 36sDelivery Workflow- 50m 20sTransition Existing Databases- 52m 2sRethinking How We Develop- 47m 27s