SQL Server Administration: (SQL Server Integration Services)

Name: SQL Server Administration: (SQL Server Integration Services)
Rating: 4.4 (1261 reviews)

Learn how to create SSIS packages that allow migration of data from source to destination

Created byRaphael Asghar

Last updated 8/2018

English

What you'll learn

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

Course content

1 section • 29 lectures • 5h 39m total length

Introduction5:12
Install SQL 2016 if you have not13:49
Rafael guides you through installing SQL Server 2016, setting up reporting services, and installing data tools on a Windows 10 environment, with prerequisites and configuration steps explained.
Down Load and Install SQL 201613:49
Correction1:12
Corrects guidance by advising to download the community free version of Visual Studio instead of the enterprise trial, as it provides the same application and reporting capabilities for the course.
Download and Install Data Tools for SSRS8:28
Download and install Sample database12:19
What is SSIS14:28
SQL to SQL Export Transformation13:34
SQL to Excel Transformation10:52
Control Flow and Data Flow11:34
Create a SSIS Package18:14
Learn to create a ssis package in sql server integration services that migrates data between sql databases using ole db connection managers in visual studio, with annotations and mappings.
Truncate a Table10:09
SQL to Flat File14:15
Learn to export data from SQL to a flat file using an SSIS package, including setting up a mountains table, mapping columns, and configuring a delimited flat file destination.
FTP Site Transformation10:32
Conditional Split Transformation24:53
Truncate tables for conditional split4:54
Derived Column Task Transformation12:11
Character Map Transformation8:26
Use the character map transformation in SSIS to convert a text column to upper or lower case, creating a new column, and verify results with a data viewer.
Merge Transformation13:25
Union All Transformation5:02
Explore union all in SSIS to merge data from more than two sources without sorting. Compare it with merge, learn when to use derived columns and downstream tasks.
Multicast Transformation12:36
Aggregates Transformation15:40
Term Extraction Transformation10:09
Audit Transformation9:29
Data Conversion Transformation14:35
Backup Task Transformation9:07
For Each Container Transformation14:47
For Each Container Task Transformation17:06
create a robust ssis package using a for each loop to read multiple text files and load data into a sql table, with variables and data flow tasks.
For Each Container Job9:01

Requirements

The pre requisite courses SQL Administration Part 1, 2, 3, Learn T-SQL and SSRS are highly recommended. All software and SQL scripts and documents will be provided via email zip file

Description

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.

Who this course is for:

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.