In this coursse, you will be downloading and installing the latest 2016 SQL Server Developer which is totally for free which is used in your course.
SSIS is SQL Server Integration Services which is to automate the importing and exporting the data or ETL(Extract, Transform and Load). It is a visual part of SSIS, using tasks, components and flowcharts. Hence it is easy to learn the basics of it.
We will we extracting the data from one table and then load into the another table. We will learning transformation, aggregation, conditional split, merging and auditing.
This course is also designed for one who is preparing for Microsoft certificates 70-463 as well.