Development Online Course by Udemy, On Sale Here
Learn Microsoft Business Intelligence SQL SSIS Tools & Package with ETL in Data Warehouse Step by Step via SSDT in MSBI
An excellent training about Database Design & Development
SSIS Real World Scenarios & Projects: Tricks of the Trade
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 SSISbusiness 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
Udemy is the leading global marketplace for learning and instruction
By connecting students all over the world to the best instructors, Udemy is helping individuals reach their goals and pursue their dreams.
Study anytime, anywhere.
Reviews
There are no reviews yet.