Professional Course

Developing SQL Data Models (MS-20768)

QuickStart, Online
16 hours
16 hours
This provider usually responds within 48 hours 👍

Course description

Developing SQL Data Models (MS-20768)

About this course

The basic focus of Microsoft training course is help student prepare for Microsoft 70-768: Developing SQL Data Models certification exam. It further focuses on teaching students for developing SQL data models along with this, it also teaches how to execute tabular, multidimensional data models and creating managed enterprise BI solutions, cubes, measures, dimensions and lastly, measure groups. It will also give a detailed view of SQL (Structured Query Language) and data modeling. The data modelling is the procedure of authenticating an intricate software system design as a simple diagram. This diagram is made using symbols and text to represent the flow data required. This very diagram can be utilized as a blueprint for re-structuring a legacy application or for developing a new software. On the other hand, SQL is a programming language for executing various tasks, operating on the data and managing relational databases.

The average salary for Data Engineer with SQL Skills is $82,958 per year.

Do you work at this company and want to update this page?

Is there out-of-date information about your company or courses published here? Fill out this form to get in touch with us.

Who should attend?


The data professional who require to complete BI developer role for developing enterprise BI solution are the main attendees of the course. 
The initial tasks comprise of:

  • Use SQL Server Analysis Services to create tabular semantic models for analysis.
  • Use SQL Analysis Services to implement multidimensional databases. 


The attendees of the course must have knowledge to:

  • Use Transact-SQL for querying data.

Training content

Course Objectives

The attendees of this course will learn to:

  • Use Analysis Services to develop a multidimentional database.
  • Estimate groups in a cube and execute actions.
  • Cube customization.
  • To query tabular model with use of DAX.
  • BI solution’s  structure, component and nature description.
  • Execute dimensions in the cube.
  • Use MDX syntax.
  • Predict analysis with use of data mining.
  • Execute a tabular database.

Why choose QuickStart?

98% increased workplace productivity

94% instructor and course effectiveness

Partnered with vendors including Microsoft, Cisco, and Citrix

Contact this provider

Contact course provider

Before we redirect you to this supplier's website, do you mind filling out this form so that we can stay in touch? You can unsubscribe at any time.
If you want us to recommend other suitable courses, please fill out all fields below and check the box beside "Please recommend similar options"
Country *

reCAPTCHA logo This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.
1101 S Capital of Texas Hwy - Building J, Suite 202
78746 Austin Texas

Meet your career goals with QuickStart!

QuickStart exists to create world-class technologists by personalizing and individualizing training to address the massive skills gap in the IT industry. Through 20 years of research and data analysis, we’ve learned that a modern learner prefers to learn through multiple...

Read more and show all training delivered by this supplier