← 🗄️ Data & SQL Engineering
Advanced
Lakehouse, Delta and the Medallion Architecture
A lakehouse puts a transactional table format over cheap object storage, so a data lake gets ACID writes, schema enforcement and time travel without becoming a warehouse. The medallion layering on top (bronze, silver, gold) is less about the metaphor than about giving each layer an owner and a contract.
Unlock the full curriculum — ₹2,000 / $25every concept + every answer · 6 months · no auto-renew
RELATED CONCEPTS
LESSONS THAT TEACH THIS
PRACTICE THIS IN REAL QUESTIONS
SQL & Data EngineeringA customer's Delta table has 4 million small files and every query crawls. What happened, and how do you fix it?→SQL & Data EngineeringLakehouse vs data warehouse, and what does ACID on a data lake actually buy you?→SQL & Data EngineeringDesign CDC from a customer's Oracle ERP into the lakehouse, including deletes and schema evolution.→SQL & Data EngineeringFrom user activity logs, find the top 3 most active users for each day, handling ties appropriately.→SQL & Data EngineeringWrite PySpark to read a directory of JSON files, flatten the nested schema, and write a Delta table partitioned by date.→SQL & Data EngineeringYour CDC stream replays a batch and a customer issues a GDPR deletion mid-stream. Keep the silver mirror exactly-once and compliant.→