|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/ssis-training/
课程评论：没有评论
课程名称：SSIS现实场景和项目：行业技巧 概述：本课程是针对中级水平的Microsoft SQL Server SSIS培训课程，属于MSBI的一部分。参加者需具备基本工具和包创建知识。该SQL Server集成服务课程使用SSDT，包含三个项目以及基于现实场景的其他技巧，所有项目均是逐步开发。通过一个项目，学员将学习如何使用SSIS进行数据仓库的ETL操作。该在线SSIS商业智能视频教程的内容包括：如何在SSIS包中使用临时表、将数据从OLTP转移到暂存表、将数据从暂存表转移到数据仓库、测试文件的元数据并加载数据、如何执行固定次数的Foreach循环、使用SSIS表达式获取完整文件路径中的文件名、使用SSIS表达式分离文件的名称和日期组件、使用SSIS表达式格式化为YYYYMMDD日期格式、在SSIS中使用Winrar压缩和解压文件、项目的参数设置、测试压缩文件的存在性、将Zip文件从共享文件夹提取到本地处理文件夹、检查每个文件的日期组件与当前日期的匹配、动态决定加载哪个文件到哪个表、ETL操作、带Lookup选项的ETL、共享文件夹的传输和命名约定、调试和排除SSIS包的故障、使用断点、监视窗口和数据查看器、使用数据流路径故障排除问题记录、使用优先约束进行故障排除、将包部署到集成服务目录、设置测试和生产环境、自动执行包并检查执行报告。 该课程适合希望在数据集成和ETL操作方面提升技能的中级学习者。
This Microsoft SQL Server SSIS is an intermediate level training course and it is the part of MSBI. You have to have the knowledge of basic tools and package creation. This SQL Server Integration Services course using SSDT contains three projects along with other tricks based on real world scenarios. All the projects are developed step by step. In one project you can learn how to perform ETL operation for the data warehouse using SSIS as well. The contents of this online SSIS business intelligence video tutorial on Udemy as follows.How to use Temporary Table in SSIS PackageTransferring Data from OLTP to Staging TableTransferring data from Staging to DatawarehouseTesting Metadata of the files and Loading the dataHow to execute Foreach Loop Fixed Number of TimesSSIS Expression to get the File Name from the complete File PathSSIS Expression to separate Name and Date Component of a fileYYYYMMDD date format using SSIS expressionCompress and Uncompress Folder using Winrar in SSISParameter Settings of the ProjectTesting the existence of Compressed FileExtracting ZIp File From Shared Folder to Local Processed FolderTesting Date Component of each file with the Current DateDynamically Deciding which file to load in which tableETL OperationsETL with Lookup OptionShared Folder Transfer and Naming ConventionsDebugging and Troubleshooting SSIS PackagesBreakpoints , Watch Windows and Data ViewerTroubleshooting Problematic Records Using Data Flow PathsTroubleshooting with Precedence ConstraintsDeploying the Packages to Integration Services CatalogSetting up Test and Production EnvironmentAutomating the Package Execution and Checking the Reports of Execution
