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.

M20461 – Querying Microsoft SQL Server 2014

In this course, students will learn the technical skills required to write basic Transact-SQL (T-SQL) queries for Microsoft SQL Server 2014. This is the foundational course for all SQL server related disciplines: database administration, database development and business intelligence. Tools and skills you will learn include: SQL Server Management Studio, T-SQL, SELECT statements in querying multiple tables, data types, data sorting and filtering, data manipulation language (DML), grouping and aggregating data, table expressions, set operators, window functions, T-SQL programming, error handlers, and transaction management in SQL Server.

This course is designed for customers 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 20461: Querying Microsoft SQL Server 2014. It covers the skills and knowledge measured by Exam 70-461 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

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

M20744 – Securing Windows Server 2016

In this course, students will learn how to enhance the security of the IT infrastructure that you administer. This course begins by emphasizing the importance of assuming that network breaches have occurred already and then teaches you how to protect administrative credentials and rights to ensure that administrators can perform the precise tasks they need at any time, when they need to.

Students will learn how to mitigate malware threats, identify security issues by using auditing and the Advanced Threat Analysis feature in Windows Server 2016, secure your virtualization platform, and use new deployment options (such as Nano server and containers) to enhance security.

This course incorporates material from the Official Microsoft Learning Product 20744, and it can assist in preparation for Exam 70-744: Securing Windows Server 2016.

Related Certifications: 

The Microsoft Certified Solutions Expert (MCSE): Cloud Platform and Infrastructure certification validates that you have the skills needed to run a highly efficient and modern data center, with expertise in cloud technologies, identity management, systems management, virtualization, storage, and networking.

Earning an MCSE: Cloud Platform and Infrastructure certification qualifies you for such jobs as cloud administrator, cloud architect, computer support specialist, and information security analyst.

MCSE: Cloud Platform and Infrastructure

  • 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