Data Engineering on Microsoft Azure: The Definitive Guide

Hands-On Introduction to Azure Data Services. Learn Data Factory, Synapse Analytics, SQL Database, and more

Created by: Wadson Guimatsa
Data Engineer

What Will I Learn?

• Provision Azure SQL Databases. Use query tools such as Azure Data Studio or SQL Server Management Studio (SSMS) to connect to Azure SQL databases
• Create storage accounts to store unstructured and semi-structured data. use Azure Data Studio to upload data to Azure
• Manage identities, keys, and secrets across different data platform technologies using Azure Key Vault
• Use the Azure CLI to generate Shared Access Signature (SAS). How access storage resources using SAS
• Build ETL pipeline using Azure Data Factory. Create advanced transformation logic using Data Flows
• Trigger a Data Pipeline based on storage events or specific time
• Use T-SQL to query Relational Databases and data in Azure Storage
• Transform data using Azure Synapse Analytics. Create external tables to read or write data to files in Azure Storage
• Build a modern data warehouse using Azure Synapse Analytics
• Analyze data using serverless Apache Spark pool in Synapse Analytics

Requirements

• Microsoft Azure Subscription
• Basic SQL knowledge or programming skills
• No Data Engineering experience is needed. You will learn everything you need to know

Target audience

• Anyone who wants to start using Azure in their career & get paid for their cloud and Data Engineering Skills
• Software developers curious about Data Engineering
• Database Developer or Database Administrators (DBA)