|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/talend-etl-data-warehousing-sql-beginner-to-experts/
课程评论：没有评论
本课程“Talend ETL 数据仓库 SQL 入门到精通”旨在全面教授数据仓库和 ETL（提取、转换、加载）领域的知识，并重点关注 SQL 的应用。 课程内容涵盖了数据仓库的核心概念，以及 ETL 的基本原理。通过大量的 Talend 组件介绍和实践，包括但不限于： * **数据处理与转换组件：** 如 `tsortrow` (排序)、`tunite` (合并)、`tuniqerow` (去重)、`tbuffer` (缓冲区)、`thash` (哈希)、`tfiltercolumns` (过滤列)、`tfilterrows` (过滤行)、`treplace` (替换)、`tconverttype` (类型转换)、`tmap` (映射)、`taggrigator` (聚合)、`tjoin` (连接)、`tnormalize` (规范化)、`tdenormalize` (反规范化) 等。 * **文件处理组件：** 包括各种文件输入/输出组件（`tFileInput*`, `tFileOutput*`）、文件操作（`tfilecopy`, `tfiledelete`, `tfileexist` 等）以及 FTP 组件。 * **数据库交互组件：** 详细讲解了与 Oracle、SQL Server (MSSQL)、Db2 等主流数据库的连接、输入、输出、批量处理、事务控制（commit, rollback）等组件。 * **流程控制与日志记录：** 覆盖了任务调度 (`trunjob`、`prejob`、`postjob`)、条件执行 (`runif`)、流程迭代 (`iterate` to `flow`, `flow` to `iterate`)、错误处理 (`OnSubjobError`、`OnComponentError`)、日志记录 (`tlogrow`、`tlogcatcher`) 等关键功能。 * **Java 集成：** 介绍了如何利用 `tJava`、`tJavaRow`、`tJavaFlex` 组件与 Java 代码进行集成，增强 ETL 的灵活性。 * **数据仓库加载模式：** 深入讲解了 SCD (Slowly Changing Dimensions) 的不同类型 (SCD1, SCD2, SCD3)，以及阶段加载 (Stage Loading)、维度加载 (Dimension Loading)、事实加载 (Fact Loading) 的实现过程。 * **项目实战：** 通过完整的项目讲解，带领学员理解实际的数据仓库项目流程和实现细节。 本课程的目标是让学员能够熟练掌握 Talend ETL 工具，理解数据仓库的设计和实现，并能运用 SQL 进行高效的数据操作和分析，从初学者成长为该领域的专家。
Talend ETL Data warehousing SQL Beginner to Experts Topics Datawarehousing Concepts ETL Concepts tsortrow,tunite,tuniqerow,tbufferinput,tbuffer,output,thashinput,thashoutput,tfilelist,tsleep,tloop,file,input,output,components,database,input,output,components,tsendmail,treplicate,tfiltercolumns,tfilterrows,treplace,tconverttype,tdie,tcontextload,trowgenerator,trunjob,prejob,postjob,tsamplerows,tnormalize,tdenormalize,tmap,taggrigator,tjoin,tsystem,tjava,tjavarow,tjavaflex,tschemacompliancecheck,tlogrow,tlogcatcher,t,statcatcher,tfilecopy,tfilearchive,tfileProperties,tfileunarchive,tfiletouch,tfiledelete,tfileexist,tftpfilelist,tftpput,tftpget,tftpdelete,tftpfileexist,tftpConnection,tftpRename,tftpfileproperties,toracleInput,toraclerow,toracleoutpt,toracleconnection,toracleoutputBulkexec,toracleBulkexec,toracleClose,toracleRollback,toraclecommit,tmssqlInput,tmssqlrow,tmssqloutpt,tmssqlconnection,tmssqlBulk,tmssqlBulkexec,tmssqlClose,tmssqlRollback,tmssqlcommit,tDb2Input,tDb2row,tDb2outpt,tDb2connection,tDb2Bulk,tDb2Bulkexec,tDb2Close,tDb2Rollback,tDb2commit,OnsubJobOK,OnSubjobError,OnComponentOk,OnComponentError,runif,tExcelInput,tExceloutput,tfileInputjson,tfileoutputjson,tfileInputXml,tfileoutputXml,tfileinputPositional,tfileOutputPositional,SCD1,SCD2,SCD3,stage loading Dimension Loading fact Loading project Explanation ,flow to iterate ,iterate to flow,tsortrow,tunite,tuniqerow,tbufferinput,tbuffer,output,thashinput,thashoutput,tfilelist,tsleep,tloop,file,input,output,components,database,input,output,components,tsendmail,treplicate,tfiltercolumns,tfilterrows,treplace,tconverttype,tdie,tcontextload,trowgenerator,trunjob,prejob,postjob,tsamplerows,tnormalize,tdenormalize,tmap,taggrigator,tjoin,tsystem,tjava,tjavarow,tjavaflex,tschemacompliancecheck,tlogrow,tlogcatcher,t,statcatcher,tfilecopy,tfilearchive,tfileProperties,tfileunarchive,tfiletouch,tfiledelete,tfileexist,tftpfilelist,tftpput,tftpget,tftpdelete,tftpfileexist,tftpConnection,tftpRename,tftpfileproperties,toracleInput,toraclerow,toracleoutpt,toracleconnection,toracleoutputBulkexec,toracleBulkexec,toracleClose,toracleRollback,toraclecommit,tmssqlInput,tmssqlrow,tmssqloutpt,tmssqlconnection,tmssqlBulk,tmssqlBulkexec,tmssqlClose,tmssqlRollback,tmssqlcommit,tDb2Input,tDb2row,tDb2outpt,tDb2connection,tDb2Bulk,tDb2Bulkexec,tDb2Close,tDb2Rollback,tDb2commit,OnsubJobOK,OnSubjobError,OnComponentOk,OnComponentError,runif,tExcelInput,tExceloutput,tfileInputjson,tfileoutputjson,tfileInputXml,tfileoutputXml,tfileinputPositional,tfileOutputPositional,SCD1,SCD2,SCD3,stage loading Dimension Loading fact Loading project Explanation ,flow to iterate ,iterate to flow,tsortrow,tunite,tuniqerow,tbufferinput,tbuffer,output,thashinput,thashoutput,tfilelist,tsleep,tloop,file,input,output,components,database,input,output,components,tsendmail,treplicate,tfiltercolumns,tfilterrows,treplace,tconverttype,tdie,tcontextload,trowgenerator,trunjob,prejob,postjob,tsamplerows,tnormalize,tdenormalize,tmap,taggrigator,tjoin,tsystem,tjava,tjavarow,tjavaflex,tschemacompliancecheck,tlogrow,tlogcatcher,t,statcatcher,tfilecopy,tfilearchive,tfileProperties,tfileunarchive,tfiletouch,tfiledelete,tfileexist,tftpfilelist,tftpput,tftpget,tftpdelete,tftpfileexist,tftpConnection,tftpRename,tftpfileproperties,toracleInput,toraclerow,toracleoutpt,toracleconnection,toracleoutputBulkexec,toracleBulkexec,toracleClose,toracleRollback,toraclecommit,tmssqlInput,tmssqlrow,tmssqloutpt,tmssqlconnection,tmssqlBulk,tmssqlBulkexec,tmssqlClose,tmssqlRollback,tmssqlcommit,tDb2Input,tDb2row,tDb2outpt,tDb2connection,tDb2Bulk,tDb2Bulkexec,tDb2Close,tDb2Rollback,tDb2commit,OnsubJobOK,OnSubjobError,OnComponentOk,OnComponentError,runif,tExcelInput,tExceloutput,tfileInputjson,tfileoutputjson,tfileInputXml,tfileoutputXml,tfileinputPositional,tfileOutputPositional,SCD1,SCD2,SCD3,stage loading Dimension Loading fact Loading project Explanation ,flow to iterate ,iterate to flow
