VTC Legacy
Home / Certification

Exam 70-768: Developing SQL Data Models

by Mark Long
96 lessons10 chapters8.8 hReleased 20187 free
Start the free chapter

Business Intelligence is one of the most in-demand aspects of Information Technology. As data continues to drive the entire business process, the ability to collect, manage, and provide fast, efficient access to decision makers throughout the enterprise is a vital function.rnrnMicrosoft's SQL Server Analysis Services provides the tools to create and manage multidimensional cube and tabular data models that make BI data accessible. This course will help you understand and implement SQL Server 2016 data models and will help you in your preparation for Microsoft's 70-768 Developing SQL Data Models certification exam.rnrnYou can achieve an MCSA: SQL 2016 BI Development certification by passing exams 70-768 which is covered in this course, along with exam 70-767, Implementing a SQL Data Warehouse, also available from VTC.rnrnIn this course, Mark Long brings over 20 years of experience with SQL Server along to help you get acquainted with SQL Server 2016 and help you get prepared to take the 70-768 exam.

Course content

Welcome/Intro7 lessons
SQL Server 2016 Essentials7 lessons
Installing SQL Server12 lessons
Data Marts and Warehouses17 lessons
SQL Server Analysis Services9 lessons
Multidimensional Cubes22 lessons
Multidimensional Queries5 lessons
Tabular Data Modeling15 lessons
Course Wrap-Up1 lessons
Credits1 lessons