menu_book Course Curriculum (CI/CD & DevOps Pipelines) expand_more

Pipeline Foundations

Pipeline stages and dependencies Fail-fast pipeline design Idempotent pipeline jobs Immutable build artifacts Pipeline as code Reproducible builds Environment promotion Trunk-based delivery workflow

Triggers, Change Detection & Concurrency

Push trigger Pull request trigger Tag-based release trigger Path-filtered execution Scheduled pipeline Manual dispatch inputs Commit SHA pinning Concurrency and superseded runs

Build, Test & Quality Gates

Dependency cache key design Matrix testing Unit-test gate Integration test service container Lint gate Coverage threshold gate Dependency vulnerability gate SBOM generation

Artifacts, Containers & Supply Chain

Semantic artifact versioning Artifact upload and download Container image build Multi-architecture container build Registry authentication Build provenance attestation Artifact signing Artifact retention policy

Secrets, Identity & Environment Controls

Secret injection OIDC cloud authentication Environment-scoped variables Preventing secret leakage in logs Secret rotation pipeline pattern Protected environment approval Configuration validation before deploy Least-privilege pipeline token

Deployment Strategies & Database Safety

Rolling deployment Blue-green deployment Canary deployment Feature-flagged release Expand-contract database migration Readiness health check gate Automated rollback Post-deploy smoke tests

Pipeline Engines & Reuse

GitLab needs graph Jenkins declarative pipeline CircleCI workflow dependencies Azure DevOps staged pipeline Tekton Task and Pipeline Argo CD sync deployment Reusable workflow interface Pipeline template versioning

Reliability, Observability & Recovery

Retry with bounded backoff Job timeout Cancellation cleanup Deployment notification Pipeline duration metrics Structured pipeline logs Deployment audit record Pipeline incident postmortem evidence

CI/CD & DevOps Pipelines / Deployment Strategies & Database Safety

Expand-contract database migration

Learn Expand-contract database migration through a production-oriented CI/CD example, operational guidance, and a mastery check.

12 min read • Advanced

expand-contract.sql

sql

-- Expand: safe while old application versions still run.
ALTER TABLE customers ADD COLUMN display_name VARCHAR(160) NULL;

-- Backfill in controlled batches before switching reads.
UPDATE customers
SET display_name = full_name
WHERE display_name IS NULL AND id BETWEEN 1 AND 10000;

-- Contract happens in a later release after old code is gone.

What to watch

Content source & attribution

Original Syntaxis Content · Original Syntaxis Content

Lesson quizzes

Expand-contract database migration Mastery Check →

← PREVIOUS

Feature-flagged release

Readiness health check gate

Expand-contract database migration

Lesson quizzes

Notice