Explore digital courses

Learn how to use Transact-SQL (T-SQL) to interact with relational databases by querying and modifying data. This course covers essential operations such as inserting, updating, deleting, and merging data across tables. You'll also explore how to generate automatic values and apply changes efficiently using SQL Server or Azure SQL environments.

Modules in this learning path:

• Intro to Transact SQL
• Sort and Filter Queries
• Query Multiple Tables with Joins
• Write Subqueries
• Use Built Functions Transact SQL
• Modify Data with Transact SQL

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: Data Analytics

Duration: 345 minutes

This module explains the structure of the namespaces that contain classes and also how to query instances of a class. It covers how to query remote computers by using ad-hoc connections and CIM sessions.

Units in this learning path:

• Introduction
• List Local Repository Namespaces Classes
• Query Instances Commands Windows Management Instrumentation Query Language
• Connect Remote Computers Cmdlets
• Query Repository Classes from Remote Computers Cimsession Objects
• Knowledge Check
• Summary

Products: Azure, Entra Id, Azure Cloud Shell, Azure Powershell, Azure Virtual Machines, M365

Roles: Administrator

Level: Intermediate

Subjects: Architecture, Storage, Virtual Machine

Duration: 41 minutes

Query logs in Microsoft Sentinel

Units in this learning path:

• Introduction
• Logs Page
• Understand Tables
• Understand Common Tables
• Understand Microsoft 365 Defender Tables
• Knowledge Check
• Summary Resources

Products: Microsoft Sentinel

Roles: Security Operations Analyst

Level: Intermediate

Subjects: Cloud Security

Duration: 18 minutes

This learning path covers Windows Management Instrumentation (WMI) and Common Information Model (CIM). These technologies help to access information about a computer. Additionally, both technologies provide local and remote access to management information from the operating system, computer hardware, and installed software.

Modules in this learning path:

• Review Common Information Model Windows Management Instrumentation
• Query Configuration Information
• Query Manipulate Repository Objects

Products: Azure, Entra Id, Azure Cloud Shell, Azure Powershell, Azure Virtual Machines, M365

Roles: Administrator

Level: Intermediate

Subjects: Architecture, Storage, Virtual Machine

Duration: 99 minutes

This content is a part of Query relational data in Azure.

Units in this learning path:

• Introduction
• Introduction to SQL
• SQL Database
• SQL Database for Postgresql
• SQL Database for Mysql
• Perform Query
• Summary

Products: Azure

Roles: Administrator, Business User, Data Engineer, Student

Level: Beginner

Subjects: Data Analytics

Duration: 26 minutes

Author queries for Azure Cosmos DB for NoSQL using the SQL query language.

Units in this learning path:

• Introduction
• Understand SQL Query Language
• Create Queries SQL
• Project Query Results
• Implement Type Checking Queries
• Use Built Functions
• Execute Queries Sdk
• Exercise Execute Sdk
• Knowledge Check
• Summary

Products: Azure Cosmos Db

Roles: Developer

Level: Intermediate

Subjects: Cloud Computing, Databases

Duration: 61 minutes

Learn how to query, visualize, and monitor data in Microsoft Sentinel by using the Azure portal.

Units in this learning path:

• 1 Introduction
• 2 Exercise Setup
• 3 Monitor Visualize Data
• 4 Query Data
• 5 Workbooks
• 6 Create New Workbook
• 7 Exercise Visualize Data
• 8 Summary

Products: Azure, Microsoft Sentinel

Roles: Security Operations Analyst

Level: Intermediate

Subjects: Threat Protection

Duration: 48 minutes

Learn how to use Azure Service Bus to queue, distribute, and reliably process AI workloads using queues, topics, subscriptions, and dead-letter queues.

Units in this learning path:

• Introduction
• Explore Service Bus Concepts
• Choose Queues Topics Subscriptions
• Structure Messages AI Workloads
• Process Messages Reliably
• Exercise Process Messages
• Knowledge Check
• Summary

Products: Azure Service Bus

Roles: Developer

Level: Intermediate

Subjects: Backend Development, Artificial Intelligence

Duration: 81 minutes

This course was developed by members of AWS Technical Field Communities (TFC), an AWS community of technical experts. The content is intended to complement our standard training curriculum and augment your AWS learning journey. We are aware some…

This course was developed by members of AWS Technical Field Communities (TFC), an AWS community of technical experts. The content is intended to complement our standard training curriculum and augment your AWS learning journey. We are aware some…

This course was developed by members of AWS Technical Field Communities (TFC), an AWS community of technical experts. The content is intended to complement our standard training curriculum and augment your AWS learning journey. We are aware some…

Create a Terraform configuration, provision your Azure resources, and set up your project for continuous integration and continuous delivery (CI/CD) by using either GitHub Actions or Azure Pipelines.

Units in this learning path:

• 1 Introduction
• 2 Terraform
• 3 Github Actions
• 4 Exercise
• 5 Exercise
• 6 Knowledge Check
• 7 Summary

Products: Azure, Azure App Service, Azure Database Mysql, Azure Pipelines

Roles: Developer

Level: Intermediate

Subjects: Cloud Computing

Duration: 30 minutes