{"product_id":"implementing-a-data-warehouse-with-microsoft-sql-server-2014-20463","title":"Implementing a Data Warehouse with Microsoft SQL Server 2014 (20463)","description":"\u003cdiv\u003e\n\u003cp\u003eThis official Microsoft course describes how to implement a data warehouse platform in SQL Server 2014 to support a BI solution. Students will learn how to create a data warehouse, implement ETL with SQL Server Integration Services, and validate and cleanse data with SQL Server Data Quality Services and SQL Server Master Data Services.\u003c\/p\u003e\r\n\r\n\u003cp\u003eThis course is designed for customers who are interested in learning SQL Server 2012 or SQL Server 2014. It covers the new features in SQL Server 2014, but also the important capabilities across the SQL Server data platform.\u003c\/p\u003e\r\n\r\n\u003cp\u003ePlus, get prepped for Microsoft exam 70-463, a requirement for MCSA: SQL Server 2012\/2014.\u003c\/p\u003e\r\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch3\u003eYou Will Learn How To:\u003c\/h3\u003e\n\u003cul\u003e\r\n\t\u003cli\u003eDescribe data warehouse concepts and architecture considerations.\u003c\/li\u003e\r\n\t\u003cli\u003eSelect an appropriate hardware platform for a data warehouse.\u003c\/li\u003e\r\n\t\u003cli\u003eDesign and implement a data warehouse.\u003c\/li\u003e\r\n\t\u003cli\u003eImplement Data Flow in an SSIS Package.\u003c\/li\u003e\r\n\t\u003cli\u003eImplement Control Flow in an SSIS Package.\u003c\/li\u003e\r\n\t\u003cli\u003eDebug and Troubleshoot SSIS packages.\u003c\/li\u003e\r\n\t\u003cli\u003eImplement an ETL solution that supports incremental data extraction.\u003c\/li\u003e\r\n\t\u003cli\u003eImplement an ETL solution that supports incremental data loading.\u003c\/li\u003e\r\n\t\u003cli\u003eImplement data cleansing by using Microsoft Data Quality Services.\u003c\/li\u003e\r\n\t\u003cli\u003eImplement Master Data Services to enforce data integrity.\u003c\/li\u003e\r\n\t\u003cli\u003eExtend SSIS with custom scripts and components.\u003c\/li\u003e\r\n\t\u003cli\u003eDeploy and Configure SSIS packages.\u003c\/li\u003e\r\n\t\u003cli\u003eDescribe how BI solutions can consume data from the data warehouse.\u003c\/li\u003e\r\n\u003c\/ul\u003e\r\n\u003c\/div\u003e","brand":"Microsoft","offers":[{"title":"204I59US \/ 2020-04-30T09:00:00 \/ Online","offer_id":31395034890358,"sku":"US-8465","price":895.0,"currency_code":"USD","in_stock":true},{"title":"205G57US \/ 2020-05-31T09:00:00 \/ Online","offer_id":31395034923126,"sku":"US-8465","price":895.0,"currency_code":"USD","in_stock":true},{"title":"207G21US \/ 2020-07-03T09:00:00 \/ Online","offer_id":31395034955894,"sku":"US-8465","price":895.0,"currency_code":"USD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0082\/9115\/6086\/products\/sql-server-logo_d9b563e3-8719-4270-a2d8-a70055778532.png?v=1542048621","url":"https:\/\/ltreetheta.myshopify.com\/products\/implementing-a-data-warehouse-with-microsoft-sql-server-2014-20463","provider":"Learning Tree International","version":"1.0","type":"link"}