ETL for beginners : Learn to integrate data
3.7 (47 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
1,677 students enrolled

ETL for beginners : Learn to integrate data

Learn to extract, transform and load data
3.7 (47 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
1,677 students enrolled
Last updated 12/2018
English
English [Auto-generated]
Current price: $76.99 Original price: $109.99 Discount: 30% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 2.5 hours on-demand video
  • 2 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll learn
  • How to install SQL Server Database
  • How to download and attach a database to SQL Server
  • How to download and install SQL Server Data Tools
  • How to Create a New Integration Services Project
  • How to add and Configuring a Flat File Connection Manager
  • How to add and Configuring an OLE DB Connection Manager
  • How to add a Data Flow Task to the Package
  • How to add and Configuring the Flat File Source
  • How to add and Configuring the Lookup Transformations
  • How to Create Integration Services Tasks
  • How to Create  New Connection Manager
  • How to Write data to a SQL Server database
  • How to Execute a package from SQL Server Data Tools
  • How to Control Data Flow for Flat Files
  • How to test  Packages
Course content
Expand all 29 lectures 02:37:33
+ Introduction to ETL
7 lectures 23:17
Database Vs Data Warehouse
03:15
What is Big Data
02:43
What is High Volume
03:03
What is High Velocity
03:10
+ Setting up your environment for ETL
11 lectures 01:03:37
Visual studio system requirements
03:08
Download and install visual studio
07:47
Completing visual studio installation
05:09
Exploring visual studio solution explorer
11:45
System requirements for SQL Server
02:49
Download Microsoft SQL Server
04:08
Install Microsoft SQL Server
06:47
Download Adventureworks sample DB
05:07
Attach sample adventureworks DB
04:14
Download AdventureworksDW sample DB
06:40
Download and install SSDT
06:03
+ Implementing ETL Process using SSIS
11 lectures 01:10:39
Introduction to SSIS
03:25
Create a new SSIS Project
05:35
Add a Flat File Connection Manager
06:26
Remap Column Data Types
11:12
Add and configure OLE DB Connection Manager
03:39
Add a Data Flow Task
05:02
Add and configure Flat File Source
04:28
Add and Configure Lookup Transformation
11:29
Add and Configure Lookup For DateKey Transformation
09:28
Add and Configure OLE DB Destination
07:53
Test and Run Package
02:02
Requirements
  • Basic understanding of database concepts
  • Basic working knowledge of Microsoft SQL Server
  • Basic working knowledge of SQL Server Management Studio
  • Basic understanding of SQL
Description

A common problem that organizations face is how to gathering data from multiple sources, in multiple formats, and move it to one or more data stores. The destination may not be the same type of data store as the source, and often the format is different, or the data needs to be shaped or cleaned before loading it into its final destination.

Extract, transform, and load (ETL) is a data pipeline used to collect data from various sources, transform the data according to business rules, and load it into a destination data store.

SQL Server Integration Services (SSIS) is a useful  and powerful Business Intelligence Tool . It is best suited to work with SQL Server Database . It is added to SQL Server Database when you install SQL Server Data Tools  (SSDT)which adds the Business Intelligence Templates to Visual studio that is used to create Integration projects.


SSIS can be used for:

  •  Data Integration

  •  Data Transformation

  •  Providing solutions to complex Business problems

  •  Updating data warehouses

  •  Cleaning data

  •  Mining data

  •  Managing SQL Server objects and data

  •  Extracting data from a variety of sources

  •  Loading data into one or several destinations


What You Will Learn ....

  •  How to install SQL Server Database

  •  How to download and attach a database to SQL Server

  •  How to download and install SQL Server Data Tools

  •  How to Create a New Integration Services Project

  •  How to add and Configuring a Flat File Connection Manager

  •  How to add and Configuring an OLE DB Connection Manager

  •  How to add a Data Flow Task to the Package

  •  How to add and Configuring the Flat File Source

  •  How to add and Configuring the Lookup Transformations

  •  How to Create Integration Services Tasks

  •  How to Create  New Connection Manager

  •  How to Write data to a SQL Server database

  •  How to Execute a package from SQL Server Data Tools

  •  How to Control Data Flow for Flat Files

  •  How to test  Packages 









Who this course is for:
  • Beginner Database Administrators
  • Beginner Data Scientist
  • Beginner Data Analyst
  • Beginner Big Data Analyst