Implementing a Data Warehouse SQL Server 2019
Heads up! This course may be archived and/or unavailable.
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.
Contents:
- Introduction
- 1. Data Warehouse Foundations
- 2. Create a Data Warehouse
- 3. Columnstore Indexes
- 4. Implement an Azure SQL Data Warehouse
- 5. Extract, Transform, and Load (ETL)
- 6. Enforce Data Quality
- 7. Master Data Services
- 8. Consume Data from the Warehouse
- Conclusion
Get a Reminder
Rating | Not enough ratings |
---|---|
Length | 2h 7m |
Starts | On Demand (Start anytime) |
Cost | $29/month (Access to entire library- free trial available) |
From | LinkedIn Learning |
Instructor | Adam Wilbert |
Download Videos | Only via the LinkedIn Learning mobile app |
Language | English |
Subjects | IT & Networking |
Tags | Data Warehousing Database Design Microsoft SQL Server Data Warehouse Architecture |
Get a Reminder
Similar Courses
Careers
An overview of related careers and their average salaries in the US. Bars indicate income percentile.
Warehouse Data Specialist $58k
Data Warehouse Marketing $81k
Specialist - Data Warehouse $87k
Data Warehouse Analyst 3 $107k
Data Warehouse Consultant $115k
Data Integration Engineer| Data Warehouse $116k
Data Warehouse Analyst 2 $121k
Data Warehouse - Architecture $147k
Data Warehouse Validation $152k
Data Architect Data Warehouse $167k
Data Warehouse Architect u2013 for Enterprise Data Warehouse $187k
Data Warehouse Development $249k
Write a review
Your opinion matters. Tell us what you think.
Please login to leave a review
Rating | Not enough ratings |
---|---|
Length | 2h 7m |
Starts | On Demand (Start anytime) |
Cost | $29/month (Access to entire library- free trial available) |
From | LinkedIn Learning |
Instructor | Adam Wilbert |
Download Videos | Only via the LinkedIn Learning mobile app |
Language | English |
Subjects | IT & Networking |
Tags | Data Warehousing Database Design Microsoft SQL Server Data Warehouse Architecture |
Similar Courses
Sorted by relevance
Like this course?
Here's what to do next:
- Save this course for later
- Get more details from the course provider
- Enroll in this course