Building a Better ETL Platform with SSIS

An Introduction to Data Warehousing with the help of SQL Server Integration Services.

What you’ll learn

Building a Better ETL Platform with SSIS

In this lesson, you will learn about the basics of a data warehouse.
In this lesson, we’ll talk about what ETL stands for and how it’s different from normal databases.
To do ETL, make SQL Server Integration Services (SSIS) packages.
SSIS packages can be put on a server.

Requirements

Students must be good at writing SQL.

Description

Do you need to move a lot of data but don’t want to tie up your computer system?
Do you run complicated queries that use up a lot of your computer’s power?
Business intelligence or data science: Are you building an analytics platform for these two things?

This course is for you if your answer is “yes” to any of these questions.

Building a Better ETL with SSIS shows you how to do ETL with Microsoft SQL Server Integration Services, or SSIS. Learn about these things in this class:

The basics of data warehousing.
Architectures for ETL.
Change the Tracking.
Development of SSIS.
Deployment of SSIS.

Senior SQL database architect: I’ve worked with MS SQL Server for more than fifteen years and I know a lot about it. People who work with SQL must be able to easily move into the world of data engineering, data science, and business intelligence because there are more opportunities for them.

When you build a data warehouse, you need a different set of skills than when you run an ordinary application back-end database. Some real-world experience will show you how to set up and run an ETL process that feeds a data warehouse to help these applications work better.

If you are an intermediate SQL developer or a junior DBA with a few years of experience, this course is for you. It will help you become an expert in SQL.