|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/project-on-data-warehouse-etl-testing/
课程评论：没有评论
课程名称：数据仓库/ETL测试项目 课程概述：本课程将带您深入了解数据仓库及ETL测试的真实项目场景。作为数据仓库/ETL测试课程的一部分，您将接触到实际的行业案例，从而全面理解数据仓库和ETL测试的概念。本课程将帮助您成为一名成功的ETL测试专家。课程内容涵盖了SQL Server和MySQL的ETL测试，让您了解这两种关系型数据库管理系统的工作原理及其区别。 课程特点： - 2小时以上的随需视频 - 理论与实践的完美结合 - 完成证书 - 面试问题集以助您备考 课程内容包括： **SQL Server部分**： - 项目简介及前置条件 - SQL Server基本概念 - 分支表准备（源与目标） - 分支表测试方法 - 各种数据验证（元数据检查、空值重复值检查、转换验证等） - 具体表的逐步实践操作（如客户表、账户表、支付表等） **MySQL部分**： - 项目简介及前置条件 - 分支表准备（源与目标） - 分支表测试方法 - 各种数据验证（元数据检查、空值重复值检查、转换验证等） - 具体表的逐步实践操作（如客户表、账户表、支付表等） 该课程将提供您所需的工具和知识，助力您在数据仓库和ETL测试领域获得成功。
In this course you will learn about the Real - Time Project scenario on Data Warehouse/ETL Testing. As a part of Data Warehouse/ETL Testing Course, you will be exposed to real-life industry scenarios which give you in-depth understanding of Data warehousing/ETL Testing and its concepts. Project on Data Warehouse/ETL testing course will help you to become a successful ETL Testing expert.This course includes the ETL Testing in both SQL Server and MySQL so that you can understand how both RDBMS works and its differencesThis course includes:☞ 2+hours of on demand videos☞ Right blend of concepts and hands-on☞ Certificate of completion☞ Interview Questions to peek upProject on SQL ServerIntroduction to ProjectPre Requisties of ProjectWhat is SQL Server?SQLServer Branch Table Preparation Source and TargetSSQLServer Branch Table with User InterfaceSQL Server Loading all the Tables PreparationSQL Server Branch Table Testing ApproachSQL Server Meta Data Check Branch TableSql server Branch Table Count Null Duplicate Hands-OnSQL Server Branch Table Transformation Validation Hands-onSQL Server Hands-on Branch Table Columns with Asis MappingSQL Server Customer Table Metadata Check Hands-OnSQL Server Customer table Count NUll and Duplicate Check Hands-OnSQL Server Customer Table Transformation1 Hands-OnSQL Server Customer Table Transformation2 Hands-OnSQL Server Transformation Validation for Customer tableSQL Server Customer Table Validation for columns without transformationSQL Server Accounts Table Meta Data CheckSQL Server Count Null Duplicate Check Hands-OnSQL Server Accounts Table Transformation1SQL Server Accounts Table Transformation2SQL Server Accounts Table Transformation3SQL Server Accounts Validation for the Non transformed columnsSQL Server Payments Table Transfromation Validation for both the columnsSQL Server Payments table validation for non transformed columnsProject on MySQLIntroduction to ProjectPre Requisties of ProjectBranch Table Preparation Source and TargetsHands-On PreparationsBranch Table Testing ApproachBranch Table Meta Data Check Hands-OnBranch Table Count Null Duplicate Hands-OnBranch Table Transformation Validation Hands-OnBranch Table Validating columns without Transformation Hands-OnCustomer Table MetaData count duplicate Hands-OnCustomer table Handson Count NUll and Duplicate CheckCustomer table Transformation validation Hands-On1CustomerTable Transformation Hands-On FinalTransformation Validation for Customer table Trans3Accounts Table MetaData Check Hands-On1Accounts Table Count Null Duplicate Check Hands-On2Accounts Table Transformation Validation Hands-On3Accounts Table Transformation Validation Left pad Hands-on4Payments Table Hands-On ValidationPayment table count Null duplicate check Hands-OnPayments Table Transformation validation Hands-On Final
