國立高雄大學圖資館 |

Language: English

Back

The definitive guide to Azure data e...

L'Esteve, Ron C.

The definitive guide to Azure data engineeringmodern ELT, DevOps, and analytics on the Azure Cloud Platform /

Record Type:	Electronic resources : Monograph/item
Title/Author:	The definitive guide to Azure data engineeringby Ron C. L'Esteve.
Reminder of title:	modern ELT, DevOps, and analytics on the Azure Cloud Platform /
Author:	L'Esteve, Ron C.
Published:	Berkeley, CA :Apress :2021.
Description:	xxiii, 612 p. :ill., digital ;24 cm.
Contained By:	Springer Nature eBook
Subject:	Database management.
Online resource:	https://doi.org/10.1007/978-1-4842-7182-7
ISBN:	9781484271827

The definitive guide to Azure data engineeringmodern ELT, DevOps, and analytics on the Azure Cloud Platform /
L'Esteve, Ron C.

The definitive guide to Azure data engineeringmodern ELT, DevOps, and analytics on the Azure Cloud Platform /[electronic resource] :by Ron C. L'Esteve. - Berkeley, CA :Apress :2021. - xxiii, 612 p. :ill., digital ;24 cm.

Introduction -- Part I. Getting Started -- 1. The Tools and Pre-Requisites -- 2. Data Factory vs SSIS vs Databricks -- 3. Design a Data Lake Storage Gen2 Account -- Part II. Azure Data Factory for ELT -- 4. Dynamically Load SQL Database to Data Lake Storage Gen 2 -- 5. Use COPY INTO to Load Synapse Analytics Dedicated SQL Pool -- 6. Load Data Lake Storage Gen2 Files into Synapse Analytics Dedicated SQL Pool -- 7. Create and Load Synapse Analytics Dedicated SQL Pool Tables Dynamically -- 8. Build Custom Logs in SQL Database for Pipeline Activity Metrics -- 9. Capture Pipeline Error Logs in SQL Database -- 10. Dynamically Load Snowflake Data Warehouse -- 11. Mapping Data Flows for Data Warehouse ETL -- 12. Aggregate and Transform Big Data Using Mapping Data Flows -- 13. Incrementally Upsert Data -- 14. Loading Excel Sheets into Azure SQL Database Tables -- 15. Delta Lake -- Part III. Real-Time Analytics in Azure -- 16. Stream Analytics Anomaly Detection -- 17. Real-time IoT Analytics Using Apache Spark -- 18. Azure Synapse Link for Cosmos DB -- Part IV. DevOps for Continuous Integration and Deployment -- 19. Deploy Data Factory Changes -- 20. Deploy SQL Database -- Part V. Advanced Analytics -- 21. Graph Analytics Using Apache Spark's GraphFrame API -- 22. Synapse Analytics Workspaces -- 23. Machine Learning in Databricks -- Part VI. Data Governance -- 24. Purview for Data Governance.

Build efficient and scalable batch and real-time data ingestion pipelines, DevOps continuous integration and deployment pipelines, and advanced analytics solutions on the Azure Data Platform. This book teaches you to design and implement robust data engineering solutions using Data Factory, Databricks, Synapse Analytics, Snowflake, Azure SQL database, Stream Analytics, Cosmos database, and Data Lake Storage Gen2. You will learn how to engineer your use of these Azure Data Platform components for optimal performance and scalability. You will also learn to design self-service capabilities to maintain and drive the pipelines and your workloads. The approach in this book is to guide you through a hands-on, scenario-based learning process that will empower you to promote digital innovation best practices while you work through your organization's projects, challenges, and needs. The clear examples enable you to use this book as a reference and guide for building data engineering solutions in Azure. After reading this book, you will have a far stronger skill set and confidence level in getting hands on with the Azure Data Platform. You will learn to: Build dynamic, parameterized ELT data ingestion orchestration pipelines in Azure Data Factory Create data ingestion pipelines that integrate control tables for self-service ELT Implement a reusable logging framework that can be applied to multiple pipelines Integrate Azure Data Factory pipelines with a variety of Azure data sources and tools Transform data with Mapping Data Flows in Azure Data Factory Apply Azure DevOps continuous integration and deployment practices to your Azure Data Factory pipelines and development SQL databases Design and implement real-time streaming and advanced analytics solutions using Databricks, Stream Analytics, and Synapse Analytics Get started with a variety of Azure data services through hands-on examples.

ISBN: 9781484271827

Standard No.: 10.1007/978-1-4842-7182-7doiSubjects--Uniform Titles:

Microsoft Azure SQL Database.
Subjects--Topical Terms:

182428
Database management.

LC Class. No.: QA76.9.D3 / L47 2021

Dewey Class. No.: 005.7565

