March 2020
Intermediate to advanced
528 pages
13h 18m
English
Relational databases such as the Azure SQL database are designed for transactional workloads and optimized for Online transactional processing (OLTP) workloads, while data warehouse or Online Analytical Processing (OLAP) systems are optimized for reporting and analytics. Data in the data warehouse is cleaned, enriched, and transformed so that it can act as a single source of truth that users can trust. A modern data warehouse architecture suggests bringing all your structured and unstructured data into a Data Lake and cleansing, enriching, and transforming data before loading it into your data warehouse.
Read now
Unlock full access