Learn more about SQL Server tools

mssqltips logo
 

Tutorials          DBA          Dev          BI          Career          Categories          Webcasts          Whitepapers          Today's Tip          Join

Tutorials      DBA      Dev      BI      Categories      Webcasts

DBA    Dev    BI    Categories

 

Microsoft Professional Program (MPP) Overview


By:   |   Last Updated: 2017-12-13   |   Comments (1)   |   Related Tips: More > Professional Development Certifications

Problem

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?

Solution

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:

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:

Videos

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:



Last Updated: 2017-12-13


next webcast button


next tip button



About the author
MSSQLTips author Daniel Calbimonte Daniel Calbimonte is a Microsoft SQL Server MVP, Microsoft Certified Trainer and Microsoft Certified IT Professional.

View all my tips
Related Resources




Post a comment or let the author know this tip helped.

All comments are reviewed, so stay on subject or we may delete your comment. Note: your email address is not published. Required fields are marked with an asterisk (*).

*Name    *Email    Email me updates 


Signup for our newsletter
 I agree by submitting my data to receive communications, account updates and/or special offers about SQL Server from MSSQLTips and/or its Sponsors. I have read the privacy statement and understand I may unsubscribe at any time.



    



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

 

For those interested, I've blogged about my experiences with the MPP Program for Data Science: http://sqlkover.com/mpp-the-finishline/


Learn more about SQL Server tools