Developing ETL Solutions with SSIS for beginners

Developing ETL Solutions with SSIS for beginners, available at $44.99, has an average rating of 4, with 26 lectures, based on 6 reviews, and has 305 subscribers.

You will learn about Create an SSIS Project Create ETL Package Configure data source Extract data Transform data Load data Create data flows Execute SSIS Package This course is ideal for individuals who are Beginners to ETL and SSIS It is particularly useful for Beginners to ETL and SSIS.

Enroll now: Developing ETL Solutions with SSIS for beginners

Summary

Title: Developing ETL Solutions with SSIS for beginners

Price: $44.99

Average Rating: 4

Number of Lectures: 26

Number of Published Lectures: 26

Number of Curriculum Items: 26

Number of Published Curriculum Objects: 26

Original Price: $34.99

Quality Status: approved

Status: Live

What You Will Learn

Create an SSIS Project
Create ETL Package
Configure data source
Extract data
Transform data
Load data
Create data flows
Execute SSIS Package

Who Should Attend

Beginners to ETL and SSIS

Target Audiences

Beginners to ETL and SSIS

ETL ( extract, transform, load ) is a three-phase process where data is extracted, transformed and loaded into an output data container. The data can be collated from one or more sources and it can also be outputted to one or more destinations.

Microsoft SQL Server Integration Services (SSIS) is a platform for building high-performance data integration solutions, including extraction, transformation, and load (ETL) packages for data warehousing. SSIS includes graphical tools and wizards for building and debugging packages; tasks for performing workflow functions such as FTP operations, executing SQL statements, and sending e-mail messages; data sources and destinations for extracting and loading data; transformations for cleaning, aggregating, merging, and copying data; a management database, SSISDB, for administering package execution and storage; and application programming interfaces (APIs) for programming the Integration Services object model.

SSIS Designer is used to create a Microsoft SQL Server Integration Services package. The package that you create takes data from a flat file, reformats the data, and then inserts the reformatted data into a fact table.

In this course, we will create a simple ETL package that extracts data from a single flat file source, transforms the data using two lookup transformations, and writes the transformed data to a copy of the FactCurrencyRate fact table in the AdventureWorksDW sample database. We will also create new packages, add and configure data source and destination connections, and work with new control flow and data flow components.

Course Curriculum

Chapter 1: SQL Server Setup

Lecture 1: Introduction

Lecture 2: What is SQL Server

Lecture 3: SQL Server Editions

Lecture 4: Download SQL Server

Lecture 5: Install SQL Server

Lecture 6: Install SSMS

Lecture 7: Connect SSMS to SQL Server

Lecture 8: Please Note

Lecture 9: Install adventureworks database

Chapter 2: Visual Studio Setup

Lecture 1: What is Visual studio

Lecture 2: Install Visual Studio

Lecture 3: Install SQL Server Data Tools -SSDT

Lecture 4: Install SSDT Templates

Chapter 3: Developing ETL with SSIS

Lecture 1: What is ETL

Lecture 2: What is SSIS

Lecture 3: Create a new integration services project

Lecture 4: SSIS Designer

Lecture 5: Add and configure a Flat file connection manager

Lecture 6: Remapping column data types

Lecture 7: Add and configure OLE DB Connection Manager

Lecture 8: Add a data flow task to the package

Lecture 9: Add and configure the flat file source

Lecture 10: Add and configure the lookup transformations

Lecture 11: Add and configure lookup for datekey transformation.

Lecture 12: Add and configure the OLE DB Destination

Lecture 13: Executing SSIS Package

Instructors

247 Learning
An investment in knowledge pays the best interest

Rating Distribution

1 stars: 0 votes
2 stars: 0 votes
3 stars: 2 votes
4 stars: 3 votes
5 stars: 1 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!

Menu