GK4398A Implementing a SQL Data Warehouse (20767_C)

0% of 40 hours and 32 minutes completed.

This course provides students with the knowledge and skills to provision a Microsoft SQL Server database. The course covers SQL Server provision both on-premise and in Azure, and covers installing from new and migrating from an existing install.This course incorporates material from the Official Microsoft Learning Product 20767: and it can assist you in your preparation for Exam 70-767: Implementing a SQL Data Warehouse.

After completing this course, you will be able to:

  • Describe the key elements of a data warehousing solution
  • Describe the main hardware consideration for building a data warehouse
  • Implement a logical design for a data warehouse
  • Implement a physical design for a data warehouse
  • Create columnstore indexes
  • Implement an Azure SQL Data Warehouse
  • Describe the key features of SSIS
  • Implement control flow by using tasks and precedence constraints
  • Create dynamic packages that include variables and parameters
  • Debug SSIS packages
  • Describe the considerations for implement an ETL solution
  • Implement Data Quality Services
  • Implement a Master Data Services model
  • Describe how you can use custom components to extend SSIS
  • Deploy SSIS projects
  • Describe BI and common BI scenarios
There are no resources available.
0 attachments
0%
Introduction to Data Warehousing
1 hour 40 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
3 hours 16 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
3 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
4 hours 33 minutes 44 Activities: Article  (0)  |  Lab  (7)  |  Video  (37)
0%
Enforcing Data Quality
3 hours 2 minutes 24 Activities: Article  (0)  |  Lab  (7)  |  Video  (17)
0%
Master Data Services
3 hours 37 minutes 34 Activities: Article  (0)  |  Lab  (6)  |  Video  (28)
0%
Extending SQL Server Integration Services
1 hour 50 minutes 16 Activities: Article  (0)  |  Lab  (6)  |  Video  (10)
0%
Deploying and Configuring SSIS Packages
2 hours 25 minutes 22 Activities: Article  (0)  |  Lab  (6)  |  Video  (16)
0%
Consuming Data in a Data Warehouse
2 hours 23 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)