Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Essential but Overlooked Data Management Techniques - What to Expect When You’re Expecting a Growing Database
Preview, Slides, and Links
Preview (66:51)
Slides Download
Supplemental Reading
The Basics
Presentation (42:55)
Authorization & Permissions
Backups
Test Builds
Maintaining Meaningful Determinism
Presentation (78:51)
Identifiers
Uni-directional data flows & single authors
State machines & no stale writes
Transactions with explicitly embedded state
ETL
Tracking and Representing History
Presentation (84:59)
Sourcing
Soft deletes and updates
Tracing
Point-in-time & time series concepts
Auditing
Migrations
Presentation (77:07)
Reference Data versus Data Data
Maintaining Data Consistency
Maintaining Schema Consistency
Zero Downtime
Idempotency
Governance & Data Management
Presentation (99:18)
Defining Correctness, Agreement, and Conflict
Tagging & Enrichment
Human-[in/on]-the-loop Processes
Deduplication & Entity Linking
Access Control
Caches & Specialized Databases
Presentation (56:39)
Cache Invalidation & Refreshes
Source of Truth
Normalization, Denormalization, Pre-calculation
Materialized Views
How to use Triggers
Staying Out of Trouble
Presentation (54:44)
The Trouble with Triggers
Blobs
Breaking up Large Workloads
Code-first Frameworks
Microservices vs. Monoliths
Handling Private Data: PII, PHI, etc.
Teach online with
State machines & no stale writes
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock