Data Storage & Processing

Master the data storage patterns and processing techniques that power enterprise analytics in Microsoft Fabric. In this hands-on course, you’ll design scalable lakehouse solutions and build production-grade storage architectures that support performance, governance, and advanced analytics workloads. You’ll implement a Medallion architecture in OneLake using bronze, silver, and gold layers, and register lineage in Microsoft Purview. You’ll ingest data into a Fabric Lakehouse using pipelines, Copy Jobs, and notebooks while selecting appropriate Delta table types. You’ll query data through the SQL Endpoint for analysis and use notebooks for programmatic access, then enforce consistency with time-travel queries and MERGE-based ACID transactions using Delta Lake. You’ll also optimize tables with OPTIMIZE, ZORDER, and VACUUM operations and design a Fabric Warehouse schema in T-SQL to support star-schema analytics and incremental loads. By the end, you’ll have practical experience building optimized Lakehouse and Warehouse solutions and the core data engineering skills required for enterprise Fabric implementations.