SQL Server Integration Services (SSIS) – An Introduction

Learn the basics of SQL Server Integration Services (SSIS) - with Practical Activities.

Created by: Phillip Burton • 880000+ students so far
Best Selling Instructor - over 880,000 students so far

Created by: I Do Data Limited
Improve your skills in SQL, Office, Tableau, Power BI + more

What Will I 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.)

Target audience

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