Implementing ETL Pipelines on the Microsoft SQL Server Platform
|
This course will teach you how to use the SQL Server database engine and Integration Services (SSIS) to develop, deploy, and monitor an ETL pipeline with the SQL Server data stack for dimension and fact tables.
Implementing pipelines for dimensional models is very common in SQL Server with Integration Services. In this course, Implementing ETL Pipelines on the Microsoft SQL Server Platform, you will learn to use Integration Services (SSIS) to create packages to populate dimension and fact tables. Next, you will understand how to use Lookup, Data Transformation, Conditional Split, and OLEDB components to complete a pipeline for ETL processes. Finally, you will learn how to stage data to execute batch update statements for improving update performance of changing data. When you’re finished with this course, you’ll have the skills and knowledge of Implementing ETL Pipelines on the Microsoft SQL Server Platform needed to develop SSIS packages that can be deployed to production and monitored for performance and errors.
Author Name: Thomas LeBlanc
Author Description:
Thomas LeBlanc (Microsoft Data Platform MVP) is a Data Enthusiast in Baton Rouge, La. He started his IT career as a COBOL programmer in 1989 while at LSU. Since then he has spent years as a developer, DBA and Data Warehousing/Business Intelligence Architect. Community involve includes the local SQL Server and Analytics User Groups as well as SQLSaturday. Speaking engagements have been a blessing at SQL Pass Summit, Live 360, VSLive and IT Dev Connections.
User Reviews
Be the first to review “Implementing ETL Pipelines on the Microsoft SQL Server Platform”
Related Products
Data Engineering
Learn how to build, optimize, and maintain data pipelines for data processing and storage.
Data Pipelines with Azure
Build scalable data pipelines using Microsoft Azure tools.
Use Azure Synapse serverless SQL pool to query files in a data lake
With Azure Synapse serverless SQL pool, you can leverage your SQL skills to explore and analyze data in files, without the need to load the data into a relational database.
Transform data with Spark in Azure Synapse Analytics
Data engineers commonly need to transform large volumes of data. Apache Spark pools in Azure Synapse Analytics provide a distributed processing platform that they can use to accomplish this goal.
Secure data and manage users in Azure Synapse serverless SQL pools
Learn how you can set up security when using Azure Synapse serverless SQL pools
Build a data pipeline in Azure Synapse Analytics
Pipelines are the lifeblood of a data analytics solution. Learn how to use Azure Synapse Analytics pipelines to build integrated data solutions that extract, transform, and load data across diverse systems.
There are no reviews yet.