|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/ssis-real-time-scenarios-implementation/
课程评论：没有评论
课程名称：Microsoft SSIS 实时场景（包设计） 课程概述：欢迎参加 Microsoft SSIS（SQL Server 集成服务）实时场景实施课程。在本课程中，您将学习 SSIS 的重要概念和功能、实际应用案例，以及如何应对和处理实时或现实业务需求，并在 SSIS 中实施这些实时场景。本课程适合各水平的 SSIS、ETL、SQL、数据分析师或数据工程师，特别是那些正在使用或将使用 Microsoft SSIS 进行数据集成/迁移或数据仓库项目及 ETL 项目的人员。 在课程中，您将学习重要任务/转换的概念、技巧与窍门，以及如何智能地使用它们并处理和实施实时 SSIS 场景。该课程经过开发者的强烈需求而设计，内容独特，首次向广泛受众发布。如果市面上有类似课程，其费用将是本课程的 3 到 4 倍。课程主讲人曾为 50 多名开发者提供过面对面的培训。 课程将涵盖约 40 个场景及其实现，通过简短而清晰的视频内容有效传达知识，避免无聊。本课程不针对任何相关的 Microsoft 考试，重点在于学习和在实际项目中的实施，以帮助您在当前组织中保持职位和生存。 课程按模块划分，涵盖 35 个以上的实时场景、技巧与窍门。课程的模块包括但不限于： - 模块 1：使用衍生列转换 - 模块 2：执行 SQL 存储过程 - 模块 3：使用表达式实现 SSIS 灵活性 - 模块 4：智能使用导入列与导出列转换 - 模块 5：使用脚本（C# 或 VB Dot Net）扩展 SSIS 功能 - 模块 6：使用 SSIS FOREACH 和 FOR LOOP 容器 - 模块 7：将分隔的平面文件（csv、tsv、psv）和 SSIS 原始文件加载到 SQL 数据库表中 - 模块 8：加载数据、增量加载和 SCD-2 - 模块 9：使用检查点实现包的重启功能 + 使用执行过程任务 完成该课程后，您将感到充满活力，并有信心在 SSIS 中实施任何实时场景。
Welcome to this course Microsoft SSIS (SQL Server Integration Services) real-time scenarios implementation.SCENARIOS WITH IMPLEMENTATION & DEMONSTRATIONIn this course you will learn about the important concepts, features of SSIS; their use cases and how to tackle & handle the real-time or real-world business requirements and how we can implement these real-time scenarios in SSIS.This course is for SSIS or ETL or SQL or Data Analyst or Data Engineers at any level (Beginner, Intermediate, Experienced) who uses or going to use the Microsoft SSIS (Microsoft SQL Server Integration Services) to work upon Data Integration/Migration or Data Warehousing projects and ETL (Extract-Transform-Load) projects.You will learn concepts, tricks, tips about the useful and important tasks/transformations and the methods of using them intelligently and how to handle and implement real-time SSIS scenarios.This course is designed after a great demand from the developers through various sources such as LinkedIn, blogs etc..This course is the unique in terms of content to cover real-time scenarios in SSIS and the only course available and published first time to the great audience and learners, if that kind of course is available in the market then it would cost 3 or 4 times of the cost of this course. Behind the scene this course is taught to 50+ developers via in-person training by the instructor.In this course we will cover around 40 scenarios and their implementations silently to the point in short videos without boring you.This is not intended for any related Microsoft Exams, it is about learning and implementing in actual projects on job to retain your position in your current organization and survive as a SSIS/ETL Developer.This course is divided into various modules and covers 35+ real-time scenarios, tips & tricks. The scenarios in this course are based on the following high level topics/features/concepts,Modules [For details of scenarios in each topic see the course content]• Module 1: Using Derived Column transformation• Module 2: Executing SQL Stored Procedures• Module 3: Implementing SSIS flexibility using Expressions• Module 4: Using Import Column & Export Column transformations intelligently• Module 5: Extending SSIS functionalities using Scripts (C# or VB dot Net)• Module 6: Using SSIS FOREACH & FOR LOOP Containers• Module 7: Loading delimited flat files (csv, tsv, psv) & SSIS Raw file into SQL database tables• Module 8: Loading data, Incremental Load & SCD-2• Module 9: Implementing Package restart ability using Check points + Using Execute Process TaskAfter finishing this course you will experience something energetic vibes and feel confident that you can implement any real-time scenario in SSIS,
