Summary

Completed

Relational data warehousing skills are essential in multiple data professional roles, including data engineers, data analysts, and data scientists.

In this module, you learned how to:

  • Design a schema for a relational data warehouse.
  • Create fact, dimension, and staging tables.
  • Use SQL to load data into data warehouse tables.
  • Use SQL to query relational data warehouse tables.

Learn more

To learn more about using Azure Synapse Analytics for relational data warehousing, refer to Synapse POC playbook: Data warehousing with dedicated SQL pool in Azure Synapse Analytics.