Loading...

Microsoft Courses

* Courses listed below can also be customized based on user demandDon't see a course that you are looking for?
Click Here to Request It.

M20762 – Developing SQL Databases

This course provides students with the knowledge and skills to develop a Microsoft SQL Server database. The course focuses on teaching individuals how to use SQL Server product features and tools related to developing a database.

  • In-class
  • Instructor Led Online
  • Self-Paced Virtual Classroom
Register for self-paced course

M20764 – Administering a SQL Database Infrastructure

In this course, professionals who administer and maintain SQL Server databases and who develop applications that deliver content from SQL Server databases will gain the knowledge and skills to administer a SQL server database infrastructure.

This course incorporates material from the Official Microsoft Learning Product 20764: Administering a SQL Database Infrastructure and can assist students in preparing for the 70-764: Administering a SQL Database Infrastructure exam. 

  • In-class
  • Instructor Led Online
  • Self-Paced Virtual Classroom
Register for self-paced course

M20765 – Provisioning SQL Databases

This course provides students with the knowledge and skills to provision a Microsoft SQL Server 2016 database. Students will cover SQL Server 2016 provision both on-premise and in Azure, and installing from new and migrating from an existing install.

This course incorporates material from the Official Microsoft Learning Product 20765: Provisioning SQL Databases, and it can assist students in preparation for Exam 70-765: Provisioning SQL Databases

  • In-class
  • Instructor Led Online
  • Self-Paced Virtual Classroom
Register for self-paced course

M20767 – Implementing a SQL Data Warehouse

In this course, students will learn how to implement a data warehouse platform to support a business intelligence (BI) solution. Students will discover how to create a data warehouse, how to implement extract, transform, and load (ETL) with SQL Server Integration Services (SSIS), and how to validate and cleanse data with Data Quality Services (DQS) and Master Data Services.

This course incorporates material from the Official Microsoft Learning Product 20767: and it can assist students in your preparation for Exam 70-767: Implementing a SQL Data Warehouse.

  • In-class
  • Instructor Led Online
  • Self-Paced Virtual Classroom
Register for self-paced course

M20768 – Developing SQL Data Models

In this course, students will learn about business intelligence (BI) solutions that implement multidimensional databases and create tabular semantic data models for analysis using SQL Server Analysis Services (SSAS).

This course incorporates material from the Official Microsoft Learning Product 20768: Developing SQL Data Models and can assist students in preparing for the 70-768: Developing SQL Data Models exam

  • In-class
  • Instructor Led Online
  • Self-Paced Virtual Classroom
Register for self-paced course

M20778 – Analyzing Data with PowerBI

In this course, students will be introduced to the key concepts in business intelligence (BI), data analysis, and data visualization. Students will discover the capabilities of a self-service BI solution and learn to create a dashboard and Power BI Desktop queries.

  • In-class
  • Instructor Led Online
  • Self-Paced Virtual Classroom
Register for self-paced course

M40516 – Intelligent Analytics Microsoft Cloud Workshop

In this workshop students will learn real-time analytics without IoT. Students will enable intelligent conversation in a machine learning-enabled, real-time chat pipeline and apply analytics to visualize customer sentiment in real-time for hospitals to allow guests to chat with one another and to communicate directly with the concierge.

  • In-class
  • Instructor Led Online

M55144 – SQL Server Performance Tuning and Optimization

In this course, students will learn practical tuning and optimization techniques for SQL Server 2014 that include indexing and statistics strategies, transaction log operations, tempdb and data file configuration, transaction and isolation levels, locking and blocking, and the new In-Memory OLTP engine. Students will learn how to create baselines and benchmark SQL Server performance as well as analyze and fix workload for performance issues.

  • Instructor Led Online

PPPQ16: Power Pivot and Power Query for Excel 2016

This course teaches students the add-ins that expand and combine the features and capabilities of Excel. Students will learn PowerPivot, Power Query, Power View, 3D maps and their features. Students will also learn how to import, manipulate and work with large amounts of data from a variety of data sources both inside and outside Excel. Students will learn the techniques for manipulating querying data, the structure of DAX functions, ways to distribute and visualize data using Pivot Charts, Slicers, Sparklines, Timelines, Power View and 3D maps.

  • In-class
  • Instructor Led Online