Mastering the Fundamentals of SSIS
4.1 (85 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
481 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Mastering the Fundamentals of SSIS to your Wishlist.

Add to Wishlist

Mastering the Fundamentals of SSIS

A Practical Guile To SQL Server Integration Services
4.1 (85 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
481 students enrolled
Created by Mike West
Last updated 4/2016
English
Current price: $10 Original price: $20 Discount: 50% off
1 day left at this price!
30-Day Money-Back Guarantee
Includes:
  • 2 hours on-demand video
  • 1 min on-demand audio
  • 7 Articles
  • 2 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I 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.
View Curriculum
Requirements
  • You'll need to download and install SQL Server 2012, 2014 or 2016. The Express Edition will do.
  • You'll need to download and install Visual Studio 2015. Again, the express edition will do.
  • You'll need a copy of the AdventureWorks database.
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!!!!!

Who is the target audience?
  • This is a mid level course aimed at those who have a working foundation of SQL Server.
  • This is not an entry level course.
  • Everything you need to take the course will be included. There are no items you'll have to purchase.
Students Who Viewed This Course Also Viewed
Curriculum For This Course
Expand All 35 Lectures Collapse All 35 Lectures 01:54:28
+
Intro to SQL Server Integration Services
14 Lectures 34:17

This is a brief introduction to the course.

Preview 01:17

Are you in the right place?

I want to make sure you are taking the correct course for your needs.

Preview 01:23

This is where you'll download the content for the course.

Course Downloads
02:13

Microsoft really botched this one up. Let's find out the most recent name and location for SSDT.

Where did BIDS or SSDT go?
00:57

In this lecture let's install SSDT. 

Installing SSDT
04:23

Installing Adventureworks Training Database
03:08

Let's cover the interface we will be spending a lot of our time in.

It's very intuitively designed.

Preview 02:15

In this lesson let's define a package and determine how it relates to SSIS.

Preview 01:02

SSIS comes with an Import/Export wizard that assists you with crafting simple packages.

Preview 04:26

The foundation of our package will be built within projects.

These projects ride with solutions.

Let's cover that in detail in this brief lecture.

The Project and the Solution
01:52

Let's learn the basics of tasks and use them to create a very simple SSIS package.

Our Very First SSIS Package. Learning what tasks do.
08:53

What does the service that runs SSIS really do?

Let's find out in this lesson.

Integration Services Service
00:23

Let's wrap up what we've covered in this section.

Summary
01:18

Let's go over some of the new vernacular associated with the SSIS environment.

Terminology
00:46

Quiz
10 questions
+
Core SSIS Features - Control Flow
10 Lectures 39:23

The most famous and important of all tasks.

Let's cover what he does.

The Data Flow Task
10:42

Let's walk through some of the task we use most often.

Some of them, like the data flow task you'll use on almost every single package.

Defining The Most Common Tasks
03:41

Not my favorite task but it's there if we need it.

The Bulk Insert Task
06:32

The Connection Manger is where we house our connections to the various data sources we use in our SSIS packages.

Let's look at the two places where we can view these connections.

Connection Manager
01:15

Let's call a package from another package.

It's nice to have to create more complex workflows.

The Execute Package Task
02:02

Let's discuss a way we can call other programs from within SSIS.

The Execute Process Task
01:22

Easily one of my favorite tasks.

This one was way overdue and it's nice to have.

The File System Task
02:31

Having our SSIS packages communicate with us is nice.

We can also send out attachments.

This is a great task you'll use often.

The Send Mail Task
02:59

Containers are a little more complex and require some additional configuration but their usefulness outweighs the added learning curve.

The ForEach Loop Containter
07:44

Let's wrap up what we've covered in this section.

Summary
00:35

Quiz
10 questions
+
Core SSIS Features - Data Flow
10 Lectures 40:27

Conditional split is used to route data rows to different outputs based on conditions. This is similar to CASE statement in programming languages.

The Conditional Split Transformation
05:12

The Aggregate transformation applies aggregate functions, such as Average, to column values and copies the results to the transformation output.

The Aggregate Transformation
03:55

The Derived Column transformation creates new column values by applying expressions to transformation input columns.

Derived Column Transformation
03:33

In the current release of SQL Server Integration Services, the SQL statement in an Execute SQL task can contain a MERGE statement.

The Merge Transformation
04:32

You use the OData Source component in an SSIS package to consume data from Open Data Protocol (OData) services.

The Odata Transformation
02:16

Sometimes it's required to have multiple logical copies of source data of a single source table either for applying different transformation logic on each set or having each dataset for separate consumers, Multicast transformation helps to do this.

The Multicast Transformation
03:50

The dtexec command prompt utility (dtexec.exe) can be used to run a SSIS package.

Execute Package Utility
02:07

To protect the data in an Integration Services package, you can set a protection level that helps protect just sensitive data or all the data in the package.

Package Protection Levels
02:28

In this lesson let's walk through importing an excel spreadsheet into SQL Server. 

Importing an Excel Document
11:30

Let's wrap up what we've learned in this section.

Summary
01:04

Quiz
10 questions
+
Conclusion
1 Lecture 00:23

You've completed this course on the fundamentals of SSIS. Congratulations and thank you!!!

Final Words and a Thank You!!!
00:23
About the Instructor
Mike West
4.3 Average rating
1,803 Reviews
30,447 Students
34 Courses
SQL Server and Machine Learning Evangelist

I've been a production SQL Server DBA most of my career.

I've worked with databases for over two decades. I've worked for or consulted with over 50 different companies as a full time employee or consultant. Fortune 500 as well as several small to mid-size companies. Some include: Georgia Pacific, SunTrust, Reed Construction Data, Building Systems Design, NetCertainty, The Home Shopping Network, SwingVote, Atlanta Gas and Light and Northrup Grumman.

Experience, education and passion

I learn something almost every day. I work with insanely smart people. I'm a voracious learner of all things SQL Server and I'm passionate about sharing what I've learned. My area of concentration is performance tuning. SQL Server is like an exotic sports car, it will run just fine in anyone's hands but put it in the hands of skilled tuner and it will perform like a race car.

Certifications

Certifications are like college degrees, they are a great starting points to begin learning. I'm a Microsoft Certified Database Administrator (MCDBA), Microsoft Certified System Engineer (MCSE) and Microsoft Certified Trainer (MCT).

Personal

Born in Ohio, raised and educated in Pennsylvania, I currently reside in Atlanta with my wife and two children.