SQL Server Integration Services (SSIS) – An Introduction
47
Lessons
All
Skill Level
3:52h
course Duration
English
Audio
Eng & Esp
Subtitles
Share This Class:
Overview
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.
Completing this course will help you:
- 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.
Who is the course for?
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.
Learning Path
Installing SSIS in Visual Studio
In this section, we install SQL Server Developer, Visual Studio and SSIS. We then have a look around SQL Server Management Studio (SSMS) and SSIS.
Creating simple Extract and Load tasks
- Data Flow Task
- Connection Manager
- OLE DB Source Task
- OLE DB Destination
- Implicit Conversions,
- Data Conversion,
- Derived Column task,
- Aggregation,
- Multi-cast,
- Conditional Split,
- Error handling,
- Sort,
- Adding an Excel source,
- Add Text source and Excel destination,
- Union All,
- Merge and solving Mapping problems,
- Auditing,
- Adding different destinations.
- Adding variables and Row Count,
- Script component
What people are saying
“I feel the best way to learn is to know the background of things – why they happen as they do. The instructor was very good about explaining all that quite clearly throughout the lessons He even intentionally made errors in strategic spots to point out rules or quirks of SSIS.”
Lavinia
“Exception story telling ways of demonstrating real world example, this course is exceptional when I compare SSIS for beginners!!”
Ritesh
“i really enjoyed the pace of the course and the Q/A slides, as well as the common issue fixes , really a nice introduction, thanks !”
Maximiliano
“I have had exposure to SSIS, but never any formal training, and the packages I have reversed engineered are very simple. This was a really good introduction into some of the functions of SSIS. Everything was very easy to understand, and I felt his method of including issues of when things do not work as expected very effective. I would definitely recommend this course and this instructor.”
Rebecca
Previous
Next
Are You Ready To Start?
More Courses
You might also be interested in these courses
DA-100
Analyzing Data with Microsoft Power BI
Analyzing Data with Microsoft Power BI
View Course
T-SQL
Querying Microsoft SQL Server
Querying Microsoft SQL Server
View Course
