![Implementing a Data Warehouse SQL Server 2019 [Updated: 3/20/2025]](https://pixhost.icu/avaxhome/f8/f817/f817a7810eff42188cddf1fbd7a2a2c5-8986617498622050905_medium.webp)
Implementing a Data Warehouse SQL Server 2019 [Updated: 3/20/2025]
![Implementing a Data Warehouse SQL Server 2019 [Updated: 3/20/2025]](https://pixhost.icu/avaxhome/f8/f817/f817a7810eff42188cddf1fbd7a2a2c5-8986617498622050905.webp)
Implementing a Data Warehouse SQL Server 2019 [Updated: 3/20/2025]
.MP4, AVC, 1280x720, 30 fps | English, AAC, 2 Ch | 2h 7m | 287 MB
Instructor: Adam Wilbert
.MP4, AVC, 1280x720, 30 fps | English, AAC, 2 Ch | 2h 7m | 287 MB
Instructor: Adam Wilbert
Dimensional models like data warehouses can provide a more accessible and consistent form of data storage than relational databases. You can consolidate data from multiple sources into a single repository for business intelligence, analysis, and reporting.
This course explains how to create a long-term data storage solution using local SQL Server instances and Azure SQL Data Warehouse. Instructor Adam Wilbert shows how to build a data warehouse from the ground up, starting with the tables and views; establish control flow; enforce data quality; and use your data in services such as SQL Server Reporting Services and Power BI. By the end of the course, you will be able to implement a robust, custom solution to serve all your organization’s business intelligence, reporting, and analysis needs.
Learning objectives
- Learn about transactional databases vs. data warehouses.
- Learn star and snowflake schemas.
- Create a data warehouse.
- Design tables and views.
- Rebuild columnstore indexes.
- Create an Azure SQL Data Warehouse.
- Establish control flow beyond ETL.
- Enforce data quality.
- Configure Master Data Services.
- Consume data from the warehouse in BI services.
![Implementing a Data Warehouse SQL Server 2019 [Updated: 3/20/2025]](https://pixhost.icu/avaxhome/f8/f817/f817a7810eff42188cddf1fbd7a2a2c5-14524360418107608003_medium.webp)
Implementing a Data Warehouse SQL Server 2019 [Updated: 3/20/2025]
![Implementing a Data Warehouse SQL Server 2019 [Updated: 3/20/2025]](https://pixhost.icu/avaxhome/f8/f817/f817a7810eff42188cddf1fbd7a2a2c5-14524360418107608003.webp)