SQL Server Administration: (SQL Server Integration Services)
4.5 (125 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
909 students enrolled
Wishlisted Wishlist

Please confirm that you want to add SQL Server Administration: (SQL Server Integration Services) to your Wishlist.

Add to Wishlist

SQL Server Administration: (SQL Server Integration Services)

Learn how to create SSIS packages that allow migration of data from source to destination
Bestselling
4.5 (125 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
909 students enrolled
Created by Raphael Asghar
Last updated 3/2017
English
Current price: $10 Original price: $20 Discount: 50% off
5 hours left at this price!
30-Day Money-Back Guarantee
Includes:
  • 5.5 hours on-demand video
  • 2 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I 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
View Curriculum
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 is the target audience?
  • 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.
Students Who Viewed This Course Also Viewed
Curriculum For This Course
29 Lectures
05:39:48
+
SQL Server Integration Services (SSIS)
29 Lectures 05:39:48


Down Load and Install SQL 2016
13:49

Correction
01:12

Download and Install Data Tools for SSRS
08:28

Download and install Sample database
12:19

What is SSIS
14:28

SQL to SQL Export Transformation
13:34

SQL to Excel Transformation
10:52

Control Flow and Data Flow
11:34

Create a SSIS Package
18:14

Truncate a Table
10:09

SQL to Flat File
14:15

FTP Site Transformation
10:32

Conditional Split Transformation
24:53

Truncate tables for conditional split
04:54

Derived Column Task Transformation
12:11

Character Map Transformation
08:26

Merge Transformation
13:25

Union All Transformation
05:02

Multicast Transformation
12:36

Aggregates Transformation
15:40

Term Extraction Transformation
10:09

Audit Transformation
09:29

Data Conversion Transformation
14:35

Backup Task Transformation
09:07

For Each Container Transformation
14:47

For Each Container Task Transformation
17:06

For Each Container Job
09:01
About the Instructor
Raphael Asghar
4.6 Average rating
2,128 Reviews
22,979 Students
12 Courses
Production SQL Database Administrator

Worked as a Production SQL Database Administrator for over 12 years for various companies such as Neutrogena, BakeMark, Solutions2Go and NextGen. Want to help those students that want more that the basic SQL Language. Creating real life courses for those students who want a simple path to becoming a SQL DBA.  I love SQL Administration and all that is involved in managing and creating a stable SQL architecture environment. I want to pass that experience and information to my students.