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.

M10986 – Updating Your Skills to SQL Server 2016

Update your SQL Server skills with this introduction to the new features of SQL Server 2016. You will learn the new features for performance, security, availability and scalability, reporting and Power BI, data access, and SQL Server OLAP, and you’ll learn about new SQL Server cloud functionality.

  • In-class
  • Instructor Led Online
Enroll Now

M20412 – Configuring Advanced Windows Server Services

In this course, students will gain the skills and knowledge necessary to implement a core Windows Server, including Windows Server R2 infrastructure in an existing enterprise environment. Students will also learn the advanced configuration and services tasks needed to implement, manage, and maintain a Windows Server infrastructure. This course will also cover advanced networking services, Active Directory Domain Services (AD DS), identity management, rights management, Federated services, network load balancing, failover clustering, business continuity, and disaster recovery.

  • In-class
  • Instructor Led Online
Enroll Now

M20413 – Designing and Implementing a Server Infrastructure

In this course, students will gain the skills and knowledge needed to plan, design, and deploy a physical and logical Windows Server 2012 R2 infrastructure. Students will develop the skills needed to provide an enterprise solution that supports manual and automated server installations in physical and virtual environments including the supporting file and storage services. Students will also learn the skills necessary to provide enterprise networking solutions such as DHCP, IPAM, VPN,and DirectAccess. Discover how to design and implement a forest and domain infrastructure including multi domains/forest and branch office scenarios.

This course incorporates material from the Microsoft Official Course 20413 and will help you prepare for Exam 70-413: Designing and Implementing a Server Infrastructure.

Related Certifications:

MCSE: Cloud Platform and Infrastructure

  • Instructor Led Online
Enroll Now

M20414 – Implementing an Advanced Server Infrastructure

In this course, students will learn how to plan, design, and deploy physical and logical Windows Server 2012 R2 enterprise environments. Students will acquire the knowledge and skills to plan and implement a highly available, secure infrastructure with focus on Active Directory Federation Service (AD FS), public key infrastructure (PKI), and Active Directory Rights Management Services (AD RMS). Students will also learn how to plan and deploy virtual machines including self-service and automation of virtual machine deployments as well as planning and implementing a monitoring strategy that includes Microsoft System Center 2012 R2-Operations Manager.

This course incorporates material from the Microsoft Official Course 20414 and will help prepare for Exam 70-414: Implementing an Advanced Server Infrastructure.

Related Certifications:

MCSE: Cloud Platform and Infrastructure

  • In-class
  • Instructor Led Online
Enroll Now

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
Enroll Now

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
Enroll Now

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
Enroll Now

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
Enroll Now

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
Enroll Now

M20486 – Developing ASP.NET Core MVC Web Applications

In this course, students will learn to develop advanced ASP.NET MVC applications using .NET Core tools and technologies. The focus will be on coding activities that enhance the performance and scalability of the Web site application. This course will also prepare the student for exam 70-486.

This course uses Microsoft Visual Studio 2017. It incorporates material from the Official Microsoft Learning Product 20486: Developing ASP.NET MVC 4 Web Applications and can assist students in their preparation for Exam 70-486.

Related Certifications:

MCSA: Web Applications

  • In-class
  • Instructor Led Online
Enroll Now