Nearly 80 recipes to help you collect and transform data from multiple sources into a single data source, making it way easier to perform analytics on the data
Key Features
- Build data pipelines from scratch and find solutions to common data engineering problems
- Learn how to work with Azure Data Factory, Data Lake, Databricks, and Synapse Analytics
- Monitor and maintain your data engineering pipelines using Log Analytics, Azure Monitor, and Azure Purview
Book Description
The famous quote 'Data is the new oil' seems more true every day as the key to most organizations' long-term success lies in extracting insights from raw data. One of the major challenges organizations face in leveraging value out of data is building performant data engineering pipelines for data visualization, ingestion, storage, and processing. This second edition of the immensely successful book by Ahmad Osama brings to you several recent enhancements in Azure data engineering and shares approximately 80 useful recipes covering common scenarios in building data engineering pipelines in Microsoft Azure.
You'll explore recipes from Azure Synapse Analytics workspaces Gen 2 and get to grips with Synapse Spark pools, SQL Serverless pools, Synapse integration pipelines, and Synapse data flows. You'll also understand Synapse SQL Pool optimization techniques in this second edition. Besides Synapse enhancements, you'll discover helpful tips on managing Azure SQL Database and learn about security, high availability, and performance monitoring. Finally, the book takes you through overall data engineering pipeline management, focusing on monitoring using Log Analytics and tracking data lineage using Azure Purview.
By the end of this book, you'll be able to build superior data engineering pipelines along with having an invaluable go-to guide.
What you will learn
- Process data using Azure Databricks and Azure Synapse Analytics
- Perform data transformation using Azure Synapse data flows
- Perform common administrative tasks in Azure SQL Database
- Build effective Synapse SQL pools which can be consumed by Power BI
- Monitor Synapse SQL and Spark pools using Log Analytics
- Track data lineage using Microsoft Purview integration with pipelines
Who this book is for
This book is for data engineers, data architects, database administrators, and data professionals who want to get well versed with the Azure data services for building data pipelines. Basic understanding of cloud and data engineering concepts will help in getting the most out of this book.
Table of Contents
- Creating and Managing Data in Azure Data Lake
- Securing and Monitoring Data in Azure Data Lake
- Building Data Ingestion Pipelines Using Azure Data Factory
- Azure Data Factory Integration Runtime
- Configuring and Securing Azure SQL Database
- Implementing High Availability and Monitoring in Azure SQL Database
- Processing Data Using Azure Databricks
- Processing Data Using Azure Synapse Analytics
- Transforming Data Using Azure Synapse Dataflows
- Building the Serving Layer in Azure Synapse SQL Pool
- Monitoring Synapse SQL and Spark Pools
- Optimizing and Maintaining Synapse SQL and Spark Pools
- Monitoring and Maintaining Azure Data Engineering Pipelines
Nagaraj Venkatesan works as a Senior Customer Engineer at Microsoft and is a Data Platform MVP from Singapore and the leader of Singapore SQL Server User Group. As a SQL Server enthusiast, Nagaraj is a regular speaker in various conference. Nagaraj shares his technical expertise by writing on different blog channels. Nagaraj also runs a YouTube channel called "DataChannel", which contains technical interviews with top Microsoft Data Platform experts in the world. Besides these, he also holds a Master's Degree from National University of Singapore.
Ahmad Osama works for Pitney Bowes Pvt. Ltd. as a technical architect and is a former Microsoft Data Platform MVP. In his day job, he works on developing and maintaining high performant, on-premises and cloud SQL Server OLTP environments as well as deployment and automating tasks using PowerShell. When not working, Ahmad blogs at DataPlatformLabs and can be found glued to his Xbox.
