766 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- Data Lakehouse201
- Apache Iceberg196
- Data Engineering182
- Dremio66
- AI Agents58
- developer tools35
- AI coding tools31
- Apache Polaris31
- agentic development31
- MCP29
- Databases28
- Semantic Layer28
- AI26
- Data Architecture25
Latest tutorials
Page 68 of 128- 01Dimensional 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:...Data ModelingFeb 19, 2026
- 02Slowly 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...Data ModelingFeb 19, 2026
- 03Data 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...Data ModelingFeb 19, 2026
- 04Denormalization: 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...Data ModelingFeb 19, 2026
- 05Data 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...Data ModelingFeb 19, 2026
- 06Data Modeling Best Practices: 7 Mistakes to AvoidA bad data model doesn't announce itself. It hides behind slow dashboards, conflicting numbers, confused analysts, and AI agents that generate wrong SQL. By ...Data ModelingFeb 19, 2026