4.45 out of 5
4.45
266 reviews on Udemy

SQL Server Administration: (SQL Server Integration Services)

Learn how to create SSIS packages that allow migration of data from source to destination
Instructor:
Raphael Asghar
1,960 students enrolled
English [Auto-generated]
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

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.

SQL Server Integration Services (SSIS)

1
Introduction
2
Install SQL 2016 if you have not
3
Down Load and Install SQL 2016
4
Correction
5
Download and Install Data Tools for SSRS
6
Download and install Sample database
7
What is SSIS
8
SQL to SQL Export Transformation
9
SQL to Excel Transformation
10
Control Flow and Data Flow
11
Create a SSIS Package
12
Truncate a Table
13
SQL to Flat File
14
FTP Site Transformation
15
Conditional Split Transformation
16
Truncate tables for conditional split
17
Derived Column Task Transformation
18
Character Map Transformation
19
Merge Transformation
20
Union All Transformation
21
Multicast Transformation
22
Aggregates Transformation
23
Term Extraction Transformation
24
Audit Transformation
25
Data Conversion Transformation
26
Backup Task Transformation
27
For Each Container Transformation
28
For Each Container Task Transformation
29
For Each Container Job
You can view and review the lecture materials indefinitely, like an on-demand channel.
Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don't have an internet connection, some instructors also let their students download course lectures. That's up to the instructor though, so make sure you get on their good side!
4.5
4.5 out of 5
266 Ratings

Detailed Rating

Stars 5
140
Stars 4
96
Stars 3
26
Stars 2
4
Stars 1
0
a3678bd78f53a9fe138ada94a9f9f6fb
30-Day Money-Back Guarantee

Includes

6 hours on-demand video
Full lifetime access
Access on mobile and TV
Certificate of Completion