Microsoft Data Management & Analytics Training

Demonstrate Your Microsoft Business Intelligence Expertise

Microsoft's Data Management & Analytics certifications demonstrate your expertise in SQL Server and Microsoft Business Intelligence (BI) solutions. Click here to view detailed certification information on Microsoft's website.


Prepare for Microsoft Data Management & Analytics Certifications with Learning Tree
Learning Tree can help you prepare for the following certification exams in the Data Management & Analytics certification path with Microsoft Official Content (MOC) training.

 

MCSA: SQL 2016 Database Administration
The MCSA: SQL 2016 Database Administration certification recognizes your ability to install, maintain, configure, and provision a SQL Server 2016 database. To earn MCSA: SQL 2016 Database Administration certification, you must pass the following two Microsoft exams:

  • 764: Administering a SQL Database Infrastructure
    Prepare for Exam 764 with Learning Tree Course 8422, Administering a SQL Server 2016 Database Infrastructure (20764)

  • 765: Provisioning SQL Databases
    Prepare for Exam 765 with Learning Tree Course 8423, Provisioning SQL Server 2016 Databases (20765)

 

MCSA: SQL 2016 Database Development
The MCSA: SQL 2016 Database Development certification validates your expertise in managing on-premise and cloud-based SQL Server 2016 databases. To earn MCSA: SQL 2016 Database Development certification, you must pass the following two Microsoft exams:

  • 761: Querying Data with Transact-SQL
    Prepare for Exam 761 with Learning Tree Course 8420, Querying SQL Server 2016 Data with Transact-SQL (20761)

  • 762: Developing SQL Databases
    Prepare for Exam 762 with Learning Tree Course 8421, Developing SQL Server 2016 Databases (20762)

 

MCSA: SQL 2016 BI Development
The MCSA: SQL 2016 BI Development certification demonstrates your skills in implementing BI solutions with SQL Server 2016. To earn MCSA: SQL 2016 BI Development certification, you must pass the following two Microsoft exams:

  • 767: Implementing a SQL Data Warehouse
    Prepare for Exam 767 with Learning Tree Course 8424, Implementing a SQL Server 2016 Data Warehouse (20767)

  • 768: Developing SQL Data Models
    Prepare for Exam 768 with Learning Tree Course 8425, Developing SQL Server 2016 Data Models (20768)

 

MCSA: SQL Server 2012/2014
The MCSA: SQL Server 2012/2014 certification validates your ability to manage database solutions using SQL server 2012/2014. To earn MCSA: SQL Server 2012/2014 certification, you must pass the following three Microsoft exams:

  • 461: Querying Microsoft SQL Server 2012/2014
    Prepare for Exam 461 with Learning Tree Course 8463, Querying Microsoft SQL Server 2014 (20461)

  • 462: Administering Microsoft SQL Server 2012/2014 Databases
    Prepare for Exam 462 with Learning Tree Course 8464, Administering Microsoft SQL Server 2014 Databases (20462)

  • 463: Implementing a Data Warehouse with Microsoft SQL Server 2012/2014
    Prepare for Exam 463 with Learning Tree Course 8465, Implementing a Data Warehouse with Microsoft SQL Server 2014 (20463)

 

MCSA: Data Science
The MCSA: Data Science certification your expertise in operationalizing Microsoft Azure machine learning and Big Data with R Server and SQL R Services. To earn MCSA: Data Science certification, you must pass the following two Microsoft exams:

  • 773: Analyzing Big Data with Microsoft R
    Prepare for Exam 773 with Learning Tree Course 8489, Analyzing Big Data with Microsoft R (20773)

  • 774: Perform Cloud Data Science with Azure Machine Learning
    Prepare for Exam 774 with Learning Tree Course 8490, Perform Cloud Data Science with Azure Machine Learning (20774)

 

