749 tutorials · free to read

A working handbook for data and software engineering.

Hands-on tutorials by Alex Merced on Apache Iceberg, the data lakehouse, pipelines, agentic AI, and the languages and tools that hold it all together.

Browse by topic

All topics

Latest tutorials

Page 65 of 125
  1. 01Data Modeling for the Lakehouse: What ChangesTraditional data modeling assumed you controlled the database. You defined schemas up front, enforced foreign keys at write time, and optimized with indexes....
  2. 02Dimensional Modeling: Facts, Dimensions, and GrainsDimensional modeling is the most widely used approach for organizing analytics data. Developed by Ralph Kimball, it structures data into two types of tables:...
  3. 03Slowly Changing Dimensions: Types 1-3 with ExamplesDimensions change. A customer moves cities. A product gets reclassified. An employee changes departments. How your data model handles these changes determine...
  4. 04Data Modeling for Analytics: Optimize for Queries, Not TransactionsThe data model that runs your production application is almost never the right model for analytics. Transactional systems are designed for fast writes : in...
  5. 05Denormalization: When and Why to Flatten Your DataNormalization is the first rule taught in database design. Eliminate redundancy. Store each fact once. Use foreign keys. It's the right rule for transactiona...
  6. 06Data Vault Modeling: Hubs, Links, and SatellitesDimensional modeling works well when your source systems are stable and your business questions are predictable. But what happens when sources change constan...