ETL with Azure Cookbook: Practical recipes for building modern ETL solutions to load and transform data from any source
暫譯: Azure ETL 食譜：構建現代 ETL 解決方案以從任何來源加載和轉換數據的實用食譜

Coté, Christian, Saitakhmetova, Madina, Lah, Matija

ETL with Azure Cookbook: Practical recipes for building modern ETL solutions to load and transform data from any source
  • 出版商: Packt Publishing
  • 出版日期: 2020-09-30
  • 售價: $2,010
  • 貴賓價: 9.5 折 $1,910
  • 語言: 英文
  • 頁數: 446
  • 裝訂: Quality Paper - also called trade paper
  • ISBN: 1800203314
  • ISBN-13: 9781800203310
  • 相關分類: Microsoft Azure

    • 海外代購書籍(需單獨結帳)

買這商品的人也買了...

商品描述

ETL is one of the most common and tedious procedures for moving and processing data from one database to another. With the help of this book, you will be able to speed up the process by designing effective ETL solutions using the Azure services available for handling and transforming any data to suit your requirements.

 

With this cookbook, you'll become well versed in all the features of SQL Server Integration Services (SSIS) to perform data migration and ETL tasks that integrate with Azure. You'll learn how to transform data in Azure and understand how legacy systems perform ETL on-premises using SSIS. Later chapters will get you up to speed with connecting and retrieving data from SQL Server 2019 Big Data Clusters, and even show you how to extend and customize the SSIS toolbox using custom-developed tasks and transforms. This ETL book also contains practical recipes for moving and transforming data with Azure services, such as Data Factory and Azure Databricks, and lets you explore various options for migrating SSIS packages to Azure. Toward the end, you'll find out how to profile data in the cloud and automate service creation with Business Intelligence Markup Language (BIML).

 

By the end of this book, you'll have developed the skills you need to create and automate ETL solutions on-premises as well as in Azure.

商品描述(中文翻譯)

ETL 是將資料從一個資料庫移動和處理到另一個資料庫的最常見且繁瑣的程序之一。藉助本書，您將能夠通過設計有效的 ETL 解決方案來加速這一過程，使用 Azure 提供的服務來處理和轉換任何資料以符合您的需求。

藉由這本食譜書，您將熟悉 SQL Server Integration Services (SSIS) 的所有功能，以執行與 Azure 整合的資料遷移和 ETL 任務。您將學會如何在 Azure 中轉換資料，並了解舊系統如何使用 SSIS 在本地執行 ETL。後面的章節將幫助您快速掌握如何連接和檢索 SQL Server 2019 Big Data Clusters 中的資料，甚至展示如何使用自定義開發的任務和轉換來擴展和自定義 SSIS 工具箱。本 ETL 書籍還包含使用 Azure 服務（如 Data Factory 和 Azure Databricks）移動和轉換資料的實用食譜，並讓您探索將 SSIS 套件遷移到 Azure 的各種選項。在書的最後，您將了解如何在雲端中分析資料並使用 Business Intelligence Markup Language (BIML) 自動化服務創建。

到本書結束時，您將具備在本地和 Azure 上創建和自動化 ETL 解決方案所需的技能。

作者簡介

Christian Cote is an IT professional with more than 15 years of experience working on data warehouse, big data, and business intelligence projects. Christian has developed expertise in data warehousing and data lakes over the years and has designed many ETL/BI processes using a range of tools on multiple platforms. He's presented at several conferences and code camps. He currently co-leads the SQL Server PASS chapter. He is also a Microsoft Data Platform Most Valuable Professional (MVP).

Matija Lah has more than 18 years of experience working with Microsoft SQL Server, mostly from architecting data-centric solutions in the legal domain. His contributions to the SQL Server community have led to him being awarded the Microsoft MVP award (Data Platform) between 2007 and 2017/2018. He spends most of his time on projects involving advanced information management and natural language processing, but often finds time to speak at events related to Microsoft SQL Server where he loves to share his experience with the SQL Server platform.

Madina Saitakhmetova is a developer specializing in BI. She has been in IT for 15 years, working with Microsoft SQL, .NET, Microsoft BI, Azure, and building BI solutions for medical, educational, and engineering companies. Her adventure with Microsoft BI began with Analysis Services and SSIS, and in later years she has been building her expertise in ETL/ELT, both on-premises and in the cloud. Finding patterns, automating processes, and making BI teams work more efficiently are challenges that drive her. During the past few years, BIML has become an important part of her work, increasing its efficiency and quality.

作者簡介(中文翻譯)

Christian Cote 是一位擁有超過 15 年經驗的 IT 專業人士，專注於數據倉儲、大數據和商業智慧專案。Christian 在數據倉儲和數據湖方面積累了專業知識，並使用多種工具在多個平台上設計了許多 ETL/BI 流程。他曾在多個會議和程式碼營中發表演講。目前，他共同領導 SQL Server PASS 分會。他也是微軟數據平台的最有價值專家 (MVP)。

Matija Lah 擁有超過 18 年的 Microsoft SQL Server 經驗，主要專注於法律領域的數據中心解決方案架構。他對 SQL Server 社群的貢獻使他在 2007 年至 2017/2018 年間獲得微軟 MVP 獎 (數據平台)。他大部分時間都在涉及先進信息管理和自然語言處理的專案上，但他經常抽出時間在與 Microsoft SQL Server 相關的活動中發言，並樂於分享他在 SQL Server 平台上的經驗。

Madina Saitakhmetova 是一位專注於商業智慧 (BI) 的開發人員。她在 IT 領域工作了 15 年，與 Microsoft SQL、.NET、Microsoft BI、Azure 合作，為醫療、教育和工程公司構建 BI 解決方案。她與 Microsoft BI 的冒險始於 Analysis Services 和 SSIS，並在後來的幾年中，她在 ETL/ELT 方面積累了專業知識，無論是在本地還是雲端。尋找模式、自動化流程以及提高 BI 團隊的工作效率是驅動她的挑戰。在過去幾年中，BIML 成為她工作的重要組成部分，提高了效率和質量。

目錄大綱

Table of Contents

  1. Getting Started with Azure and SSIS 2019
  2. Introducing ETL
  3. Creating and Using SQL Server 2019 Big Data Clusters
  4. Azure Data Integration
  5. Extending SSIS with Custom Tasks and Transformations
  6. Azure Data Factory
  7. Azure Databricks
  8. SSIS cloud Migration Strategies
  9. Profiling data in Azure
  10. Manage SSIS and Azure Data Factory with BIML

目錄大綱(中文翻譯)

Table of Contents


  1. Getting Started with Azure and SSIS 2019

  2. Introducing ETL

  3. Creating and Using SQL Server 2019 Big Data Clusters

  4. Azure Data Integration

  5. Extending SSIS with Custom Tasks and Transformations

  6. Azure Data Factory

  7. Azure Databricks

  8. SSIS cloud Migration Strategies

  9. Profiling data in Azure

  10. Manage SSIS and Azure Data Factory with BIML

類似商品