Data Engineer · Stage 1 of 5

Foundation

What data engineers build, OLAP vs OLTP, warehouse vs lake vs lakehouse, ETL vs ELT. Four concept pages, no code.

8 items1.5 hrs estimated
0/8 complete · 0%
Start stage →

In this stage

  1. ConceptWhat is a Data Engineer
  2. ProblemJoining Postgres, Stripe, and Salesforce for Analyticseasy
  3. ConceptOLAP vs OLTP — The Core Difference
  4. ProblemPostgreSQL Analytics Performance Issueeasy
  5. ConceptData Warehouse vs Data Lake vs Lakehouse
  6. ProblemLakehouse Architecture for 50TB of JSON Eventseasy
  7. ConceptSQL Window Functions — The Complete Mental Model
  8. Boss · Submit with a score ≥75 to unlock the next stageWindow Functions for Order Analyticseasy