Explore digital courses

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

Learn how to write clear, effective prompts for Microsoft Copilot Chat by using four prompt elements, applying best practices, personalizing Copilot, and managing prompts in Prompt Lab.

Units in this learning path:

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

Products: Ms Copilot

Roles: Business User

Level: Beginner

Subjects: Artificial Intelligence

Duration: 29 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

Learn how to write reusable code in Python using functions, parameters, return values, variable scope, and importable modules.

Units in this learning path:

• Introduction
• Create Functions with Parameters
• Return Values from Functions
• Manage Variable Scope
• Create Importable Modules
• Exercise Create Calculator
• Knowledge Check
• Summary

Products: Vs Code

Roles: Developer, Student

Level: Beginner

Subjects: App Development

Duration: 57 minutes

Learn how to write reusable code in C# using methods, parameters, return values, variable scope, and namespaces.

Units in this learning path:

• Introduction
• Create Methods with Parameters
• Return Values from Methods
• Manage Variable Scope
• Organize Code with Namespaces
• Exercise Create Billing Calculator
• Knowledge Check
• Summary

Products: Dotnet

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

Level: Beginner

Duration: 61 minutes

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

Units in this learning path:

• Introduction
• Display Console Output
• Accept User Input
• Manipulate Strings
• Exercise Welcome Message
• Challenge User Interaction
• Knowledge Check
• Summary

Products: Dotnet

Roles: Developer

Level: Beginner

Duration: 35 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