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

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

M20467 – Designing Business Intelligence Solutions with Microsoft SQL Server 2014

In this course, students will learn how to design, implement, and maintain a Business Intelligence (BI) platform with Microsoft SQL Server 2014. 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

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