Load data into a relational data warehouse
|
A core responsibility for a data engineer is to implement a data ingestion solution that loads new data into a relational data warehouse.
Load staging tables in a data warehouse, Load dimension tables in a data warehouse, Load time dimensions in a data warehouse, Load slowly changing dimensions in a data warehouse, Load fact tables in a data warehouse, Perform post-load optimizations in a data warehouse
Prerequisites
Before starting this module, you should be familiar with data warehouses in Azure Synapse Analytics. Consider completing the Analyze data in a relational data warehouse module first.
User Reviews
Be the first to review “Load data into a relational data warehouse”
Related Products
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
Designing Data Systems
Master the principles of designing data systems that handle large-scale data efficiently.
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.
Transfer and transform data with Azure Synapse Analytics pipelines
Azure Synapse Analytics enables data integration through the use of pipelines, which you can use to automate and orchestrate data transfer and transformation activities.
Introduction to data engineering on Azure
Microsoft Azure provides a comprehensive platform for data engineering; but what is data engineering? Complete this module to find out.
Explore fundamentals of large-scale analytics
Organizations use analytics platforms to build large scale data analytics solutions that generate insights and drive success. Microsoft provides multiple technologies that you can combine to build a large scale data analytics solution.
There are no reviews yet.