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.

M20462 – Administering Microsoft SQL Server 2014 Databases

In this course, students will learn the skills required to maintain a Microsoft SQL Server 2012 or 2014 database by focusing on data storage, backup and restoration, importing and exporting data, security, database maintenance and the SQL Server Agent.

This course incorporates material from the Official Microsoft Learning Product 20462: Administering Microsoft SQL Server 2014 Databases. It covers the skills and knowledge measured by Exam 70-462 and along with on-the-job experience, helps students prepare for the exam.

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

M20463 – Implementing a Data Warehouse with Microsoft SQL Server 2014

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

This course is designed for students interested in learning SQL Server 2012 or SQL Server 2014. It covers the new features of SQL Server 2014 as well as the important capabilities across the SQL Server data platform.

This course incorporates material from the Official Microsoft Learning Product 20463: Implementing a Data Warehouse with Microsoft SQL Server 2014. It covers the skills and knowledge measured by Exam 70-463 and along with on-the-job experience, helps you prepare for the exam.

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

M20466 – Implementing Data Models and Reports with Microsoft SQL Server 2014

In this course, students will learn the tools needed to create managed enterprise business intelligence (BI) solutions. Students will learn about data modeling by creating multidimensional databases, cubes and dimensions, measures and measure groups, MDX fundamentals, analysis services, and Data Analysis Expressions (DAX). Students will then learn how to create and publish reports using reporting services, report execution and delivery, SharePoint PerformancePoint Services, and data mining.

This course is designed for those interested in learning SQL Server 2012 or 2014 and covers the new features in SQL Server 2014 as well as the important capabilities across the SQL Server data platform.

This course incorporates material from the Official Microsoft Learning Product 20466: Implementing Data Models and Reports with Microsoft SQL Server. It covers the skills and knowledge measured by Exam 70-466 and along with on-the-job experience, helps you prepare for the exam.

  • In-class
  • Instructor Led Online

M20467 – Designing Business Intelligence Solutions with Microsoft SQL Server

In this course, students will learn how to design, implement, and maintain a Business Intelligence (BI) platform with Microsoft SQL Server. Students will learn to design a data warehouse and Business Intelligence solutions including: ETL, BI Delivery, Reporting Services, Excel Reporting, SharePoint Server BI along with how to monitor and optimize a BI solution.

Students will learn big data concepts and analysis using Microsoft Azure HDInsight plus how to design, implement, and process big data solutions.

This course incorporates material from the Official Microsoft Learning Product 20467: Designing Business Intelligence Solutions with Microsoft SQL Server 2014. This course maps to skills and knowledge measured by Microsoft exam 70-467, and in conjunction with on-the-job experience, can help prepare students for the exam.

  • In-class
  • Instructor Led Online

M20532 – Developing Microsoft Azure Solutions

In this course, students will learn how to build web applications. Students should also have experience with the Microsoft Azure platform and a basic understanding of the services offered in Azure.

This course offers students the opportunity to take an existing web application and expand its functionality as part of moving it to Azure. The course does not require any existing experience with the ASP.NET platform but does require experience with C#. This course focuses on the development considerations and decisions necessary when building a highly available solution in the cloud. This course also prepares the students for the 70-532: Developing Microsoft Azure Solutions certification exam.

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

M20533 – Implementing Microsoft Azure Infrastructure Solutions

In this course, students will learn how to provision and manage services in Microsoft Azure. Learn how to implement infrastructure components such as virtual networks, virtual machines, containers, web and mobile apps, and storage in Azure. Students will also review how to plan for and manage Azure AD, and configure Azure AD integration with on-premises Active Directory domains.

This course incorporates materials from the Official Microsoft Learning Product 20533 and can assist students in their preparation for Exam 70-533: Implementing Microsoft Azure Infrastructure Solutions.

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

M20535 – Architecting Microsoft Azure Solutions

This course is intended for architects who have experience building infrastructure and applications on the Microsoft Azure platform.  Students should have a thorough understanding of most services offered on the Azure platform. The students typically work for organizations that have an active solution on Azure and are planning to enhance existing solutions or deploy more solutions to the Azure platform. This course also is intended for architects who want to take the Microsoft Certification exam, 70-535, Architecting Microsoft Azure Solutions.

This course incorporates materials from the Official Microsoft Learning Product 20535 and can assist you in your preparation for Exam 70-535: Architecting Microsoft Azure Solutions.

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

M20761 – Querying Data with Transact-SQL

Learn how to write basic Transact-SQL queries for Microsoft SQL Server 2016. This course will provide a good understanding of the Transact-SQL language which is used by all SQL Server-related disciplines—namely, database administration, database development, and business intelligence.

Students will learn about: T-SQL elements, writing SQL queries, querying JOINs, sorting and filtering data, SQL Server 2016 data types, T-SQL DML, built-in functions, grouping and aggregating data, subqueries, and set operators.

This course incorporates material from the Official Microsoft Learning Product 20761: Querying Data with Transact-SQL.

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

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