Mastering the Fundamentals of SSIS

A Practical Guile To SQL Server Integration Services

3.95 (189 reviews)
Udemy
platform
English
language
Other
category
instructor
Mastering the Fundamentals of SSIS
842
students
2 hours
content
Apr 2016
last update
$49.99
regular price

What you will learn

At the conclusion of this course you'll understand how the SSIS works at a very high level.

You'll be able to craft high performing SSIS packages.

You'll understand all the various components of the SSIS Designer.

Description

SQL Server Integration Services (SSIS) is a tool that we use to perform ETL operations; i.e. extract, transform and load data.

We will also sort out the various versions and name changes. For example, in SQL Server 2014 Microsoft decided to no longer include SQL Server Data Tools (Another Visual Studio shell for SSIS) as part of the normal install. This confused everyone. To make matters worse, you now download and install different tools depending on what you have already.

This course will provide you with a solid foundation of SQL Server Integration Services. We will cover everything from the designer to crafting high quality packages.

While ETL processing is common in data warehousing (DW) applications, SSIS is by no means limited to just Data warehousing approaches.

For example, when you create a Maintenance Plan using SQL Server Management Studio (SSMS) an SSIS package is created.

You'll learn all the vernacular associated with SSIS as well as all the core components.

We'll cover the package in detail. The package is the unit of work that is retrieved, executed, and saved.

At a high level, SSIS provides the ability to retrieve data from just about any source, perform transformations on data, covert data from one type to another, load data into just about any source and define complex workflows that move disparate data throughout any organization.

In this course you'll learn how to use SSIS to develop data integration, migration and consolation packages that you as a DBA or developer can use in any organization that has data.

In the course we will cover the integration with other SQL Server products like SSMS. SQL Server Management Studio provides the Integration Services service that you use to manage packages, monitor running packages, and determine impact and data lineage for Integration Services and SQL Server objects.

I look forward to seeing you in the course.

Join Now!!!!!

Content

Intro to SQL Server Integration Services

Welcome To Mastering the Fundamentals of SSIS
Is this Course Right for You?
Course Downloads
Where did BIDS or SSDT go?
Installing SSDT
Installing Adventureworks Training Database
The SSIS Designer
Packages
SSIS Wizard. Moving Data Was Never So Easy.
The Project and the Solution
Our Very First SSIS Package. Learning what tasks do.
Integration Services Service
Summary
Terminology
Quiz

Core SSIS Features - Control Flow

The Data Flow Task
Defining The Most Common Tasks
The Bulk Insert Task
Connection Manager
The Execute Package Task
The Execute Process Task
The File System Task
The Send Mail Task
The ForEach Loop Containter
Summary
Quiz

Core SSIS Features - Data Flow

The Conditional Split Transformation
The Aggregate Transformation
Derived Column Transformation
The Merge Transformation
The Odata Transformation
The Multicast Transformation
Execute Package Utility
Package Protection Levels
Importing an Excel Document
Summary
Quiz

Conclusion

Final Words and a Thank You!!!

Reviews

Robert
March 29, 2022
You realize people do these at work right? Making the entire thing dependent on downloading adventureworks makes it completely worthless when you dont own the database.
Desbele
August 4, 2021
I really appreciate for all the nice presentation and wonderful course. it was very helpful course and i am very glad to buy this course.
Adrian
January 11, 2017
Great overview of SSIS, teaches you the basics that you need to know. Gives you a good base to build on.
Mark
December 24, 2016
Very good information, I did have to search for the answers to some problems that I had, but that is another part of the process to learn.
scott
August 4, 2016
Very Good value for the money. . Annoying that loading adventureworks2012 is emphasized, and halfway through lesson 1, it changes to adventureworks2014, then in lesson 3. changes back to adventureworks2012. . Realize only an SSIS intro course, but more on package deployment would have been good. . Hadoop is in the task menu, and was never mentioned, when all the other tasks were.
Sultan
June 17, 2016
You are the best.learned a lot from you , you have done great job and you explain so nicely , keep up your great work! to student: if you want to learn basic , take this course. you will learn the basic pretty well.
Ángel
June 16, 2016
Está muy bien para darte una introducción a la herramienta si no la conoces. Ya que cubre lo más importante
Thomas
June 1, 2016
Very helpful course, gave me good overview on how to use SSIS with some practical examples. Lectures were clear and concise and gave me good understanding of the subjects covered.
Amyn
April 25, 2016
This course is a quick introduction to SSIS package. It briefly explains and provide some exercises on using important tools to make it more practical course.
James
April 18, 2016
This course presumes you have access to a running SSIS instance, a matching version of Visual Studio and a matching version of its SSDT component. Unfortunately, I don't have access to a running SSIS instance (I was hoping to learn how to set one up); I don't have access to Visual Studio, and I'm not sure the Community Edition supports SSIS projects; and judging by the questions students are asking, getting the right version of SSDT configured looks like a convoluted game of bingo, twisted enough to make Oracle admire. I got to see the fundamentals, but all they were to me are things I don't have, even though I am a dba. I have to look elsewhere to figure out how to get set up and going with SSIS and maybe try this one again sometime.
Lewis
April 18, 2016
Good introduction but felt a little too short, and more could be done around conditions, such as if a table exists or a count > 1 = run this sql else run this sql
Luann
March 29, 2016
32 lectures was very misleading. A lecture was a single piece of information. Was looking for a more in depth class.
Sheila
March 24, 2016
I wasn't able to get the adventure db, therefore, I spent alot of time creating my own data to complete with each section. Also, the Bulk.txt file wasn't provided. I think that having all the data required for the course is important. Maybe spend some time sharing with student where to get it and how to install/configure.
Jeremy
February 18, 2016
Nice, uncluttered, straightforward, easy to follow and understand. The lectures are concise and succinct.
Doug
February 15, 2016
Mike has done it again and produced another good class. If you are looking for a good intro to SSIS class, look no further.

Charts

Price

Mastering the Fundamentals of SSIS - Price chart

Rating

Mastering the Fundamentals of SSIS - Ratings chart

Enrollment distribution

Mastering the Fundamentals of SSIS - Distribution chart

Related Topics

753500
udemy ID
2/5/2016
course created date
11/20/2019
course indexed date
Bot
course submited by