|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/data-warehouse-etl-testing/
课程评论：没有评论
**课程名称：** 数据仓库/ETL测试 **课程概述：** 本课程深入讲解了数据仓库和ETL（抽取、转换、加载）测试的方法。数据仓库测试旨在验证数据仓库中数据的完整性、可靠性、准确性和一致性，以确保其符合公司的数据框架。其核心目的是保证数据仓库中整合后的数据足够可靠，能够支持公司的决策制定。 课程涵盖了数据仓库测试、ETL测试场景、数据校验等众多复杂议题，并以详实的方式进行讲解，帮助学员提升竞争力。ETL测试主要验证ETL流程是否正常运行，由于ETL通常处理的是关键任务数据，因此ETL测试至关重要。 **课程特色：** * 23小时以上点播视频 * 通过社区获得帮助 * 理论与实践相结合 **学习内容：** * 数据与信息的区别 * 数据的重要性 * SQL语法详解 * 关系型数据库管理系统 (RDBMS) 及其历史 * 数据库对象与数据库设计 * 主键与约束 * 数据规范化及其类型 * 事务及其类型 * SQL数据操作（查询、插入、更新、删除） * 聚合函数在数据分析中的应用 * ETL生命周期 * 测试类型 * ETL概念 * 数据校验 * 验证的概念 * 验证检查 * 校验类型
Data Warehouse / ETL Testing is a testing method in which the data inside a data warehouse is tested for integrity, reliability, accuracy and consistency in order to comply with the company's data framework. The main purpose of testing is to ensure that the integrated data inside the data warehouse is reliable enough for a company to make decisions on.The Data Warehouse/ETL testing course videos contain Data warehouse Testing, ETL Testing Scenarios, Data checks and many more complex topics explained in a detailed manner which will be helpful to compete with other Organizations. Usually ETL Testing verifies whether the ETL process is working properly.ETL Testing is a crucial part of ETL because ETL is typically performed on mission critical data.23+ hours of on demand videosClarifications through communityRight blend of concepts and hands-onIn this course, you will:The difference between Data and InformationWhy do we need Data?Learn the ins and outs of SQL syntaxWhat is RDBMS and its History?Database Objects and Database DesignLearning about the Keys and ConstraintsExplaining the Normalization and its typesUnderstanding the Transactions and its typesHow to write SQL queries to Manipulate dataHow to write SQL queries to insert, update and delete data into databaseAnalyze data using Aggregate FunctionsTestingLife Cycle of STLCTypes of TestingWhat is ETL?Data ChecksWhat is Validation?Validation ChecksTypes of Checks
