Explore digital courses

Learn how to build a speech translation app by using Microsoft Power Apps and integrate it with AI.

Units in this learning path:

• Introduction
• Prepare
• Exercise Create Data Model and Canvas App
• Exercise Create Microsoft Azure AI Service
• Exercise Integrate AI Service to Power Apps
• Knowledge Check
• Summary

Products: M365, Azure, Power Platform

Roles: Student, Business User, Developer, Higher Ed Educator

Level: Beginner

Subjects: Data Management

Duration: 166 minutes

Choose the correct HDInsight Configuration to build open source analytics solutions

Units in this learning path:

• 1 Introduction
• 2 Hdinsight Configuration Options
• 3 Decision Criteria Selecting Correct Hdinsight Configuration Option
• 4 Analyze Scenario Map It Hdinsight Configuration Option
• 5 Cost Optimization Strategies Hdinsight Clusters
• 6 Knowledge Check
• 7 Summary

Products: Azure Hdinsight

Roles: Data Engineer, Data Scientist

Level: Beginner

Subjects: Data Analytics

Duration: 40 minutes

Power Query has an incredible number of features that are dedicated to helping you clean and prepare your data for analysis. You'll learn how to simplify a complicated model, change data types, rename objects, and pivot data. You'll also learn how to profile columns so that you know which columns have the valuable data that you’re seeking for deeper analytics.

Units in this learning path:

• 1 Introduction
• 2 Shape Data
• 3 Data Structure
• 4 Column Data Types
• 5 Combine Tables
• 6 Profile Data
• 7 Advanced Editor
• 8 Lab
• 9 Check
• 10 Summary

Products: Power Bi, Power Platform

Roles: Data Analyst

Level: Intermediate

Subjects: Data Analytics

Duration: 121 minutes

Learn how to cleanse, transform, and load data into Unity Catalog tables in Azure Databricks by profiling data, handling duplicates and nulls, applying transformations, and using various loading strategies.

Units in this learning path:

• Introduction
• Profile Data Summary Statistics
• Choose Appropriate Column Data Types
• Resolve Duplicate Missing Null Values
• Transform Data Filter Group Aggregate
• Transform Data Join Union Intersect Except
• Transform Data Denormalize Pivot Unpivot
• Load Data Merge Insert Append
• Knowledge Check
• Summary

Products: Azure Databricks

Roles: Data Engineer

Level: Intermediate

Subjects: Data Engineering

Duration: 56 minutes

Combine multiple tables with JOINs in T-SQL

Units in this learning path:

• Introduction
• Join Concepts
• Inner Joins
• Outer Joins
• Explore Cross Joins
• Self Joins
• Exercise Query with Joins
• Knowledge Check
• Summary

Products: Azure SQL Database, SQL Server, Azure SQL Managed Instance, Azure Sqlserver Vm, Azure SQL Virtual Machines

Roles: Data Analyst, Data Engineer, Data Scientist, Database Administrator, Developer, Solution Architect, Student, Technology Manager

Level: Beginner

Subjects: Databases

Duration: 62 minutes

Combine data across multiple PostgreSQL tables using SQL JOINs. Learn INNER, LEFT, RIGHT, FULL OUTER, and NATURAL joins with real examples.

Units in this learning path:

• Introduction
• Sample Database Overview
• Inner Join
• Left Right Join
• Natural and Full Join
• Summary

Products: Azure Database Postgresql

Roles: Database Administrator, Developer

Level: Beginner

Subjects: Databases

Duration: 18 minutes

Select between the various throughput offerings in Azure Cosmos DB for NoSQL.

Units in this learning path:

• Introduction
• Choose Between Provisioned Throughput Serverless
• Choose Between Standard Autoscale Provisioned Throughput
• Provision Throughput at Container Level
• Provision Throughput at Database Level
• Configure Container Time to Live (ttl) Value
• Exercise Configure Throughput for Azure Portal
• Knowledge Check
• Summary

Products: Azure Cosmos Db

Roles: Developer

Level: Intermediate

Subjects: Data Modeling

Duration: 36 minutes

Configure SQL Server resources for optimal performance

Units in this learning path:

• Introduction
• Explain How to Optimize Azure Storage for Virtual Machines
• Describe Virtual Machine Resizing
• Optimize Database Storage
• Control
• Knowledge Check
• Summary

Products: Azure, Azure SQL Database, SQL Server

Roles: Data Analyst, Data Engineer, Database Administrator

Level: Intermediate

Subjects: Databases

Duration: 35 minutes

Semantic models organize complex data into an intuitive structure, enhancing data visualization and enabling efficient, insightful reporting for better decision-making.

Units in this learning path:

• Introduction
• Relationships
• Tables
• Columns
• Hierarchies
• Measures
• Parameters
• Lab
• Check
• Summary

Products: Power Bi, Fabric

Roles: Data Analyst

Level: Intermediate

Subjects: Data Modeling, Data Analytics

Duration: 80 minutes

Azure Database for PostgreSQL efficiently manages vast quantities of data and their structures through system catalogs and views. This module explores how to optimize database performance by accessing and configuring metadata, understanding the role of the vacuum process in maintaining database health, and managing server settings. We introduce practical techniques to enhance your PostgreSQL database administration, useful in environments requiring robust data handling and security features.

Units in this learning path:

• Introduction
• Understand System Catalog Views
• Investigate Metadata
• Explain Purpose Vacuum Autovacuum
• Configure Autovacuum Server Parameters
• Exercise Configure System Parameter Explore Metadata
• Knowledge Check
• Summary

Products: Azure Database Postgresql

Roles: Database Administrator

Level: Intermediate

Subjects: Databases

Duration: 46 minutes

Azure Database for PostgreSQL is a Platform as a Service database service in the Microsoft cloud. It bases itself on the PostgreSQL open-source relational database and includes built-in high availability, automatic backup and restore, as well as comprehensive security features. The pay-as-you-go pricing model provides predictable performance and near-instant scaling. In this learning path, you're introduced to the main features of PostgreSQL and how they work in Azure Database for PostgreSQL. You learn about the different Azure Database for PostgreSQL implementation options, and how to configure a server for your needs. (DP-3021)

Modules in this learning path:

• Explore Postgresql Architecture
• Understand Client Server Communication Postgresql
• Understand Postgresql Query Process
• Secure Azure Database for Postgresql
• Procedures Functions Postgesql
• Understand Write Ahead Logging
• Configure Manage Postgresql
• Understand Concurrency Postgresql
• Tune Queries Azure Database for Postgresql
• Migrate Azure Database Postgresql Flexible Server

Products: Azure Database Postgresql

Roles: Database Administrator

Level: Intermediate

Subjects: Databases

Duration: 383 minutes

Business leaders can make important decisions in their company if they have accurate insight into the underlying financial and operational data. A business user can also configure, and use the electronic reporting tool without a single line of code, to adopt new regulatory requirements and generate business documents in the required format to electronically exchange information with government bodies, banks, and other parties.

Modules in this learning path:

• Work with Analytics Reporting in Dynamics 365 Finance Ops
• Configure Electronic Reporting

Products: Dynamics 365, Dynamics Finance

Roles: Functional Consultant, Business User

Level: Intermediate

Subjects: Data Analytics, Finance Accounting

Duration: 119 minutes