Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Subscribe
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Building a Better ETL Platform with SSIS
Rating: 4.5 out of 5(4 ratings)
46 students

Building a Better ETL Platform with SSIS

An Introduction to Data Warehousing Using SQL Server Integration Services
Created byJonathan Szeto
Last updated 1/2022
English

What you'll learn

  • Learn the basics of a data warehouse.
  • Understand what ETL stands for and why it differs from normal database processes.
  • Develop SQL Server Integration Services (SSIS) packages for ETL.
  • Deploy SSIS packages to a server.

Course content

1 section • 5 lectures • 4h 15m total length

  • Data Warehousing Overview23:48

    Explore what a data warehouse is, why it supports analytics and business intelligence, and how ETL tools consolidate data from multiple sources into star or snowflake schemas for efficient reporting.

  • ETL Architecture53:02

    Build a metadata-driven etl architecture with staging, operational data stores, and data marts. Prioritize throughput, data integrity, and incremental loads.

  • Change Tracking55:09

    Explore change data capture and change tracking to enable incremental ETL loads by capturing inserts, updates, and deletes in SQL Server, with guidance on setup, retention, and non-SQL Server sources.

  • SSIS Development1:30:54

    Master SSIS development for ETL, migrating data from non-SQL sources into SQL Server using packages, Visual Studio, connection managers, and data flows. Learn variables, parameters, and control flow best practices.

  • SSIS Deployment32:58

    Learn the new SQL Server Integration Services deployment model, using the Integration Services Catalog for project deployment, environments, and parameter mapping; deploy, run, monitor, and secure SSIS packages.

Requirements

  • Students must be proficient in writing SQL.

Description

  • Do you need to migrate a large volume of data without tying up your infrastructure?

  • Do you run complex queries that max out your system resources?

  • Are you building an analytics platform for business intelligence or data science?

If the answer to any of these questions is "yes", then Faster SQL Mastery is the course for you!

Building a Better ETL with SSIS introduces you to the basics of ETL using Microsoft SQL Server Integration Services, or SSIS. You'll learn the following topics in this course:

  • Data Warehousing Overview

  • ETL Architecture Strategies

  • Change Tracking

  • SSIS Development

  • SSIS Deployment

I am a senior SQL database architect with over fifteen years of experience working with MS SQL Server. With the increasing opportunities in data engineering, data science, and business intelligence, SQL developers must be able to transition seamlessly into the world of analytics and data engineering.

Building a data warehouse requires a different set of skills than administering an ordinary application back-end database. Here you will get some real-world experience on how to set up and manage an ETL process that feeds a data warehouse to support these applications.

If you are an intermediate SQL developer or junior DBA with only a few years of experience, this course is perfect for elevating your SQL skills to expert levels. Enroll today to enhance your SQL expertise!

Who this course is for:

  • Advanced SQL developers learning business intelligence and data warehousing.

Report abuse