Learn ETL using SSIS
4.4 (203 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.
3,007 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Learn ETL using SSIS to your Wishlist.

Add to Wishlist

Learn ETL using SSIS

Learn SSIS and ETL concepts. Start from an absolute beginner to writing and deploying production quality packages.
4.4 (203 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.
3,007 students enrolled
Last updated 6/2017
English
Price: Free
Includes:
  • 1.5 hours on-demand video
  • 5 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • At the end of this course, students will be able to deploy and automate process to extract data from various sources, transform them so that the data can be queried, and finally load them into a warehouse using SQL Server Integration services.
  • They would be able to apply these concepts in their day to day projects, where there might be a need to move data across systems and store it in a friendly query-able format for reporting and analysis
View Curriculum
Requirements
  • There is no pre-requisite to this course. We go through each step in detail.
  • All you would need is a Windows Machine or atleast a Virtual Machine running Windows.
Description

In this course we will learn about the basic and advanced concepts of SQL Server Integration Services or SSIS. We will walk through the different tools provided by SSIS to Extract, transform and Load data into various databases. This course can followed along with me, provided you have Windows OS or a Windows VM. There are no-prerequisites to the course. At the end of this course, you will be comfortable building an ETL package, moving data around systems, Transforming data using SSIS controls like Fuzzy Lookup, Web service tasks, Email Tasks etc. and configuring and deploying production quality packages with tasks like SSIS logging and checkpoint tasks. Hope you enjoy the course.

Who is the target audience?
  • This course is intended for people who want to learn Extract, Transform and Load (ETL) using SSIS or SQL Server Integration services
  • The course covers absolute basics and some advanced Concepts.
Students Who Viewed This Course Also Viewed
Curriculum For This Course
14 Lectures
01:37:08
+
Welcome
1 Lecture 02:46

A little about myself and expectations from this course!

Introduction and Welcome
02:46
+
Starting the basics
2 Lectures 07:28

We take a high level view to understand what is an ETL, with some simple examples of how it might be used in day to day projects.

Introduction and Overview
02:41

Here we walk through a high level overview of SQL Server Data Tools, the environment that we will use throughout this course. You can download and install the tool on your windows machine, if you wish to follow along with me. Links and details can be found in the resources section or my website.

Lecture 3: Overview of SQL Server Data Tools
04:47
+
Exploring Data flows
2 Lectures 20:28

In this lecture, we deep dive into a simple example. I will show you how to transfer data from Excel to SQL server. We will look at the control flow tasks in SSIS as well as the Data flow tasks. We create a simple excel workbook, put some data into it, create a simple SQL table and transfer the data from Excel to SQL server Table.

Transferring Data from Excel to SQL Server
10:18

In this lecture, we look at the reverse of Lecture 4 i.e transferring data from SQL server database to Microsoft Excel. You can use this framework to transfer data across any DB technology like SQL, Oracle, MySQL to Excel, CSV, XML etc. Its just a different set of tools.

Transferring Data from SQL server to Excel
10:10
+
Introduction to Data Scripting
1 Lecture 10:21

In this lecture, I show how to use the Script Component to perform some data transformations. This control/Tool is extremely useful to write flexible code to perform transformations that may otherwise not be possible using the out of box controls. This control is extremely powerful and provides great flexibility.

Data Scripting
10:21
+
Deployments
1 Lecture 08:12

A well-architected ETL package should be able to respond to changes in the environment or to other external factors, ideally without editing the source code. Hence SSIS introduced the concept of package configurations. We will walk through a simple example where we create an XML configuration and run a package.

Package Configurations
08:12
+
Control Flow Tasks
6 Lectures 46:33

In this lecture, we study the use of control flow tasks and walk through some examples, where I show you how to setup a workflow using SSIS control flow task. We look at the Execute SQL task and File Tasks in SSIS. We look at an example, where we configure the tasks to execute one after the other or in Parallel. We also look at some conditional flow, where a task execution will be based on the previous task's success/failure.

Control Flow Tasks and Precedence constraints
11:12

In this lecture we look at the SSIS web service Task. We look at an example, where we look at a publicly available webservice and call the webservice from SSIS by passing parameters. We push the data returned by the webservice into a Text File.

Webservice Tasks
06:42

In this lecture we look at some looping constructs. We take an example, where we store some data in 5-6 files in a folder. Then we create a package, to loop through these files and transfer the data into SQL Server. We make use of the SSIS For-Each Loop Container

For Each Looping
08:57

Fuzzy Lookup Transformation
06:10

In this lecture, we look at mechanisms to restart failed packages from the point of failure. Integration Services can restart failed packages from the point of failure, instead of rerunning the whole package. If a package is configured to use checkpoints, information about package execution is written to a checkpoint file. When the failed package is rerun, the checkpoint file is used to restart the package from the point of failure. If the package runs successfully, the checkpoint file is deleted, and then re-created the next time the package is run.

Checkpoints
07:22

SQL Server Integration Services includes log providers that you can use to implement logging in packages, containers, and tasks. With logging, you can capture run-time information about a package, helping you audit and troubleshoot a package every time it is run. For example, a log can capture the name of the operator who ran the package and the time the package began and finished.

Logging
06:10
+
Conclusion
1 Lecture 01:20

We conclude the course with this lecture. Hope you enjoyed the course and the assignments.

Conclusion
01:20
About the Instructor
Rakesh Gopalakrishnan
4.5 Average rating
10,038 Reviews
109,170 Students
4 Courses
Over 100,000 Students

I am a coder, manager, educator and a gamer. I love data and analytics. In my day job, I work with database technologies including SQL , Big Data and Tableau. I am passionate about technologies and love coding and managing teams. In my spare time I like to teach Big Data analytics, Databases, Programming etc. I am currently working on certain machine learning and Data Science projects and love to explore more in the Statistics field.