20767: Implementing a SQL Data Warehouse

This five-day instructor-led course provides students with the knowledge and skills to provision a Microsoft SQL Server database. The course covers SQL Server provision both on-premise and in Azure, and covers installing from new and migrating from an existing install. This course describes how to implement a data warehouse platform to support a BI solution.…

20762: Developing SQL Databases

This five-day instructor-led 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.

20761: Querying Data with Transact-SQL

This course is designed to introduce students to Transact-SQL. It is designed in such a way that the first three days can be taught as a course to students requiring the knowledge for other courses in the SQL Server curriculum. Days 4 & 5 teach the remaining skills required to take exam 70-761.

DP-203: Data Engineering on Microsoft Azure

In this course, the student will learn about the data engineering patterns and practices as it pertains to working with batch and real-time analytical solutions using Azure data platform technologies. Students will begin by understanding the core compute and storage technologies that are used to build an analytical solution. They will then explore how to…

Azure Synapse Analytics | 1-day Workshop

Cloud Analytics in the Age of Self-Service Data Science This Azure Synapse Analytics Training 1-day workshop is an Azure Synapse (DW) focused event with technical labs for the Azure Synapse Modern Data Warehouse inside the Azure Synapse platform. You will learn about the main concepts related to the Azure Synapse Data Warehouse pool. We’ll demo…

Power BI Developer-in-a-Day Workshop

Power BI Developer in a Day workshop is an accelerated one-day online training class designed to teach experienced developers how to program with the Power BI Service API and to embed Power BI reports and dashboard into their custom applications. This workshop uses a classroom training format which includes lectures, instructor demos and hands-on lab…

Power BI Developer Bootcamp

Power BI Developer Bootcamp is an intensive 4-day instructor-led training course with hands-on labs designed to get professional software developers up to speed on developing custom software solutions for Power BI. This course assumes that students already have experience with Power BI Desktop and the Power BI Service and are looking for ways to move…

Power BI Certification Bootcamp

Power BI Certification Bootcamp is an advanced 3-day training class designed to prepare students to pass Microsoft certification exam 70-778: Analyzing and Visualizing Data with Microsoft Power BI. During the course, students will gain the real-world skills required to design, deploy, upgrade and monitor reporting and dashboard solutions using the rapidly-evolving Power BI platform. All…

Developing with Power BI Embedding

Developing with Power BI Embedding is a hands-on workshop designed to teach experienced developers how to embed Power BI reports and dashboard into their custom applications. This workshop uses a two-day, fast-paced format which includes lectures, instructor demos and hands-on lab exercises. By completing the lab exercises in this workshop, attendees will gain hands-on experience…

Building Business Solutions with PowerApps and Flow

Building Business Solutions with Power Apps and Flow is an intensive 3-day training class designed for people who have already attended the Microsoft App-in-a-Day (AIID) training and are ready to move their PowerApps and Flow skills to the next level. Students will learn best practices for building canvas apps and flows to update and manage…

Power BI Bootcamp

Power BI is Microsoft’s amazing data preparation and visualization tool. It is seemingly so simple, but looks can be deceiving. Hidden beneath an easy tool are amazing abilities to clean data, organize data, calculate data, and present that data in a logical and simple matter. In this class, we seek to unlock all the power…

Power BI for Developers

In this code-heavy, instructor-led course, developers will discover and experience the potential of Microsoft Power BI, the Power BI REST API, and Power BI Embedded, as it relates to providing business intelligence and reporting insight for organizations. This fast-paced course focuses heavily on real-world, organization and enterprise data and report integration, including concepts relating to…