Learn Microsoft SSIS (SQL Server Integration Services)

Learn to use SSIS to Integrate data by extracting,transforming and loading data

3.50 (71 reviews)

Udemy

platform

English

language

Databases

What you will learn

Create packages

Extract data

Transform data

Load data

Add connection managers

Control data flow

Test Packages

Create a complete basic ETL ( Etract,Transform,Load) process

Why take this course?

SQL Server Integration Services, or SSIS, is a powerful component of the Microsoft SQL Server database .
SSIS is a useful dynamic and powerful Business Intelligence Tool .
It is added to SQL Server Database when you install SQL Server Data Tools (SSDT)which adds the Business Intelligence Templates to Visual studio that is used to create Integration projects.
.
The course covers the core SSIS tools including the use of the import and export wizard, understanding and using the Solution Explorer Window, and using the SSIS Package Designer.

SSIS can be used for:

• Data Integration
• Data Transformation
• Providing solutions to complex Business problems
• Updating data warehouses
• Cleaning data
• Mining data
• Managing SQL Server objects and data
• Extracting data from a variety of sources
• Loading data into one or several destinations

What You Will Learn ....

• How to install SQL Server Database
• How to download and attach a database to SQL Server
• How to download and install SQL Server Data Tools
• How to Create a New Integration Services Project
• How to add and Configuring a Flat File Connection Manager
• How to add and Configuring an OLE DB Connection Manager
• How to add a Data Flow Task to the Package
• How to add and Configuring the Flat File Source
• How to add and Configuring the Lookup Transformations
• How to Create Integration Services Tasks
• How to Create New Connection Manager
• How to Write data to a SQL Server database
• How to Execute a package from SQL Server Data Tools
• How to Control Data Flow for Flat Files
• How to test Packages

Reviews

Luis

February 25, 2022

Another course from the same instructor with repeteaded information on courses made by him. A lot of videos in the sections are exactly the same to other courses, for example: "Design and Implement a Data Warehouse: | SSIS | SSAS | SSRS" or "implementing-a-data-warehouse-with-microsoft-sql-server". Beware of this and take a very good look at the content of all the courses courses (and others from the same instructor about similar themes) before buying or you will feel that bought the same thing several times. Feels like been scammed.

Chris

June 10, 2020

He skipped a whole part. At the end of number 19 of Section 2, he said he was going to break it up and finish creating the Data Key Lookup in the next part. However, that never happened. The next part started with the Data Key Lookup already created. I tried to recreate it myself, but it errored. Therefore, I was unable to follow along in my own code for the remainder of the section.

Steve

April 17, 2019

I didn't really find this, particularly useful. Unfortunately, the instructor didn't do a very good job of scripting a learning plan. Lots of apologies, missteps etc.. The pace was okay.. The nice part is; you can speed up the recording at as required to increase the speed. The tone and cadence were okay. I just felt it was lacking content.

Sammie

August 10, 2018

If the instructor could show us more examples and explain more about the source/destination/or even connector, I think the courses will be more useful.

Gordon

October 20, 2017

Very slow... It's taking forever to get to the meat of the title SSIS... so far nothing has been done... to hell with flat files, what about ETL of Sql Data?

John

October 10, 2017

Although this was a rather basic introduction to SSIS--perhaps what is needed by those who have absolutely no idea what SSIS even stands for--it was a decent course. The instructor seemed to know what he was talking about although there are mistakes he makes in the videos that he goes back and corrects during the video. I feel that this could have been mostly avoided by practicing beforehand. That alone isn't that big of a deal though. I felt the course videos were a bit slow and, as I've stated before, very basic. For the absolute beginner that knows almost nothing about SSIS, then this course is good to pick up. If you want any sort of challenge, then you'll need to pick up a different course. I appreciate the instructor's ability to get concepts across rather well, though. It's easy to follow, especially if you like or otherwise don't mind slow pacing. The real-world examples are a nice addition to what is otherwise a fairly basic course.

Binod

June 4, 2017

This cource is Great for Beginner to walk you through the step by step to accomplish learning. Great Example to make understand easily.

Bob

April 27, 2017

I like the brief sections; however, there seem to be a bit of mistaken actions to get to the correct tools. Neverthless, it good experience to work through the Tools environment. I also think that my Visual Studio and SQL Tools are a different version than viewed in this course, but it still is learnable.

Charts

Price

Rating

Enrollment distribution

Learn Microsoft SSIS (SQL Server Integration Services) - Distribution chart