Brief Summary
This course is all about making data migration a breeze with SSIS packages! You’ll start from the basics and end up with skills that employers love.
Key Points
-
You'll learn to create SSIS packages for data migration.
-
Hands-on experience with data extraction, transformation, and loading.
-
Pre-requisites include SQL Administration and T-SQL courses.
Learning Outcomes
-
Design and configure SSIS packages effectively.
-
Manage and deploy packages across different platforms.
-
Understand key data transformation tasks including conversion and migration.
About This Course
Learn how to create SSIS packages that allow migration of data from source to destination
This course is designed for those who want to learn how to create SQL SSIS packages that migrate data from various heterogeneous sources to a central point and shows the student how to extract, transform and load data to various destinations. The pre requisite courses SQL Administration Part 1, 2, 3, Learn T-SQL and SSRS are highly recommended. Those that are not familiar with SQL Server Administration should not take this course. The course covers data transformation tasks such as, data conversion, term extraction, migration to flat files, various databases sources and destinations, FTP site tasks, and foreach look container that allows the SSIS package to dump multiple files from source to destination. Those that finish this course will have the necessary skills that recruiters are looking for to fill SQL Server Administration jobs.
At the end of this course, the student will be able to design, configure, manage and deploy SSIS packages that migrate data from source to destination using many platforms
Mallika V.
very nice