Microsoft SQL Server Integration Services (SSIS) features graphical tools and wizards for:
building and debugging packages
tasks for performing workflow functions
executing SQL statements
data sources and destinations for extracting and loading data
transformations for cleaning, aggregating, merging, and copying data
In this computer science course, you'll extract data from a wide variety of data sources, such as files and relational data sources, perform data integration and transformation solutions, and load data into single or multiple destinations. You will solve complex business problems using best practices and troubleshooting techniques.
0 | Module 0 - Start Here
Welcome to DAT217x: Implementing ETL with SQL Server Integration Services (SSIS)
Setting Up Your Lab Environment in Azure
1 | Module 1 - ETL Processing
Data Sources and Destinations
Creating Example Databases
2 | Module 2 - ETL with SQL Programming
Implementing ETL with SQL Objects
Lab | Programming an ETL Process with SQL
3 | Module 3 - ETL Processing with SSIS
Creating SSIS Projects
Programming SSIS Packages
Execute SQL Tasks
Implementing SSIS Packages
Lab | Creating an ETL Process with SSIS
4 | Module 4 - SSIS Data Flows
Creating Data Flows
Data Flow Transformations
Lab | Creating an SSIS ETL Package Using Data Flow Tasks
Start your review of Implementing ETL with SQL Server Integration Services
Anonymous completed this course.
The course is very premature and quite disappointing from an experienced data scientist at Microsoft. The contents are neither introductory nor advances. It is not clear where is the level of this course. It starts with fairly complex ETL design using...
The course is very premature and quite disappointing from an experienced data scientist at Microsoft. The contents are neither introductory nor advances. It is not clear where is the level of this course. It starts with fairly complex ETL design using scripting. The lecturer only shows what he is doing without detail description of how things are made and why they are made this way.
In the second part of the content, it goes to Microsoft SSIS and then it becomes quite introductory course for someone who has absoloutly 0 knowledge and experience on SSIS.
At the end, you think if this was advance, why SSIS part is so basic. If it is basic, why scripting part was so abstract.
The bottom line: This course is nothing muh to teach you. It is somehow good for someone who has been doing the ETL development and SSIS design for sometimes now. It only can teach some of the best practices of scripting SQL ETL. In the second part, there is surely nothing at all to see. By looking at 1-2 youtube video, you can do far more than what this is telling you.
In terms of student engagement, there are 20 videos in line for module 2 and then few very strange lab assignments. I wish I could have the chance to do coding on my own as the course moves on. Also, I wish there was some small test and questsions in the middle of the modules to stimulate my brain and help me to understand if I really understood the gist.
All in all, I can tell you to only view videos on fast forward speed and see some of the contents and watch carefully if you found something worthy for you.