Database Delivery Best Practices
Keeping track of your application's database is never an easy task. You will learn different approaches to database delivery and best practices that will help you avoid running into common pitfalls in this area.
What you'll learn
While such topics as source code versioning and continuous delivery are pretty well-known, many programmers still struggle with the process of database delivery, which, if left without proper management, may lead to significant maintainability issues down the road. If you ever found your database delivery process unreliable or you are willing to avoid falling into such situation in the future, this course is for you. In Database Delivery Best Practices, you will learn different approaches to database delivery and best practices that will help you avoid running into common pitfalls in this area. First, you'll learn how to build a reliable, evolutionary process of the database delivery. The course covers such topics as state-based and migration-based approaches to database delivery: which of them is suitable in what circumstances; patterns for refactoring the database in case it is used by multiple applications. You will also go through building your own light-weight database versioning tool which will help you better understand the whole database delivery process. In the end, you'll be able to keep better track of your app's database and maintain it for future use.
Table of contents
- Introduction 1m
- Creating an Initial Snapshot 3m
- Recap: Creating an Initial Snapshot 1m
- Versioning 5m
- Renaming a Column 3m
- Handling Merge Conflicts 2m
- Splitting the Name Column 4m
- Recap: Splitting the Name Column 2m
- Extracting a User Status Table 3m
- Defining Reference Data 2m
- Database Drifts 3m
- Summary 1m
- Introduction 1m
- Introducing the Migration-based Approach 3m
- Introducing Fluent Migrator 2m
- Creating an Initial Version 5m
- Recap: Creating an Initial Version 1m
- Renaming a Column 1m
- Splitting the Name Column 2m
- Recap: Splitting the Name Column 1m
- Extracting the User Status Table 2m
- Changing Reference Data 2m
- Dealing with Database Drifts 4m
- Handling Merge Conflicts 2m
- Enumerating Migrations: Numbers or Timestamps? 2m
- What to Do with Ever Increasing Number of Migrations? 1m
- State-based vs. Migration-based Database Delivery 6m
- What Approach to Choose? 2m
- Combining the Two Approaches 3m
- Summary 2m
- Introduction 0m
- Integration Databases 3m
- Refactoring Integration Databases 3m
- Renaming the User Table 4m
- Recap: Renaming the User Table 2m
- Splitting the Name Column 6m
- Recap: Splitting the Name Column 1m
- Making a Nullable Column Non-nullable 2m
- Recap: Making a Nullable Column Non-nullable 1m
- Module Summary 2m
- Resource List 1m
- Course Summary 2m
About the author
Vladimir Khorikov is the author of the book Unit Testing Principles, Practices, and Patterns: https://amzn.to/2QXS2ch He has been professionally involved in software development for over 15 years, including mentoring teams on the ins and outs of unit testing. He's also the founder of the Enterprise Craftsmanship blog, where he reaches 500 thousand software developers yearly. He started as an adviser on general programming topics, but lately has shifted his focus to unit testing with a central ... more