LightMySky

Data & Databases

All 21 topics on the way, in the order they build on each other.

  1. The Relational Model and Relational Algebraages 18 to 19 · on the way
  2. Functional Dependencies and Boyce-Codd Normal Formages 18 to 19 · on the way
  3. SQL at Depth: Subqueries, Set Operations and Viewsages 18 to 20 · on the way
  4. Window Functions and Running Calculationsages 19 to 20 · on the way
  5. Indexes: B-Trees and the Cost of a Lookupages 19 to 20 · on the way
  6. Reading a Query Planages 19 to 21 · on the way
  7. Transactions and the ACID Promiseages 19 to 21 · on the way
  8. Isolation Levels and the Anomalies They Allowages 20 to 21 · on the way
  9. Concurrency Control: Locks and Snapshotsages 20 to 21 · on the way
  10. Crash Recovery and Write-Ahead Loggingages 20 to 22 · on the way
  11. Key-Value and Document Storesages 20 to 21 · on the way
  12. Wide-Column and Graph Storesages 20 to 22 · on the way
  13. Partitioning and Replication for Scaleages 21 to 22 · on the way
  14. Data Pipelines: Batch, Streaming and Doing It Twiceages 21 to 22 · on the way
  15. The Data Science Workflowages 21 to 22 · on the way
  16. Cleaning Real Data: Missing, Duplicated and Wrongages 21 to 22 · on the way
  17. Exploratory Analysis and an Honest Chartages 21 to 22 · on the way
  18. Distributed Transactions and the Blocking Case of Two-Phase Commitages 22 to 24 · on the way
  19. Conflict-Free Replicated Data Typesages 22 to 24 · on the way
  20. Log-Structured Storage and Compactionages 22 to 24 · on the way
  21. Stream Processing: Windows, Watermarks and Late Eventsages 23 to 24 · on the way
Data & Databases · Computing · LightMySky