Azure is becoming a default choice for companies already running on Microsoft 365, which makes pairing it with Terraform for infrastructure automation a valuable combination for any data engineer. This course, led by Andreas Kretz, builds that combination through one hands-on project.
The Project
Across 39 lessons you build a full ETL pipeline: pulling data from an external API, processing it with Azure Data Factory and Synapse Analytics, and preparing it for visualization in Power BI. Along the way you implement a Lakehouse setup using the Bronze, Silver, and Gold layers of the Medallion architecture.
Infrastructure as Code
- Installing and configuring Terraform for Azure, including setting up a Service Principal for secure automated deployments
- Writing modular, reusable Terraform code to deploy Data Factory, Data Lake Storage, and Synapse Analytics
- Connecting Data Factory to a live external API to load raw data into the Bronze layer
- Applying CI/CD principles with Azure DevOps so deployments stay repeatable and stable
By the end you'll have a working, portfolio-ready pipeline and a solid grasp of managing Azure infrastructure as code.