|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/building-a-better-etl-platform-with-ssis/
课程评论：没有评论
**课程名称：** 使用 SSIS 构建更优 ETL 平台 **课程概述：** 本课程面向希望在不占用过多基础设施资源的情况下迁移大量数据、优化复杂查询以减轻系统负担，或者正在构建商业智能/数据科学分析平台的 SQL 开发人员。 课程将介绍使用 Microsoft SQL Server Integration Services (SSIS) 进行 ETL（提取、转换、加载）的基础知识，涵盖以下主题： * 数据仓库概述 * ETL 架构策略 * 变更跟踪 * SSIS 开发 * SSIS 部署 **讲师背景：** 讲师是一位拥有十五年以上 MS SQL Server 经验的高级 SQL 数据库架构师。随着数据工程、数据科学和商业智能领域机遇的不断增加，SQL 开发人员需要掌握向分析和数据工程领域无缝过渡的技能。 **课程价值：** 构建数据仓库所需的技能与管理普通应用程序后端数据库不同。本课程将提供实际经验，教授如何设置和管理用于支持数据仓库的 ETL 流程。 **适合人群：** 本课程特别适合拥有几年经验的初级 DBA 或中级 SQL 开发人员，旨在帮助他们将 SQL 技能提升至专家级别。
Do you need to migrate a large volume of data without tying up your infrastructure?Do you run complex queries that max out your system resources?Are you building an analytics platform for business intelligence or data science?If the answer to any of these questions is "yes", then Faster SQL Mastery is the course for you!Building a Better ETL with SSIS introduces you to the basics of ETL using Microsoft SQL Server Integration Services, or SSIS. You'll learn the following topics in this course:Data Warehousing OverviewETL Architecture StrategiesChange TrackingSSIS DevelopmentSSIS DeploymentI am a senior SQL database architect with over fifteen years of experience working with MS SQL Server. With the increasing opportunities in data engineering, data science, and business intelligence, SQL developers must be able to transition seamlessly into the world of analytics and data engineering.Building a data warehouse requires a different set of skills than administering an ordinary application back-end database. Here you will get some real-world experience on how to set up and manage an ETL process that feeds a data warehouse to support these applications.If you are an intermediate SQL developer or junior DBA with only a few years of experience, this course is perfect for elevating your SQL skills to expert levels. Enroll today to enhance your SQL expertise!
