{"product_id":"implementing-a-sql-server-2016-data-warehouse-20769","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":"208A55CN \/ 2020-08-17T09:00:00 \/ Toronto","offer_id":30687005704310,"sku":"US-8424-GOVT-IL","price":2833.0,"currency_code":"USD","in_stock":true},{"title":"209B10US \/ 2020-09-28T09:00:00 \/ Herndon","offer_id":30687005737078,"sku":"US-8424-GOVT-IL","price":2833.0,"currency_code":"USD","in_stock":true},{"title":"20AD02US \/ 2020-10-19T09:00:00 \/ New York","offer_id":31395120971894,"sku":"US-8424-GOVT-IL","price":2833.0,"currency_code":"USD","in_stock":true},{"title":"206A86CN \/ 2020-06-15T09:00:00 \/ Online","offer_id":31612681846902,"sku":"US-8424-GOVT-IL","price":2833.0,"currency_code":"USD","in_stock":true},{"title":"207J05US \/ 2020-07-13T09:00:00 \/ San Francisco","offer_id":31612681879670,"sku":"US-8424-GOVT-IL","price":2833.0,"currency_code":"USD","in_stock":true},{"title":"20BF83US \/ 2020-11-02T09:00:00 \/ Seattle","offer_id":31612681912438,"sku":"US-8424-GOVT-IL","price":2833.0,"currency_code":"USD","in_stock":true},{"title":"20CA66CN \/ 2020-12-07T09:00:00 \/ Ottawa","offer_id":31612681977974,"sku":"US-8424-GOVT-IL","price":2833.0,"currency_code":"USD","in_stock":true},{"title":"211D50US \/ 2021-01-11T09:00:00 \/ San Francisco","offer_id":31612682010742,"sku":"US-8424-GOVT-IL","price":2833.0,"currency_code":"USD","in_stock":true},{"title":"212A29CN \/ 2021-02-01T09:00:00 \/ Toronto","offer_id":31612682043510,"sku":"US-8424-GOVT-IL","price":2833.0,"currency_code":"USD","in_stock":true},{"title":"213A82US \/ 2021-03-22T09:00:00 \/ Herndon","offer_id":31612682076278,"sku":"US-8424-GOVT-IL","price":2833.0,"currency_code":"USD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0082\/9115\/6086\/products\/sql-server-logo_b36d7809-f302-4e94-a913-c948b9ebe3f7.png?v=1542048748","url":"https:\/\/ltreetheta.myshopify.com\/products\/implementing-a-sql-server-2016-data-warehouse-20769","provider":"Learning Tree International","version":"1.0","type":"link"}