{"product_id":"developing-sql-server-2016-data-models-20768","title":"Developing SQL Data Models Training (20768)","description":"\u003cdiv\u003e\n\u003cp\u003eThe focus of this 3-day instructor-led course is on creating managed enterprise BI solutions. It describes how to implement both multidimensional and tabular data models and how to create cubes, dimensions, measures, and measure groups. This course helps you prepare for the Exam 70-768.\u003c\/p\u003e\r\n\r\n\u003cp\u003ePlus, get prepped for Microsoft exam 70-768, 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 components, architecture, and nature of a BI solution\u003c\/li\u003e\r\n\t\u003cli\u003eCreate a multidimensional database with analysis services\u003c\/li\u003e\r\n\t\u003cli\u003eImplement dimensions in a cube\u003c\/li\u003e\r\n\t\u003cli\u003eImplement measures and measure groups in a cube\u003c\/li\u003e\r\n\t\u003cli\u003eUse MDX syntax\u003c\/li\u003e\r\n\t\u003cli\u003eCustomize a cube\u003c\/li\u003e\r\n\t\u003cli\u003eImplement a tabular database\u003c\/li\u003e\r\n\t\u003cli\u003eUse DAX to query a tabular model\u003c\/li\u003e\r\n\t\u003cli\u003eUse data mining for predictive analysis\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\u003eThis course requires that you meet the following prerequisites:\r\n\t\t\u003cul\u003e\r\n\t\t\t\u003cli\u003eBasic knowledge of the Microsoft Windows operating system and its core functionality\u003c\/li\u003e\r\n\t\t\t\u003cli\u003eWorking knowledge of Transact-SQL\u003c\/li\u003e\r\n\t\t\t\u003cli\u003eWorking knowledge of relational databases\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\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-768.aspx\" target=\"_blank\"\u003e70-768: Developing SQL Data Models\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":"209B11US \/ 2020-09-09T09:00:00 \/ Herndon","offer_id":30686774952054,"sku":"US-8425-IL","price":2650.0,"currency_code":"USD","in_stock":true},{"title":"206G78US \/ 2020-06-10T09:00:00 \/ Online","offer_id":31612534980726,"sku":"US-8425-IL","price":2650.0,"currency_code":"USD","in_stock":true},{"title":"207D86CN \/ 2020-07-22T09:00:00 \/ Ottawa","offer_id":31612535046262,"sku":"US-8425-IL","price":2650.0,"currency_code":"USD","in_stock":true},{"title":"20CD23US \/ 2020-12-09T09:00:00 \/ Denver","offer_id":31612535079030,"sku":"US-8425-IL","price":2650.0,"currency_code":"USD","in_stock":true},{"title":"211D09CN \/ 2021-01-20T09:00:00 \/ Ottawa","offer_id":31612535111798,"sku":"US-8425-IL","price":2650.0,"currency_code":"USD","in_stock":true},{"title":"213A83US \/ 2021-03-03T09:00:00 \/ Herndon","offer_id":31612535144566,"sku":"US-8425-IL","price":2650.0,"currency_code":"USD","in_stock":true}],"url":"https:\/\/ltreetheta.myshopify.com\/products\/developing-sql-server-2016-data-models-20768","provider":"Learning Tree International","version":"1.0","type":"link"}