SQL Server Integration Services (SSIS) – An Introduction
SQL Server Integration Services (SSIS) - An Introduction
Learn the basics of SQL Server Integration Services (SSIS) - with Practical Activities.
Product Brand: Udemy
4.6
Udemy Coupon Code for SQL Server Integration Services (SSIS) – An Introduction Course. Learn the basics of SQL Server Integration Services (SSIS) – with Practical Activities.
Created by Phillip Burton, I Do Data Limited | 4 hours on-demand video course | 3 downloadable resources
SQL Server Integration Services Course Overview
SQL Server Integration Services (SSIS) – An Introduction
Welcome to this SQL Server Integration Services (SSIS) – An Introduction course about SQL Server Integration Services. In this course you’ll be downloading and installing the latest 2023 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. 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.
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.
Recommended SQL Server Course
70-461, 761: Querying Microsoft SQL Server with Transact-SQL Best seller
SQL Essentials – Thinking in SQL form Beginners to Pro New
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.
Instructor
My courses include Power BI, Tableau, SQL Server, Power Platform (Power Apps, Power Automate, etc.), Azure, Microsoft Office, and more. Many of my courses follow requirements for official Microsoft certifications – so with a bit of practice, you could enter the exam and put it on your CV or resume.
I have been a Computing Consultant providing expert services in the development of computer systems and data analysis. I am one of 9 award winning Experts for Experts Exchange’s 11th Annual Expert Awards. My interests are working with data, including Microsoft Power BI, Excel, Access, SQL Server, and the Power Platform.
