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.…

DP-080: Querying Data with Microsoft Transact-SQL

This course will teach the basics of Microsoft’s dialect of the standard SQL language: Transact-SQL. Topics include both querying and modifying data in relational databases that are hosted in Microsoft SQL Server-based database systems, including: Microsoft SQL Server, Azure SQL Database and, Azure Synapse Analytics.

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…

Intelligent Analytics and Automation with ML & AI

Machine learning products are being used daily, perhaps without realizing it. The future of machine learning is already here, so gearing yourself up with machine learning skills is a good move now. You and your teams can use Artificial Intelligence to deliver value to your customers. You too can build and deploy machine learning products…

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…

AI-102: Designing and Implementing a Microsoft Azure AI Solution

Gain the necessary knowledge for designing Azure AI solutions by building a customer support chat Bot using artificial intelligence from the Microsoft Azure platform including language understanding and pre-built AI functionality in the Azure Cognitive Services. *AI-102: Designing and Implementing a Microsoft Azure AI Solution replaced AI-100: Designing and Implementing a Microsoft Azure AI Solution…

DP-201: Designing an Azure Data Solution

In this course, the students will design various data platform technologies into solutions that are in line with business \and technical requirements. This can include on-premises, cloud, and The students will also explore how to design data security including data access, data policies and standards. They will also design Azure data solutions which includes the…

DP-200: Implementing an Azure Data Solution

In this course, the students will implement various data platform technologies into solutions that are in line with business and technical requirements including on-premises, cloud, and hybrid data scenarios incorporating both relational and No-SQL data. They will also learn how to process data using a range of technologies and languages for both streaming and batch…

AI-100: Designing and Implementing an Azure AI Solution

An Azure AI engineer works with Data Engineers and Data Scientists to analyze requirements for AI cloud-based and hybrid AI solutions and implements solutions. They are aware of the various components that make up the Microsoft Azure AI portfolio and related open source frameworks and technologies. The engineer leverages their knowledge to recommend appropriate tools…

DP-100: Designing and Implementing a Data Science Solution on Azure

Data Scientist is the central role in developing machine learning models. This role is responsible for solving the business problem that initiated the project. While the Data Engineer will prepare the data to be used for the models, the Data Scientist determines what data is needed for model training, creates model features from the data,…