Explore

SQL Server Integration Services (SSIS) - An Introduction

4 hours on-demand video

$ 17.99

Save Course

Go to Course

Brief Introduction

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

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.

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.

Requirements

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.

Recommended for you

Become an SQL Developer: Learn (SSRS, SSIS, SSAS,T-SQL,DW)

Learn SQL Developer Skills from Scratch(SSRS, SSIS, SSAS,T-SQL,Data Warehouse(DW)) They may work as database or web developers, depending on the specific position....

Save Course

Microsoft SQL Server Integration Services (SSIS) Training

Learn how to deal with loading of different kinds of data into SQL Server It will be the golden ticket to your success in this industry....

Save Course

Learn Microsoft SSIS (SQL Server Integration Services)

Learn to use SSIS to Integrate data by extracting,transforming and loading data SQL Server Integration Services, or SSIS, is a powerful component of the Microsoft SQL Server database ....

Save Course