|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/ibm-datastage-for-administrators-and-developers/
课程评论：没有评论
课程名称：IBM Datastage 管理员和开发人员课程 概述： 本课程于2023年3月上传了新的视频录制，具有更好的音视频清晰度，并提供英文、西班牙文、德文、法文和俄文的字幕。由于使用的软件失效，录制中所用的虚拟机为过期版本。本课程专注于ETL/ELT（数据提取、转换和加载），IBM Datastage 是一种在多个行业中广泛需求的ETL工具，常用于满足商业需求。课程中详细讲解了架构、安装、拓扑结构，并通过65个作业设计示例，帮助学习Datastage设计师和指挥官的使用。此外，课程还包含丰富的作业和场景练习，配有免费数据供实践使用。 IBM Datastage是IBM InfoSphere信息服务器套件中的一款软件，广泛应用于包括银行、医疗、生命科学、航空航天项目等多个主要行业，用于数据转换和清洗。由于其友好的用户界面和设计的简易性，使得没有太多背景知识的用户也能轻松实现各种需求。每个示例都是自成一体的，且附有对应的dsx代码，简单易理解但不失深度。 课程内容包括： - 大思路：在学习如何使用Datastage之前，理解使用ETL的必要性。 - 小细节：课程将讨论分区和管道处理、作业类型（服务器作业、并行作业及序列作业）及其区别、部署拓扑（如双层、三层、集群及网格），这些概念对于实现需求至关重要。 - 实时需求实施和澄清：课程设置了65个场景，帮助学员理解设计师阶段的基本概念及项目从Web控制台的设置。 学员将获得： - 基本概念和架构的详细讲解，以及设计作业的步骤，以确保最小化错误和警告； - 使用不同阶段实施商业需求的能力，选择合适的阶段创建最佳作业； - 了解每个阶段的可用特性，确保有效利用资源、实现准确的最大输出。 课程适合已有基本数据库概念（如连接、慢变维等）知识的学员，且Datastage的虚拟机已预先安装，使用简单。讨论论坛也为学员提供了互助交流的平台。虽然由于个人能力有限，无法一一解答学员问题，但课程鼓励大家通过论坛互帮互助。 特别感谢我的同事“Sushmita Gaur”在视频制作过程中给予的支持与指导。
New Video recordings with a better Audio and Video Clarity uploaded on March 2023 with Subtitles in English, Spanish, German, French and Russian. The VM used in the recording is backdated because of the expiry of the Software used. ETL/ELT, buzz of Datawarehouse, Initial point and source for Reporting and Analytics, IBM Datastage is always in demand ETL tool used in many sectors to implement Business Requirement.There are detailed explanation on the Architecture, Installation, Topology & 65 examples of Job Design using different stages to learn Datastage Designer and Director. Additionally, the course is filled with assignments & scenarios with free-data for practice.Let's parse that.IBM Datastage is one of the software in IBM Inforsphere Information Server Suite and is used in all major sectors not limited to Banking, HealthCare, LifeScience, Aerospace projects for data transformation and cleaning. Because of its cool User Interface and ease of design, its easy to implement any requirement/scenario with limited background knowledge. These 65 examples will help you trust Datastage. Each is self-contained, has its dsx code attached. Each example is simple, but not simplistic.What's Included:The Big Ideas: Before we get to the how, we better understand the why - this course will help clarify why we even need ETL and Datastage.The Little Details That Matter: Partitioning & Pipelining, Types of Jobs(Server,Parallel & Sequencer Jobs) and their differences, Deployment topologies (like Two tier, three Tier, Cluster & Grid). Concepts like these matter, this course will cover them. Aditionally, the course focus on live requirement implementation & clarifications. Hence, we design 65 scenarios to understand the basic concepts of stages from Designer & Project setup from Web Console and Administrator.Also, you are provided with Datastage 9.1 and Datastage 11.3 Virtual Machine where you can practice and explore the tool.Using discussion forumsPlease use the discussion forums on this course to engage with other students and to help each other out. Unfortunately, much as we would like to, it is not possible for me to respond to individual questions from students:-(I have worked with many consultancies on training Datastage and have literally seen students getting looted by them, in terms of money, time and training content and quality. And hence,I took over my course to Udemy to make it reachable to millions at an affordable price without worrying about the mediators.Also, I have implemented the entire experience of 3 years of training to create a course, which is self understandable and covers all the concepts required to implement any simple to complex scenario on Datastage. And hence, the course comes with *MINIMAL Technical support over email or in-person*. The truth is, direct support is hugely expensive and just does not scale.We understand that this is not ideal and that a lot of students might benefit from this additional support. Hiring resources for additional support would make our offering much more expensive, thus defeating our original purpose of delivering the course at a low cost. But we can definately use the discussion forum to help each other out. I can pitch in at times on certain scenarios if required.It is a hard trade-off.Thank you for your patience and understanding!What are the requirements?Basic knowledge of DB concepts like Joins (Left, Outer, Inner or Full) & Slowly Changing Dimension Concepts esp SCD Type 1 & 2.The course cover the Virtual Machine set up of Datastage - no worries on that front as we have to simply use the Virtual Machine & Datastage is installed already!What am I going to get from this course?The course explains the basic concepts and architecture of Datastage, sets the mandatory steps to follow to design the jobs to ensure minimal errors and warnings, use Datastage to Implement Business requirement using different stages, pick up the correct stage to create a best suitable job.Identify what features are available in the stages that we can choose to implement a certain requirement to ensure limited stage usage and maximum output with accuracy.Lastly, I would like to thank my colleague "Sushmita Gaur" in helping me create this Video. Your input and guidance are very helpful in putting things together.
