Phase 3 · Module 7 of 15Quadrant B · the data half
Data and Databases
How does an application remember and retrieve information?
By the end: You can explain how databases organize data and why seemingly simple data changes become technically complicated.
— How databases organize data
L1Databases, structured data, and schemas~16 min○L2Primary keys, foreign keys, and relationships~13 min○L3SQL, queries, and NoSQL databases~23 min○L4Transactions, ACID, and indexes~17 min○— How data goes wrong
L5Schema migrations and data quality~18 min○L6Personal data, backups, metadata, and retention~20 min○— The analytics world
L7Data warehouses, pipelines, and analytics~24 min○What lights on your map here
structured dataunstructured datadatabaserelational databaseNoSQL databasetablerowcolumnschemaprimary keyforeign keyrelationshipquerySQLreadwritetransactionindexmigrationdata validation (RE: M5)NULLsource of truth (RE: M1)duplicate datadata qualitypersonally identifiable informationbackuprestoremetadatadata retentiondata warehousedata lakedata pipelineETLELTbatchstreaming
Recognition terms — you'll know they exist
ACIDreplicationpartitioningshardingeventual consistency
Named technologies
PostgreSQLMongoDBSnowflakeKafkaSpark