|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/introduction-to-data-warehousing-and-azure-synapse/
课程评论：没有评论
**课程名称：** 数据仓库与 Azure Synapse Analytics 入门 **课程概要：** 本课程将带您深入了解数据仓库的概念、发展历程及其在现代技术中的演变。您将学习传统数据仓库的局限性，以及现代技术如何推动数据仓库的现代化。课程还将涵盖数据仓库的关键术语和概念，例如 OLTP、OLAP、ETL、ELT、Micro-Batch、Change Data Capture (CDC)、Star Schema 和 Snowflake Schema。 重点介绍 Azure Synapse Analytics，包括其核心功能、优势以及整体架构。通过实操演示，您将熟悉 Synapse Studio 中的各个功能区域，如活动中心 (Activity Hubs)、概览中心 (Overview Hub)、数据中心 (Data Hub)、开发中心 (Develop Hub)、编排中心 (Orchestrate Hub) 和管理中心 (Manage Hub)，并了解它们的具体用途。 此外，课程还将深入探讨 Azure Synapse SQL 的架构，解释 SQL 存储池 (SQL Pool) 和数据仓库单位 (Data Warehouse Units) 的概念，并介绍 HTAP (Hybrid transactional/analytical processing) 和 Azure Synapse Link。 **本课程适合：** * 希望了解数据仓库基础知识的学习者 * 对 Azure Synapse Analytics 感兴趣的 IT 专业人士 * 需要处理和分析大量数据的开发人员和数据工程师
In this course, you will learnWhat is data warehousing?A basic introduction to data warehousingHistory and evolution of data warehousingHistory of data warehousing from the 1970s to dateLimitation of traditional data warehouseWhat is the limitation of the traditional data warehouse?Modernization of data warehouseHow modern technological advances helped to define the modern data warehousesTerminologies and Concepts - Part IWhat is OLTP and OLAP?What is ETL and ELT?What is Micro-Batch and Change Data Capture (CDC)?What is Star and Snowflakes Schema?Introduction to Azure SynapseIntroduction to Azure SynapseKey features and benefits of Azure SynapseAzure Synapse Analytics (Putting in altogether)Structure of Azure Synapse DemoA demo of Azure SynapseUse cases of Azure SynapseIntroduction to Synapse Analytics StudioWhat are the activity hubs of Synapse Studio?Introduction to Overview HubDemo of Overview HubIntroduction to Data HubDemo of Data HubIntroduction to Develop HubDemo of Develop HubIntroduction to Orchestrate HubDemo of Orchestrate HubIntroduction to Manage HubDemo of Manage HubIntroduction to Monitoring HubDemo of Monitoring HubAzure Synapse - SQL AnalyticsIntroduction to Azure Synapse SQL ArchitectureAzure Synapse SQL Architecture (SQL Pool) and Data Warehouse UnitsWhat is HTAP (Hybrid transactional/analytical processing)?Azure Synapse Link
