ETL, pipelines, architecture concepts
Master the differences between databases and data warehouses, OLTP vs OLAP, normalized vs star schema, row vs columnar storage. Plus detailed Dedicated vs Serverless SQL Pool comparison with cost calculations, decision framework, and real-world scenarios.
Build a complete SCD Type 2 pipeline using Synapse Data Flows. Every transformation explained: hash generation, lookup, conditional split, parallel expire+insert paths, dual sinks. Includes surrogate key strategy, first-run vs subsequent-run walkthroughs, point-in-time queries, and common errors.
Build an SCD Type 1 pipeline with SHA-256 hash-based change detection using Synapse Data Flows. Every transformation explained: Source, Derived Column (hash), Select (SRC_ prefix), Lookup (left outer), Conditional Split (new/changed/unchanged), Alter Row (insert/update), Union, and Sink. Includes audit trail design, idempotency, and first-run vs subsequent-run walkthroughs.
Build a complete SCD Type 1 pipeline from scratch with every activity explained. Covers Lookup, ForEach, Copy, audit logging with stored procedures, parameterized datasets, the complete parameter flow chain, date-partitioned output, and the restaurant kitchen analogy that makes it all click.
Complete guide to setting up Azure Synapse Analytics. Covers workspace creation, Synapse Studio walkthrough, Serverless SQL Pool, Dedicated SQL Pool, Spark Pool, building your first pipeline, Git integration, Managed VNet, RBAC roles, cost management, and when to use Synapse vs standalone ADF.
Azure Synapse Analytics Workspace Setup Guide: From Creation to Your First Pipeline Read More »
Master cloud computing fundamentals. On-premises vs Public vs Private vs Hybrid cloud, IaaS vs PaaS vs SaaS with the pizza analogy, the Shared Responsibility Model across all service models, CapEx vs OpEx, Azure services mapped to each model, and real-world migration scenarios.
Master every data file format in Azure. CSV, JSON, Parquet, Delta Lake, Avro, and ORC compared with real-life analogies. Covers row vs column orientation, compression algorithms, schema evolution, small files problem, Medallion architecture format selection, and Delta Lake deep dive with ACID, time travel, MERGE, and OPTIMIZE.
Master SCD Types 0, 1, 2, 3, and 6 with detailed table examples and real-life analogies. Covers implementation in Azure SQL, Synapse Data Flows, and Delta Lake MERGE. Includes edge cases, Medallion architecture integration, and interview questions.
Master every join type in Synapse Data Flows with real datasets and visual before/after tables. Covers Inner, Left Outer, Right Outer, Full Outer, Cross, Exists, and Lookup. Includes broadcast optimization, duplicate column handling, and performance tips.
Joins in Azure Synapse Data Flows: Every Join Type Explained with Real-World Examples Read More »
Decode every JSON structure in Azure Data Factory. Covers Linked Services, Datasets, Pipelines (simple copy, metadata-driven, incremental, audit logging), Triggers, Integration Runtimes, and Data Flows. Learn to read, edit, and troubleshoot ADF JSON for Git integration and CI/CD.
