SQL Server Integration Services (SSIS) - An Introduction (Udemy.com)

Learn the basics of SQL Server Integration Services (SSIS) - with Practical Activities. Useful for 70-763 certification.

( 355 Reviews )

Created by: Phillip Burton

Produced in 2021

What you will learn

Do Extraction, Transform and Load (ETL) tasks.
You can use SQL Server tables, Excel spreadsheets and text files as your source.
You'll be able to change data types, add columns, aggregate, split, sort and join
You can then view what has been created, and save it to spreadsheet, database tables, or the clipboard.

Quality Score

Content Quality

Video Quality

Qualified Instructor

Course Pace

Course Depth & Coverage

Overall Score : 92 / 100

Course Description

Reviews:
"Instructor is easy to follow. He gives very clear examples. Course moves quickly enough to be engaging without skipping over material." -- Sarah Hale
"This course works for me because it progresses with a level of detail that will be useful as I think through each step necessary to execute my own integration packages. There are several courses to choose from and I'm glad I chose this one." -- David McNickle
"Very good introductory course. Didn't really know what SSIS was until recently. Working through the course opened my eyes to past projects that would have benefited from an SSIS ETL package or two." -- Stephen Benton
Welcome to this course about SQL Server Integration Services.
In this course you'll be downloading and installing the latest 2016 SQL Server Developer a full version for free, so that you can use it on your machine. And previous versions of SQL Server Developer have previously retailed for around $100, and now it's free.
So what is SSIS? It's a way to automate in the importing and exporting and data or ETL: extract, transform and load. It's a very visual part of SSIS, using tasks, components and flowcharts, so it's easy to learn the basics of it.
We'll start by extracting some data, and then loading it into another table. I'll take nice as slow as we start to introduce transformations, such as aggregation, conditional split, merging and auditing. There'll be plenty of practice activities too, so you can get to practice your new-found skills. And if you are doing Microsoft certificates, it can help towards your 70-463 certification as well.
By the end of this course, you'll be confident in using the main Data Flow components and Control Flow tasks, and would be able to use it in your own work.Who this course is for:

You should take this course if you are not experienced in SSIS, or if you want to know what it is for.
SSIS is good for automating certain processes, and is very visible.
It is great for beginners, and good if you have had a little prior experience.
As it is going through the basics, it is not useful if you commonly use SSIS.
It can help towards your 70-463 certification.

Time: 4h

Instructor Details

Phillip Burton

4.6 Rating
355 Reviews

Phillip is a Computing Consultant providing expert services in the development of computer systems and data analysis. He is a Microsoft Certified Technology Specialist. He has also been certified as a Microsoft Certified Solutions Expert for Business Intelligence, Microsoft Office 2010 Master, and as a Microsoft Project 2013 Specialist.
He enjoys investigating data, which allows him to maintain up to date and pro-active systems to help control and monitor day-to-day activities. He has also developed expertise and programmes to catalogue and process and control electronic data, large quantities of paper or electronic data for structured analysis and investigation.
He is one of 9 award winning Experts for Experts Exchange's 11th Annual Expert Awards and was one of Expert Exchange's top 10 experts for the first quarter of year 2015.
His interests are working with data, including Microsoft Excel, Access and SQL Server.

SQL in Motion (2017)

0.0 (0 Reviews)

Provider: Manning Publications
Time: 4h

$59.99

Introduction to SQL (2015)

4.7 (6 Reviews)

Provider: SQLBolt

Free

Intro to SQL: Querying and managing data

Intro to SQL: Querying and managing data (2015)

0.0 (0 Reviews)

Provider: Khan Academy
Time: 1h

Free

More Courses

More courses by Phillip Burton

70-461, 761: Querying Microsoft SQL Server with Transact-SQL

70-461, 761: Querying Microsoft SQL Server with Transact-SQL (2021)
4.6 (360 Reviews)

- Provider: Udemy
- Time: 29.5h

$11.99

70-462: SQL Server Database Administration (DBA)

70-462: SQL Server Database Administration (DBA) (2021)
4.5 (350 Reviews)

- Provider: Udemy
- Time: 9.5h

$11.99

Microsoft SQL Server Reporting Services (SSRS)

Microsoft SQL Server Reporting Services (SSRS) (2021)
4.2 (338 Reviews)

- Provider: Udemy
- Time: 6h

$11.99

70-778, DA-100: Analyzing and Visualizing Data with Power BI

70-778, DA-100: Analyzing and Visualizing Data with Power BI (2021)
4.5 (224 Reviews)

- Provider: Udemy
- Time: 24h

$11.99

SQL Server SSAS (Multidimensional MDX) - an Introduction

SQL Server SSAS (Multidimensional MDX) - an Introduction (2021)
4.5 (207 Reviews)

- Provider: Udemy
- Time: 8h

$11.99

SQL Server Essentials in an hour: The SELECT statement

SQL Server Essentials in an hour: The SELECT statement (2021)
4.5 (183 Reviews)

- Provider: Udemy
- Time: 1h

$11.99

All courses by Phillip Burton

Reviews

4.6

355 total reviews

5 star 4 star 3 star 2 star 1 star

Write a Review

By Cezar Tipa on 11/8/2020

Good presentation

By Alan Purseglove on 10/23/2020

This was a Very Good Introduction and I found it very Helpful. I do have a very good understanding of ETL Processes just not within the SSIS as I have never seen this product before. In all it was very well explained.

By Manuel I Velazquez Plata on 10/19/2020

Very good course, it shows how ssis works with practical examples in almost every lesson. Before this course I had no idea about ssis but now I feel ready to use it in my job

By Bhavani Sundararajan on 10/17/2020

Good course for beginners and easily understandable...

By Ananthu Kaladharan on 10/15/2020

Awesome Course

By Tony Onyeka on 10/15/2020

These are good stuff being taught by Burton, though I would wish to go deeper

By Rene Legaspi on 10/6/2020

very good but sometimes goes too fast when switching windows/tabs

By Archit Aggarwal on 10/6/2020

Instructor easy to follow, nicely presented. Keeps one motivated and involved in the complete session.

By Dan Gallagher on 10/2/2020

Excellent course. Covers the basics and more.

By Balaji K on 9/27/2020

Thank you Nice Session

By Mario Jos Echeverra Hernndez on 9/27/2020

Very explicit details, great course!

By Venkat on 9/25/2020

Definetely it was useful,, but brief description on other modules like parameters, eventhandlers + some untouched toolbox would have been an added advantage... or advisiing as how to explore .. receives great thumbs up... Well will do practice.. Good luck to you all