Explore digital courses

Data Analysis Expressions (DAX) is a formula language for Power BI that enables you to create calculations, add logic, and enhance data analysis within your reports and semantic models.

Units in this learning path:

• 1 Introduction
• Calculation Types
• 2 Formulas
• 3 Data Types
• 4 Functions
• 5 Operators
• 6 Variables
• 7 Check
• 8 Summary

Products: Power Bi, Fabric

Roles: Data Analyst

Level: Beginner

Subjects: Data Analytics

Duration: 30 minutes

Write Subqueries in T-SQL

Units in this learning path:

• Introduction
• Understand Subqueries
• Scalar or Multi Values Subqueries
• Self Contained or Correlated Subqueries
• Exercise Subqueries
• 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

Duration: 50 minutes

Learn how to write advanced T-SQL code including CTEs, window functions, JSON functions, regular expressions, fuzzy string matching, graph queries, correlated queries, and error handling.

Units in this learning path:

• Introduction
• Common Table Expressions
• Window Functions
• Json Functions
• Regular Expressions
• Fuzzy String Matching
• Graph Queries
• Correlated Queries
• Error Handling
• Exercise Write Advanced SQL Code
• Knowledge Check
• Summary

Products: SQL Server, Azure SQL Database, Azure SQL Managed Instance, Fabric

Roles: Data Engineer, Database Administrator, Developer, Solution Architect

Level: Intermediate

Subjects: Databases, Data Management, Data Engineering, Cloud Computing, App Development

Duration: 146 minutes

Write advanced Transact-SQL queries

Modules in this learning path:

• Create Tables Views Temporary Objects
• Combine Query Results Set Operators
• Write Queries That Use Window Functions
• Transform Data by Implementing Pivot Unpivot Rollup Cube

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

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

Level: Advanced

Duration: 207 minutes

Learn how to write data in a Power Apps canvas app.

Units in this learning path:

• 1 Introduction to Forms
• 2 Form Modes
• 3 Adding Customizing Edit Form
• 4 Submit Your Form
• 5 Special Properties
• Exercise
• 6 Knowledge Check
• 7 Summary

Products: Power Platform, Power Apps

Roles: Business User, Maker, Functional Consultant

Level: Intermediate

Subjects: Data Management, Custom App Development

Duration: 53 minutes

Learn how to write down or appreciate a fixed asset in Microsoft Dynamics 365 Business Central and post transactions to the ledgers.

Units in this learning path:

• 1 Introduction
• 2 Appreciate Fixed Assets
• 3 Exercise
• 4 Check
• 5 Summary

Products: Dynamics 365, Dynamics Business Central

Roles: Functional Consultant, Business User

Level: Intermediate

Subjects: Finance Accounting

Duration: 29 minutes

This module teaches you how to write clear, effective prompts for Microsoft 365 Copilot Chat by exploring key elements, best practices, and the Prompt Gallery to help you achieve optimal results.

Units in this learning path:

• Introduction
• Write Effective Prompt
• Review Prompting Best Practices
• Discover Share Save Prompts Copilot Prompt Gallery
• Knowledge Check
• Summary

Products: Ms Copilot

Roles: Business User

Level: Beginner

Subjects: Artificial Intelligence

Duration: 24 minutes

Learn how to manage Azure Cosmos DB for NoSQL accounts, databases, and containers using the Azure CLI.

Units in this learning path:

• Introduction
• Create Resources
• Manage Index Policies
• Configure Database Container Provisioned Throughput
• Migrate Standard Autoscale Throughput
• Change Region Failover Priority
• Initiate Failovers
• Exercise Adjust Provisioned Throughput Using Azure Cli Script
• Knowledge Check
• Summary

Products: Azure Cosmos Db

Roles: Developer

Level: Intermediate

Subjects: Databases

Duration: 41 minutes

This content is a part of Write queries that use window functions.

Units in this learning path:

• Introduction
• Describe Window Functions
• Use Over Clause
• Use Rank Aggregate Offset Functions
• Exercise
• Knowledge Check
• Summary

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

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

Level: Advanced

Duration: 51 minutes

Get started by writing code examples to learn the basics of the C# syntax.

Units in this learning path:

• Introduction
• Exercise Hello World
• How It Works
• Challenge
• Review Solution Print Messages
• Knowledge Check
• Summary

Products: Dotnet

Roles: Developer

Level: Beginner

Duration: 27 minutes

This module covers the syntax of creating and executing methods. Creating reusable code and structuring solutions using methods are reviewed.

Units in this learning path:

• Introduction
• Understand Syntax of Methods
• Exercise Create Your First Method
• Exercise Create Reusable Methods
• Exercise Build Code with Methods
• Exercise Challenge Restructure Code to Use Methods
• Review Solution Restructure Code to Use Methods
• Knowledge Check
• Summary

Products: Dotnet, Vs Code

Roles: Developer, Higher Ed Educator, K 12 Educator, Student

Level: Beginner

Duration: 55 minutes

Set up your F# development environment, write your first line of F# code, and build your first F# application

Units in this learning path:

• Introduction
• What Is Fsharp
• Fsharp Development Environment
• Set Up Development Environment
• Fsharp Interactive
• Write Your First
• Fsharp Build Application
• Build Your First
• Knowledge Check
• Summary

Products: Dotnet

Roles: Developer, Student

Level: Beginner

Duration: 28 minutes