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.

20762C – 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

20768: Developing SQL Data Models

This course teaches students how to implement both multidimensional and tabular data models by using SQL Server Analysis Services. Students will also learn how to create cubes, dimensions, measures, and measure groups as well as the components, architecture and nature of a BI solution.

  • In-class
  • Instructor Led Online

Building a Serverless Data Lake

Building a Serverless Data Lake is a one-day, advanced-level bootcamp designed to teach student how to design, build, and operate a serverless data lake solution with AWS services. The bootcamp will include topics such as ingesting data from any data source at large scale, storing the data securely and durably, enabling the capability to use the right tool to process large volumes of data, and understanding the options available for analyzing the data in near-real time.

  • In-class
  • Instructor Led Online

EXC16L3: Microsoft Excel 2016 – Level 3/Advanced

This course teaches students how to analyze and report data frequently as well as work in collaboration with others to deliver actionable insights. Students will learn how to keep and maintain workbooks for all purposes, as well as automate complex or repetitive tasks, and use conditional logic to construct and apply elaborate formulas and functions that will put the power of Excel at their fingertips. Students will also learn how to perform advanced data analysis, and automate workbook functionality.

  • In-class
  • Instructor Led Online

EXCL1: Microsoft Excel – Level 1/Intro (2010, 2013, 2016)

This course teaches students the foundations of Microsoft Office Excel. Students will gain the knowledge and skills to easily create and work with electronic spreadsheets. Students will learn to create, format, and enhance simple spreadsheets, as well as the skills to perform calculations and analyze the data that is critical to the success of their organization.

  • In-class
  • Instructor Led Online

EXCL2: Microsoft Excel – Level 2/Med (2010, 2013, 2016)

This course teaches students some of the higher-level functionality in Excel to analyze and present data. Students will learn how to use formulas and advanced functions, create and format tables, sort and filter, add and format graphics, and protect and finalize their work. Students will also learn to work with functions and lists, create advanced formulas, and work with the custom view. Students will be able to leverage the power of data calculations and presentation in order to make informed, intelligent organizational decisions.

  • In-class
  • Instructor Led Online

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
  • Self-Paced Virtual Classroom
Register for self-paced course

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

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
  • Self-Paced Virtual Classroom
Register for self-paced course

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