Microsoft Professional Program (MPP) Overview

By:   |   Comments (1)   |   Related: More > Professional Development Certifications


I am a fan of your certification series and heard about the Microsoft Professional Program.  I have a bunch of questions about the program to see if it can help my career. Can you help me better understand the program?


Of course, at MSSQLTips, we are here to help.  What are your questions?

What is the Microsoft Professional Program (MPP)?

It is a special recognition for professionals for specific jobs. It is composed of several courses and it offers a diploma.

Is this course free?

The course is free, but the diploma is not.

What is the difference between a Microsoft Certification and this MPP?

The Microsoft certification is a specialized exam for a specific technology. The MPP is composed of multiple courses in different areas.

MPP is faster to learn and to study. The Microsoft certifications are more complex and difficult. It usually takes longer time to be certified.

What are the different MPPs?

At the time of writing, here are the following programs:

How many courses are there for Big Data?

You need to pass these 10 courses:

  1. Microsoft Professional Orientation: Big Data
  2. Analyzing and Visualizing Data with Excel or Analyzing and Visualizing Data with Power BI
  3. Introduction to NoSQL Data Solutions
  4. Querying Data with Transact-SQL
  5. Delivering a Data Warehouse in the Cloud
  6. Processing Big Data with Azure Data Lake Analytics or Processing Big Data with Hadoop in Azure HDInsight
  7. Processing Real-Time Data Streams in Azure or Implementing Real-Time Analytics with Azure HDInsight
  8. Orchestrating Big Data with Azure Data Factory
  9. Developing Big Data Solutions with Azure Machine Learning or Analyzing Big Data with Microsoft R Server or Implementing Predictive Solutions with Spark in HDInsight
  10. Microsoft Professional Capstone : Big Data

Are these courses difficult?

Most of the courses can be found on the MVA site. There are great instructors and the explanations are simple. The samples are very useful.

These courses are not complex or difficult.

How many hours are required per course?

Each course takes between 8-12 hours.

How can I enroll in a course?

Go to the MPP site and press the "Enroll Now" button for the program of your preference:

Microsoft courses

Most of the programs require two courses. You will need to press the "Enroll Now" button again:

Courses and hours required

What sections does the course contain?

You will have the course that contains videos and assessment labs:

Query course

You can optionally pursue a verified certificate that is $99 USD:

Verified Certificate

You will also be able to see a brief explanation about the course:

Brief course description

You also can see what you will learn in the course:

What you will learn

There is also some information about the instructors:


If you click on the instructors, you will see detailed information about them and the courses taught:

Couses taught by the instructor

What is an edX account?

This program is related to edX. EdX is an online learning site founded by Harvard and MIT. You can create your edX account using Facebook, G+ or a Microsoft account:

Create account using Facebook, Google or Microsoft account

What is the audit course option and the certified option in these courses?

You have two options, to pursue a verified certificate or to audit this course. The second option is free, and you do not need to pay, but no certificate is provided:

Verified certificate and no certificate option

What are the lessons?

You have modules with videos and then a lab:

Module 1-2

The lessons are simple videos in YouTube. You can download or activate the transcriptions. The lessons are simple and very clear:


You will also have access to the Key Points of the modules:

Key points and additional reading

You also have labs:

Labs and assesments.

In the labs you will have access to multiple exercises:

Exercises and labs

The exercises contain instructions. For example, for T-SQL you can run queries and verify the results, submit answers:

Question and code

You can use fast keys and submit answers.

Submiting answer

What is the Microsoft Professional Capstone?

It is the last course where you will have different challenges. You have time assigned to accomplish the challenges with real world problems.

Microsoft Professional Capsotne: Data science

Are these courses only in English?

Yes, they are in English only.

Next Steps

For more information about MPP, refer to these links:

sql server categories

sql server webinars

subscribe to mssqltips

sql server tutorials

sql server white papers

next tip

About the author
MSSQLTips author Daniel Calbimonte Daniel Calbimonte is a Microsoft SQL Server MVP, Microsoft Certified Trainer and 6-time Microsoft Certified IT Professional. Daniel started his career in 2001 and has worked with SQL Server 6.0 to 2022. Daniel is a DBA as well as specializes in Business Intelligence (SSIS, SSAS, SSRS) technologies.

This author pledges the content of this article is based on professional experience and not AI generated.

View all my tips

Comments For This Article

Wednesday, December 13, 2017 - 9:25:33 AM - Koen Verbeeck Back To Top (73974)


For those interested, I've blogged about my experiences with the MPP Program for Data Science:

get free sql tips
agree to terms