Udemy

SQL Server Integration Services (SSIS) - An Introduction

Name: SQL Server Integration Services (SSIS) - An Introduction
Price: 99.99 USD
Availability: InStock
Rating: 4.6 (11018 reviews)

4.6(11,018)45k studentsBEGINNEREnglish

Korshub's take

Visual Data Automation for Beginners

SQL Server Integration Services (SSIS) is the visual engine behind enterprise data movement. Instead of scripting, you'll use tasks, components, and flowcharts to design ETL pipelines—extracting data, transforming it through aggregation and conditional logic, then loading it into new tables.

The course walks you through the essentials: setting up your free SQL Server 2022 Developer edition, mastering core Data Flow and Control Flow components, and building real integration packages. You'll tackle transformations like merging datasets and conditional splits with plenty of hands-on practice. The pacing respects beginners—clear examples and practical exercises let you follow along without rushing through theory. By the end, you'll have the confidence to tackle your own data automation projects.

About this course

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 2022 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.

Please note: This course is not affiliated with, endorsed by, or sponsored by Microsoft.

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.

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.