EulerFold
ToolsGeneratorPlannerPractice
Research & LibraryResearchArticlesLibraryLeaderboard
PlatformAboutPricing
Get Started
Backend Engineers & DBAs

Database Migration Strategies Without Downtime

4 weeks
0 Learners
eulerfoldeulerfold
Jul 23

“Blue-green schemas and expand-contract patterns and shadow writes: the ops side no one teaches. This comprehensive curriculum is designed to give you hands-on experience with Database Migration Strategies Without Downtime.”

Share:

About this Course

Blue-green schemas and expand-contract patterns and shadow writes: the ops side no one teaches. This comprehensive curriculum is designed to give you hands-on experience with Database Migration Strategies Without Downtime. This Backend Engineers & DBAs curriculum is designed to give you hands-on experience and deep conceptual understanding. Across 4 intensive modules, you'll tackle real-world challenges and build practical projects that reinforce your learning. By the end of this journey, you'll have the skills and proof of work to demonstrate your expertise.

What you'll learn

Master the core concepts of expand-contract (parallel change) pattern.
Gain hands-on experience with non-blocking ddl operations.
Understand the architecture behind shadow writing & dual reads.
Implement production-grade large-scale table refactoring & data partitioning.

Prerequisites

intermediate Level

Requires basic familiarity with the tech stack.

  • Relational database concepts
  • Basic SQL queries

Ideal for

Backend Engineers & DBAs

Backend Engineers
Data Engineers
W1

Expand-Contract (Parallel Change) Pattern

Master the core concepts of expand-contract (parallel change) pattern.

3 videos•27m
2 readings
3 topics
1 homework
Learn

Topics

1.1
Phase 1: Expanding Schemas without Breaking Old Code
8 minutes
1.2
Phase 2: Dual Writing & Backfilling Data Safely
11 minutes
1.3
Phase 3: Contracting Schemas & Cleaning Up Legacy Columns
8 minutes

Study Resources

→Hi Fabrizio, thanks for replying I completely agree with expand and...→Refactor Planning for Backend Engineers — BoardSnap
W2

Non-Blocking DDL Operations

Gain hands-on experience with non-blocking ddl operations.

3 videos•62m
3 readings
3 topics
1 homework
Learn
W3

Shadow Writing & Dual Reads

Understand the architecture behind shadow writing & dual reads.

3 videos•42m
3 readings
3 topics
1 homework
Learn
W4

Large-Scale Table Refactoring & Data Partitioning

Implement production-grade large-scale table refactoring & data partitioning.

3 videos•62m
3 readings
3 topics
1 homework
Learn
01

Learn

Watch curated videos and read study resources

02

Practice

Practice what you learned

03

Build Projects

Build projects using your new gained knowledge

04

Submit & Verify

Submit your project and get verified by our system

References

01Hi Fabrizio, thanks for replying I completely agree with expand and...
02Refactor Planning for Backend Engineers — BoardSnap
03Part I. Tutorial - PostgreSQL
04Online DDL and Non-Blocking Migrations — How It Works
05PostgreSQL 18.4 Documentation
06Shadow Reads: The Secret Weapon for Safe Database Migrations
07Zero-Downtime Database Migration: Shadow Writes, Dual-Read ...
08Documenting Backend Code: A Guide for 2025
09Database Partitioning and Horizontal Scaling | DB Partitioning
10Data Partitioning Strategies for Scalable Systems
11Master SQL Table Partitioning: Expert DBA Guide

Rate this course

0.0
0 reviews

Help the community find verified technical paths.

Community Insights

0

Join the discussion

Sign in to share your thoughts and technical insights.

Loading insights...