GK4398A Implementing a SQL Data Warehouse (20767_B)

0% of 43 hours and 14 minutes completed.

In this course, you will learn how to implement a data warehouse platform to support a business intelligence (BI) solution. You will discover how to create a data warehouse, how to implement extract, transform, and load (ETL) with SQL Server Integration Services (SSIS), and how to validate and cleanse data with Data Quality Services (DQS) and Master Data Services. This course uses Microsoft SQL Server 2016 and incorporates material from the Official Microsoft Learning Product 20767: Implementing a SQL Data Warehouse.

After completing this course, you will be able to:

  • Overview of data warehousing
  • Considerations for building a data warehouse
  • Design and implementation for a data warehouse
  • Columnstore indexes
  • Azure SQL Data Warehouse
  • ETL with SSIS
  • Implement control flow in an SSIS package
  • Debug and troubleshoot SSIS packages
  • Incremental ETL and modified data extraction
  • Microsoft DQS
  • Master Data Services concepts and implementation
  • Extend SSIS
  • Deploy and configure SSIS packages
  • BI tools with Azure SQL Data Warehouse
There are no resources available.
0 attachments
0%
Introduction to Data Warehousing
2 hours 10 minutes 21 Activities: Article  (0)  |  Lab  (6)  |  Video  (15)
0%
Planning Data Warehouse Infrastructure
1 hour 43 minutes 21 Activities: Article  (0)  |  Lab  (6)  |  Video  (15)
0%
Designing and Implementing a Data Warehouse
3 hours 30 minutes 33 Activities: Article  (0)  |  Lab  (6)  |  Video  (27)
0%
Columnstore Indexes
2 hours 1 minute 19 Activities: Article  (0)  |  Lab  (6)  |  Video  (13)
0%
Implementing an Azure SQL Data Warehouse
2 hours 57 minutes 36 Activities: Article  (0)  |  Lab  (6)  |  Video  (30)
0%
Creating an ETL Solution
3 hours 11 minutes 25 Activities: Article  (0)  |  Lab  (6)  |  Video  (19)
0%
Implementing Control Flow in an SSIS Package
4 hours 40 minutes 32 Activities: Article  (0)  |  Lab  (7)  |  Video  (25)
0%
Debugging and Troubleshooting SSIS Packages
3 hours 1 minute 23 Activities: Article  (0)  |  Lab  (6)  |  Video  (17)
0%
Implementing a Data Extraction Solution
6 hours 32 minutes 44 Activities: Article  (0)  |  Lab  (7)  |  Video  (37)
0%
Enforcing Data Quality
3 hours 8 minutes 24 Activities: Article  (0)  |  Lab  (7)  |  Video  (17)
0%
Master Data Services
3 hours 33 minutes 34 Activities: Article  (0)  |  Lab  (6)  |  Video  (28)
0%
Extending SQL Server Integration Services
1 hour 51 minutes 16 Activities: Article  (0)  |  Lab  (6)  |  Video  (10)
0%
Deploying and Configuring SSIS Packages
2 hours 26 minutes 22 Activities: Article  (0)  |  Lab  (6)  |  Video  (16)
0%
Consuming Data in a Data Warehouse
1 hour 52 minutes 21 Activities: Article  (0)  |  Lab  (6)  |  Video  (15)
0%
Course Conclusion: GK4398A Implementing a SQL Data Warehouse
2 minutes 1 Activity: Article  (0)  |  Lab  (0)  |  Video  (1)
0%
End of Course Questions
25 minutes 25 Activities: Article  (0)  |  Lab  (25)  |  Video  (0)
0%
Survey
5 minutes 1 Activity: Article  (1)  |  Lab  (0)  |  Video  (0)