MCSE: Data Management & Analytics
The MCSE: Data Management & Analytics certification recognizes your mastery of technical concepts in data management and analytics, and qualifies you as a database analyst, designer, or business intelligence professional. To earn MCSE: Data Management & Analytics certification, you must hold one MCSA in the Data Management & Analytics path and pass one additional exam listed below:

Step 1: Earn one MCSA Data Management & Analytics certification:

  • MCSA: SQL 2016 Database Development — Learning Tree offers exam prep for this track
  • MCSA: SQL 2016 Database Administration — Learning Tree offers exam prep for this track
  • MCSA: SQL 2016 BI Development — Learning Tree offers exam prep for this track
  • MCSA: SQL Server 2012/2014 — Learning Tree offers exam prep for this track
  • MCSA: Data Science — Learning Tree offers exam prep for this track
  • MCSA: SQL 2016 BI Reporting
Step 2: Pass one additional exam from the list below:
  • 473: Designing and Implementing Cloud Data Platform Solutions
    Prepare for Exam 473 with Learning Tree Course 8486, Designing and Implementing Cloud Data Platform Solutions (40441)

  • 464: Developing Microsoft SQL Server Databases
    Prepare for Exam 464 with Learning Tree Course 8466, Developing Microsoft SQL Server 2014 Databases (20464)

  • 465: Designing Database Solutions for Microsoft SQL Server
    Prepare for Exam 465 with Learning Tree Course 8467, Designing Solutions for Microsoft SQL Server 2014 (20465)

  • 466: Implementing Data Models and Reports with Microsoft SQL Server
    Prepare for Exam 466 with Learning Tree Course 8468, Implementing Data Models and Reports with Microsoft SQL Server 2014 (20466)

  • 467: Designing Business Intelligence Solutions with Microsoft SQL Server
    Prepare for Exam 467 with Learning Tree Course 8469, Designing Business Intelligence Solutions with Microsoft SQL Server 2014 (20467)

  • 773: Analyzing Big Data with Microsoft R
    Prepare for Exam 773 with Learning Tree Course 8489, Analyzing Big Data with Microsoft R (20773)

  • 774: Perform Cloud Data Science with Azure Machine Learning
    Prepare for Exam 774 with Learning Tree Course 8490, Perform Cloud Data Science with Azure Machine Learning (20774)

  • 775: Perform Data Engineering on Microsoft Azure HDInsight
    Prepare for Exam 775 with Learning Tree Course 8491, Perform Data Engineering on Microsoft HDInsight (20775)

  • 778: Analyzing and Visualizing Data with Power BI
    Prepare for Exam 778 with Learning Tree Course 8430, Analyzing Data with Power BI (20778)

  • Additional exam options offered by Microsoft:
    • 475: Designing and Implementing Big Data Analytics Solutions

All Learning Tree MOC courses are SATV-eligible. Click to learn more.

Related Certifications

Microsoft App Builder Training

Earn Microsoft App Builder certifications: MCSD App Builder and more.

Learn More

Microsoft Cloud Platform Certifications

Validate your Cloud, SaaS, and Azure expertise with Cloud Platform certifications.

 

Learn More

Microsoft Productivity Certifications

Deploy cloud and hybrid solutions with Microsoft Productivity certifications.

 

Learn More

Microsoft Mobility Certifications

Become an expert in mobility management solutions with Microsoft Mobility certifications.

 

Learn More

Additional Professional Certifications

<p>Certified Ethical Hacker (CEH)</p>

Certified Ethical Hacker (CEH)

Beat hackers at their own game with

EC-Council CEH certification.

 

Learn More

<p>Certified Information Security Manager (CISM)</p>

Certified Information Security Manager (CISM)

Enhance your information security management skills with CISM® certification.

 

Learn More

<p>Certified Network Defender (CND)</p>

Certified Network Defender (CND)

Adeptly defend against network attacks with

EC-Council CND certification.

 

Learn More

Please Choose a Language

Canada - English

Canada - Français