The definitive guide to Azure data engineeringmodern ELT, DevOps, and analytics on the Azure Cloud Platform /
LDR:04378nmm a2200325 a 4500 001 608321
003 DE-He213
005 20210806103820.0
006 m d
007 cr nn 008maaau
008 220119s2021 cau s 0 eng d
020 $a 9781484271827 $q (electronic bk.)
020 $a 9781484271810 $q (paper)
024 7 $a 10.1007/978-1-4842-7182-7 $2 doi
035 $a 978-1-4842-7182-7
040 $a GP $c GP
041 0 $a eng
050 4 $a QA76.9.D3 $b L47 2021
072 7 $a UMP $2 bicssc
072 7 $a COM051380 $2 bisacsh
072 7 $a UMP $2 thema
082 0 4 $a 005.7565 $2 23
090 $a QA76.9.D3 $b L642 2021
100 1 $a L'Esteve, Ron C. $3 905719
245 1 4 $a The definitive guide to Azure data engineering $h [electronic resource] : $b modern ELT, DevOps, and analytics on the Azure Cloud Platform / $c by Ron C. L'Esteve.
260 $a Berkeley, CA : $b Apress : $b Imprint: Apress, $c 2021.
300 $a xxiii, 612 p. : $b ill., digital ; $c 24 cm.
505 0 $a Introduction -- Part I. Getting Started -- 1. The Tools and Pre-Requisites -- 2. Data Factory vs SSIS vs Databricks -- 3. Design a Data Lake Storage Gen2 Account -- Part II. Azure Data Factory for ELT -- 4. Dynamically Load SQL Database to Data Lake Storage Gen 2 -- 5. Use COPY INTO to Load Synapse Analytics Dedicated SQL Pool -- 6. Load Data Lake Storage Gen2 Files into Synapse Analytics Dedicated SQL Pool -- 7. Create and Load Synapse Analytics Dedicated SQL Pool Tables Dynamically -- 8. Build Custom Logs in SQL Database for Pipeline Activity Metrics -- 9. Capture Pipeline Error Logs in SQL Database -- 10. Dynamically Load Snowflake Data Warehouse -- 11. Mapping Data Flows for Data Warehouse ETL -- 12. Aggregate and Transform Big Data Using Mapping Data Flows -- 13. Incrementally Upsert Data -- 14. Loading Excel Sheets into Azure SQL Database Tables -- 15. Delta Lake -- Part III. Real-Time Analytics in Azure -- 16. Stream Analytics Anomaly Detection -- 17. Real-time IoT Analytics Using Apache Spark -- 18. Azure Synapse Link for Cosmos DB -- Part IV. DevOps for Continuous Integration and Deployment -- 19. Deploy Data Factory Changes -- 20. Deploy SQL Database -- Part V. Advanced Analytics -- 21. Graph Analytics Using Apache Spark's GraphFrame API -- 22. Synapse Analytics Workspaces -- 23. Machine Learning in Databricks -- Part VI. Data Governance -- 24. Purview for Data Governance.
520 $a Build efficient and scalable batch and real-time data ingestion pipelines, DevOps continuous integration and deployment pipelines, and advanced analytics solutions on the Azure Data Platform. This book teaches you to design and implement robust data engineering solutions using Data Factory, Databricks, Synapse Analytics, Snowflake, Azure SQL database, Stream Analytics, Cosmos database, and Data Lake Storage Gen2. You will learn how to engineer your use of these Azure Data Platform components for optimal performance and scalability. You will also learn to design self-service capabilities to maintain and drive the pipelines and your workloads. The approach in this book is to guide you through a hands-on, scenario-based learning process that will empower you to promote digital innovation best practices while you work through your organization's projects, challenges, and needs. The clear examples enable you to use this book as a reference and guide for building data engineering solutions in Azure. After reading this book, you will have a far stronger skill set and confidence level in getting hands on with the Azure Data Platform. You will learn to: Build dynamic, parameterized ELT data ingestion orchestration pipelines in Azure Data Factory Create data ingestion pipelines that integrate control tables for self-service ELT Implement a reusable logging framework that can be applied to multiple pipelines Integrate Azure Data Factory pipelines with a variety of Azure data sources and tools Transform data with Mapping Data Flows in Azure Data Factory Apply Azure DevOps continuous integration and deployment practices to your Azure Data Factory pipelines and development SQL databases Design and implement real-time streaming and advanced analytics solutions using Databricks, Stream Analytics, and Synapse Analytics Get started with a variety of Azure data services through hands-on examples.
630 0 0 $a Microsoft Azure SQL Database. $3 727076
650 0 $a Database management. $3 182428
650 0 $a Cloud computing. $3 378527
650 1 4 $a Microsoft and .NET. $3 760507
650 2 4 $a Database Management. $3 273994
650 2 4 $a Big Data. $3 760530
710 2 $a SpringerLink (Online service) $3 273601
773 0 $t Springer Nature eBook
856 4 0 $u https://doi.org/10.1007/978-1-4842-7182-7
950 $a Professional and Applied Computing (SpringerNature-12059)