{"product_id":"implementing-a-sql-server-2016-data-warehouse-20767","title":"Implementing a SQL Data Warehouse Training (20767)","description":"\u003cdiv\u003e\n\u003cp\u003eThis five-day instructor-led 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.\u003c\/p\u003e\r\n\r\n\u003cp\u003ePlus, get prepped for Microsoft exam 70-767, a requirement for MCSA: SQL 2016 BI Development and MCSE: Data Management and Analytics.\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 the key elements of a data warehousing solution\u003c\/li\u003e\r\n\t\u003cli\u003eDescribe the main hardware considerations for building a data warehouse\u003c\/li\u003e\r\n\t\u003cli\u003eImplement a logical design for a data warehouse\u003c\/li\u003e\r\n\t\u003cli\u003eImplement a physical design for a data warehouse\u003c\/li\u003e\r\n\t\u003cli\u003eCreate columnstore indexes\u003c\/li\u003e\r\n\t\u003cli\u003eImplementing an Azure SQL Data Warehouse\u003c\/li\u003e\r\n\t\u003cli\u003eDescribe the key features of SSIS\u003c\/li\u003e\r\n\t\u003cli\u003eImplement a data flow by using SSIS\u003c\/li\u003e\r\n\t\u003cli\u003eImplement control flow by using tasks and precedence constraints\u003c\/li\u003e\r\n\t\u003cli\u003eCreate dynamic packages that include variables and parameters\u003c\/li\u003e\r\n\t\u003cli\u003eDebug SSIS packages\u003c\/li\u003e\r\n\t\u003cli\u003eDescribe the considerations for implement an ETL solution\u003c\/li\u003e\r\n\t\u003cli\u003eImplement Data Quality Services\u003c\/li\u003e\r\n\t\u003cli\u003eImplement a Master Data Services model\u003c\/li\u003e\r\n\t\u003cli\u003eDescribe how you can use custom components to extend SSIS\u003c\/li\u003e\r\n\t\u003cli\u003eDeploy SSIS projects\u003c\/li\u003e\r\n\t\u003cli\u003eDescribe BI and common BI scenarios\u003c\/li\u003e\r\n\u003c\/ul\u003e\r\n\u003c\/div\u003e\u003cdiv\u003e\n\u003cul class=\"accordion\"\u003e\r\n\t\u003cli\u003e\r\n\t\u003ch3\u003eOn-Demand Training Description\u003c\/h3\u003e\r\n\r\n\t\u003cdiv\u003e\r\n\t\u003cp\u003eWith a blend of video, text, hands-on labs, and knowledge checks, you will receive the same high quality content as the live event, but you can attend on your own time, at your own pace.\u003c\/p\u003e\r\n\r\n\t\u003cp\u003ePLUS, we include access to a Microsoft Certified Trainer (MCT) to help you prepare for your certification exam and help you apply your new skills immediately… Learning Tree knows how to bring learning to life!\u003c\/p\u003e\r\n\r\n\t\u003cul\u003e\r\n\t\t\u003cli\u003eFlexibility to take the course on your own time, at your own pace\u003c\/li\u003e\r\n\t\t\u003cli\u003eForever access to the digital course materials – for any refreshers\u003c\/li\u003e\r\n\t\t\u003cli\u003eYou will receive a code with your purchase.The code may be redeemed for online access to this On Demand course for up to six months\u003c\/li\u003e\r\n\t\t\u003cli\u003eUpon course activation, the MOC On Demand videos and labs are available for three months\u003c\/li\u003e\r\n\t\t\u003cli\u003e2 FREE hours of individual coaching from an MCT Learning Tree Instructor\u003c\/li\u003e\r\n\t\t\u003cli\u003eThis delivery is also eligible for Microsoft Assurance Training Vouchers (SATVs)\u003c\/li\u003e\r\n\t\t\u003cli\u003e\n\u003cb\u003eNOTE:\u003c\/b\u003e Only live, in-class training is eligible for NASBA CPEs; on-demand training is not eligible for CPE credit\u003c\/li\u003e\r\n\t\u003c\/ul\u003e\r\n\t\u003c\/div\u003e\r\n\t\u003c\/li\u003e\r\n\t\u003cli\u003e\r\n\t\u003ch3\u003eRequirements\u003c\/h3\u003e\r\n\r\n\t\u003cdiv\u003e\r\n\t\u003cul\u003e\r\n\t\t\u003cli\u003eIn addition to their professional experience, students who attend this training should already have the following technical knowledge:\r\n\t\t\u003cul\u003e\r\n\t\t\t\u003cli\u003eAt least 2 years’ experience of working with relational databases, including:\u003c\/li\u003e\r\n\t\t\t\u003cli\u003eDesigning a normalized database\u003c\/li\u003e\r\n\t\t\t\u003cli\u003eCreating tables and relationships\u003c\/li\u003e\r\n\t\t\t\u003cli\u003eQuerying with Transact-SQL\u003c\/li\u003e\r\n\t\t\t\u003cli\u003eSome exposure to basic programming constructs (such as looping and branching)\u003c\/li\u003e\r\n\t\t\t\u003cli\u003eAn awareness of key business priorities such as revenue, profitability, and financial accounting is desirable\u003c\/li\u003e\r\n\t\t\u003c\/ul\u003e\r\n\t\t\u003c\/li\u003e\r\n\t\u003c\/ul\u003e\r\n\t\u003c\/div\u003e\r\n\t\u003c\/li\u003e\r\n\t\u003cli\u003e\r\n\t\u003ch3\u003eExam Information\u003c\/h3\u003e\r\n\r\n\t\t\u003cdiv\u003e\r\n\t\u003cp\u003eThis course can help you prepare for the following Microsoft certification exam — \u003ca href=\"https:\/\/www.microsoft.com\/en-us\/learning\/exam-70-767.aspx\" target=\"_blank\"\u003e70-767: Implementing a Data Warehouse using SQL\u003c\/a\u003e\u003c\/p\u003e\r\n\t\u003c\/div\u003e\r\n\t\u003c\/li\u003e\r\n\t\u003cli\u003e\r\n\t\u003ch3\u003eRedeem Your Microsoft Training Vouchers (SATV):\u003c\/h3\u003e\r\n\r\n\t\u003cdiv\u003e\r\n\t\u003cul\u003e\r\n\t\t\u003cli\u003eThis course is eligible for Microsoft Software Assurance Training Voucher (SATV) redemption.\u003c\/li\u003e\r\n\t\t\u003cli\u003eWant to learn more about Microsoft SATVs? \u003ca href=\"https:\/\/www.learningtree.com\/tuition\/microsoft-training-vouchers\" target=\"”_blank”\"\u003e\u003cstrong\u003eClick to view our SATVs infographic.\u003c\/strong\u003e\u003c\/a\u003e\n\u003c\/li\u003e\r\n\t\u003c\/ul\u003e\r\n\t\u003c\/div\u003e\r\n\t\u003c\/li\u003e\r\n\u003c\/ul\u003e\r\n\u003c\/div\u003e","brand":"Microsoft","offers":[{"title":"204I31US \/ 2020-04-30T09:00:00 \/ Online","offer_id":31395023782006,"sku":"US-8424","price":895.0,"currency_code":"USD","in_stock":true},{"title":"205G29US \/ 2020-05-31T09:00:00 \/ Online","offer_id":31395023880310,"sku":"US-8424","price":895.0,"currency_code":"USD","in_stock":true},{"title":"207F65US \/ 2020-07-03T09:00:00 \/ Online","offer_id":31395023945846,"sku":"US-8424","price":895.0,"currency_code":"USD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0082\/9115\/6086\/products\/sql-server-logo_9c38b0a5-d902-4f69-ae6e-e35c7eb97dd1.png?v=1542048764","url":"https:\/\/ltreetheta.myshopify.com\/products\/implementing-a-sql-server-2016-data-warehouse-20767","provider":"Learning Tree International","version":"1.0","type":"link"}