GK6554A Implementing a Data Warehouse with Microsoft SQL Server 2014 (20463_D)

0% of 46 hours and 20 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, implement extract, transform, and load (ETL) with SQL Server Integration Services (SSIS), and validate and cleanse data with SQL Server Data Quality Services (DQS) and SQL Server Master Data Services.

This course is designed for customers interested in learning SQL Server 2012 or SQL Server 2014. It covers the new features of SQL Server 2014 as well as the important capabilities across the SQL Server data platform.

This course incorporates material from the Official Microsoft Learning Product 20463: Implementing a Data Warehouse with Microsoft SQL Server 2014. It covers the skills and knowledge measured by Exam 70-463 and along with on-the-job experience, helps you prepare for the exam.

After completing this course, you will be able to:

  • Data warehouse concepts and architecture considerations
  • Select an appropriate hardware platform for a data warehouse
  • Design and implement a data warehouse
  • Implement data flow and control flow in a SSIS package
  • Debug and troubleshoot SSIS packages
  • Implement a SSIS solution that supports incremental data warehouse loads and extracting data
  • Implement data cleansing using Microsoft DQS
  • Implement Master Data Services (MDS) to enforce data integrity
  • Extend SSIS with custom scripts and components
  • Deploy and configure SSIS packages
  • How Business Intelligence solutions consume data in a data warehouse
There are no resources available.
0 attachments
0%
Introduction to Data Warehousing
2 hours 46 minutes 22 Activities: Article  (0)  |  Lab  (9)  |  Video  (13)
0%
Planning Data Warehouse Infrastructure
2 hours 2 minutes 24 Activities: Article  (0)  |  Lab  (9)  |  Video  (15)
0%
Designing and Implementing a Data Warehouse
3 hours 6 minutes 34 Activities: Article  (0)  |  Lab  (9)  |  Video  (25)
0%
Creating an ETL Solution with SSIS
3 hours 54 minutes 28 Activities: Article  (0)  |  Lab  (9)  |  Video  (19)
0%
Implementing Control Flow in an SSIS Package
5 hours 57 minutes 35 Activities: Article  (0)  |  Lab  (10)  |  Video  (25)
0%
Debugging and Troubleshooting SSIS Packages
2 hours 39 minutes 26 Activities: Article  (0)  |  Lab  (9)  |  Video  (17)
0%
Implementing a Data Extraction Solution
5 hours 42 minutes 28 Activities: Article  (0)  |  Lab  (9)  |  Video  (19)
0%
Loading Data into a Data Warehouse
4 hours 42 minutes 25 Activities: Article  (0)  |  Lab  (9)  |  Video  (16)
0%
Enforcing Data Quality
3 hours 58 minutes 25 Activities: Article  (0)  |  Lab  (10)  |  Video  (15)
0%
Master Data Services
3 hours 40 minutes 34 Activities: Article  (0)  |  Lab  (9)  |  Video  (25)
0%
Extending SQL Server Integration Services
2 hours 28 minutes 19 Activities: Article  (0)  |  Lab  (9)  |  Video  (10)
0%
Deploying and Configuring SSIS Packages
2 hours 1 minute 27 Activities: Article  (0)  |  Lab  (9)  |  Video  (18)
0%
Consuming Data in a Data Warehouse
2 hours 46 minutes 23 Activities: Article  (0)  |  Lab  (9)  |  Video  (14)
0%
Course Conclusion: GK6554A Implementing a Data Warehouse with Microsoft SQL Server 2014
2 minutes 1 Activity: Article  (0)  |  Lab  (0)  |  Video  (1)
0%
Knowledge Assessment: 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)