Azure Data Engineering Cookbook
Get well versed in various data engineering techniques in Azure using this recipe-based guide
2nd Edition
Published on 26. September 2022
Book
Paperback/Softback
608 pages
978-1-80324-678-9 (ISBN)
Description
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 DescriptionThe 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 forThis 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.
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 DescriptionThe 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 forThis 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.
More details
Edition
2nd Revised edition
Language
English
Place of publication
Birmingham
United Kingdom
Target group
Professional and scholarly
US School Grade: College Graduate Student
Edition type
Revised edition
Product notice
Paperback (trade)
Unsewn / adhesive bound
Dimensions
Height: 231 mm
Width: 186 mm
Thickness: 34 mm
Weight
1068 gr
ISBN-13
978-1-80324-678-9 (9781803246789)
Copyright in bibliographic data and cover images is held by Nielsen Book Services Limited or by the publishers or by their respective licensors: all rights reserved.
Schweitzer Classification
Other editions
Additional editions
Luca Zanna | Nagaraj Venkatesan | Ahmad Osama
Azure Data Engineering Cookbook
Get well versed in various data engineering techniques in Azure using this recipe-based guide
E-Book
09/2024
2nd Edition
Packt Publishing
from
€37.19
Available for download
Persons
Luca Zanna is a Data Engineer and Data Analyst with over 15 years of experience. He started his career as financial data analyst after a Master in Management and passing the Certified Public Accountant (CPA) exam. Luca spent a decade working on financial analysis systems at L'Oreal: developing the systems and training financial analysts across Europe and Asia.
Currently, Luca helps companies with building data infrastructure to better leverage their data. Luca is also a corporate teacher for topics such as data analysis, SQL, Python, and cloud data engineering. Nagaraj Venkatesan works as a cloud solution architect at Microsoft. At Microsoft, he works with some of the largest companies in the world, solving their complex data engineering problems and helping them build effective solutions using cutting-edge technologies based on Azure. Nagaraj, based out of Singapore, is a popular member of the data and AI community and is a regular speaker at several international data and AI conferences. He is a two-time Microsoft Most Valuable Professional (MVP) award winner, in 2016 and 2017. Nagaraj shares his technical expertise through his blog and on his YouTube channel called DataChannel. He also holds a master's degree in computing from the 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.
Currently, Luca helps companies with building data infrastructure to better leverage their data. Luca is also a corporate teacher for topics such as data analysis, SQL, Python, and cloud data engineering. Nagaraj Venkatesan works as a cloud solution architect at Microsoft. At Microsoft, he works with some of the largest companies in the world, solving their complex data engineering problems and helping them build effective solutions using cutting-edge technologies based on Azure. Nagaraj, based out of Singapore, is a popular member of the data and AI community and is a regular speaker at several international data and AI conferences. He is a two-time Microsoft Most Valuable Professional (MVP) award winner, in 2016 and 2017. Nagaraj shares his technical expertise through his blog and on his YouTube channel called DataChannel. He also holds a master's degree in computing from the 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.
Content
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
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