SQL Server Integration Services (SSIS) - An Introduction
OFF
IT & SoftwareSQL Server Integration Services (SSIS)

SQL Server Integration Services (SSIS) - An Introduction

4.5
(42,953 students)
4h

>_ What You'll 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.

>_ Requirements

  • You don't need to have any prior experience with SQL Server.
  • You don't even need to have it installed - we'll install the full Developer edition for free on your Windows machine.
  • It would help if you have had some prior experience with T-SQL, but it is not essential.
  • You need to have a Windows computer, or use a Mac computer which can dual-boot into Windows or using Parallel Desktop with Windows. (However, it will not work under Windows ARM - for example, a Mac M1 or M3.)

/ Course Details & Curriculum

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.

Author and Instructor

P

Phillip Burton, I Do Data Limited

Expert at Udemy

With years of hands-on experience in IT & Software, Phillip Burton, I Do Data Limited has dedicated thousands of hours to teaching and mentorship. This course is the culmination of industry best practices and a proven curriculum that has helped thousands of students transition into professional roles.

Community Feedback

M

Michael Chen

Verified Enrollment

"This SQL Server Integration Services (SSIS) - An Introduction course was exactly what I needed. The instructor explains complex IT & Software concepts clearly. Highly recommended!"

S

Sarah Johnson

Verified Enrollment

"I've taken many Udemy courses on IT & Software, but this one stands out. The practical examples helped me land a job."

D

David Smith

Verified Enrollment

"Great value for money. The section on SQL Server Integration Services (SSIS) was particularly helpful."

E

Emily Davis

Verified Enrollment

"Excellent structure and pacing. I went from zero to hero in IT & Software thanks to this course. Lifetime access is a huge plus."

Common Questions

Is the "SQL Server Integration Services (SSIS) - An Introduction" course truly discounted?
Yes. By utilizing our verified 90% coupon, you can enroll in "SQL Server Integration Services (SSIS) - An Introduction" at a massive discount. This grants you lifetime access to all course materials and updates.
Do I qualify for a certificate upon completion?
Yes. When you enroll with a 90% coupon provided by CoursesWyn, you follow the same path as a paid student and are eligible for the official completion certificate from Udemy.
What happens if the coupon code expires?
Udemy coupons have strict enrollment limits and time windows. If this code expires, we recommend bookmarking this page and checking back daily, as we refresh our deals constantly to find the latest active discounts.
$99.99Save 90%
$9.99

Verified Discount Code

CLAIM DISCOUNT 🚀
Lifetime Access
🏆Official Certificate
📱Access on Mobile/TV
🔄Latest Updated Course

Claim Your Discount Code

XXXXXXXX
CLICK TO SHOW
$99.99
$9.9990%
GET DEAL