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

20778: Analyzing Data with Power BI

The main purpose of the course is to give students a good understanding of data analysis with Power BI. The course includes creating visualizations, the Power BI Service, and the Power BI Mobile App.

  • 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

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