MyPage is a personalized page based on your interests.The page is customized to help you to find content that matters you the most.


I'm not curious

SQL Server Continuous Database Delivery with Flyway

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 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 10s
    Tracking 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 5s
    Development Workflow
    - 1h 2m
    Reverse Engineering Dev DB Changes
    - 44m 4s
    Pulling Changes
    - 32m 36s
    Delivery Workflow
    - 50m 20s
    Transition Existing Databases
    - 52m 2s
    Rethinking How We Develop
    - 47m 27s


Course Fee:
USD 29

Course Type:

Self-Study

Course Status:

Active

Workload:

1 - 4 hours / week

This course is listed under Development & Implementations and Data & Information Management Community

Attended this course?

Back to Top

 
Awards & Accolades for MyTechLogy
Winner of
REDHERRING
Top 100 Asia
Finalist at SiTF Awards 2014 under the category Best Social & Community Product
Finalist at HR Vendor of the Year 2015 Awards under the category Best Learning Management System
Finalist at HR Vendor of the Year 2015 Awards under the category Best Talent Management Software
Hidden Image Url

Back to Top