|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/mastering-oracle-data-integrator-odi/
课程评论：没有评论
**课程名称：** Master Oracle Data Integrator (ODI) - 全面的 ETL 和数据集成 **课程概述：** 本课程旨在帮助学员掌握 Oracle Data Integrator (ODI) 的强大功能，成为数据集成和 ETL 领域的专家。学员将学会如何高效地创建和管理 ETL 映射，定义模式，使用上下文，并将元数据逆向工程导入 ODI 模型。课程包含详细的实践演示，涵盖了变量的使用、包的创建以及利用知识模块 (KM) 进行优化的数据处理。 课程内容深入探讨了与 MySQL、Microsoft SQL Server 和 Oracle Database 等特定数据库的交互，以及文件数据的无缝集成。学员将掌握工作流的创建，包括包和加载计划，以实现流畅的 ETL 流程。此外，课程还将全面解析数据仓库的关键概念——慢变维度 (SCD)。 本课程的一大亮点是实时 ETL，重点讲解变更数据捕获 (CDC) 和 Oracle GoldenGate 的应用。学员将获得 CDC 配置和利用 Oracle GoldenGate 进行实时数据复制的实践经验。 通过本课程的学习，学员将能够熟练掌握端到端的 ETL 流程编排，在各种数据库环境中都能胜任数据集成任务，从而成为数据管理和分析领域宝贵的专业人才。完成课程后，学员将具备实施高效、实时数据集成解决方案的能力。
The "Mastering Oracle Data Integrator (ODI) - Comprehensive ETL and Data Integration" course is designed for individuals aspiring to excel in data integration and ETL processes. Throughout the course, participants will explore ODI's robust features, enabling them to create and manage ETL mappings efficiently. They will learn to define schemas, work with contexts, and reverse-engineer metadata into ODI models. Practical demonstrations will cover variable usage, package creation, and working with Knowledge Modules (KMs) for optimized data processing.The course includes a detailed exploration of working with specific databases such as MySQL, Microsoft SQL Server and Oracle Database, along with integrating file data seamlessly. Participants will master the intricacies of creating workflows, including packages and load plans, ensuring streamlined ETL processes. Furthermore, the course provides a comprehensive understanding of Slowly Changing Dimensions (SCD), a crucial aspect of data warehousing.A key focus is on real-time ETL using Change Data Capture (CDC) and Oracle GoldenGate. Participants will gain hands-on experience with CDC configurations and leveraging Oracle GoldenGate for real-time data replication. This comprehensive curriculum ensures that learners develop a proficiency in orchestrating end-to-end ETL processes, making them adept in data integration tasks across diverse database environments. Upon completion, participants will possess the skills to implement efficient and real-time data integration solutions, positioning them as valuable professionals in the realm of data management and analytics.
