Explore digital courses

Explore query performance optimization

Units in this learning path:

• Introduction
• Understand Query Plans
• Explain Estimated Actual
• Describe Dynamic Management Views and Functions
• Explore Query Store
• Identify Problematic
• Describe Blocking Locking
• Exercise Identify Resolve Blocking Issues
• Knowledge Check
• Summary

Products: Azure SQL Database, SQL Server

Roles: Database Administrator

Level: Intermediate

Subjects: Databases

Duration: 103 minutes

This content is a part of Explore relational database services in Azure.

Units in this learning path:

• Introduction
• Describe Azure SQL
• Azure Open Source Databases
• Exercise Provision Relational Azure Data Services
• Knowledge Check
• Summary

Products: Azure

Roles: Data Analyst, Data Engineer, Database Administrator, Student

Level: Beginner

Subjects: Databases

Duration: 43 minutes

A report is a structured presentation of data. Reporting presents data in a way that lets you make informed decisions by using data visualizations, dashboards, financial reporting, and structured documents. finance and operations apps provide several reporting tools that you can use to meet different reporting needs. This module will help you become familiar with the various reporting options that are available with finance and operations apps.

Units in this learning path:

• 01 Overview
• 02 Data Sources Support Classes
• 03 Implement Security Reqs
• 04 Publish Report
• 05 Lab
• 06 Check
• 07 Summary

Products: Dynamics 365, Dynamics Finance, Dynamics Scm

Roles: Developer

Level: Intermediate

Subjects: Data Analytics

Duration: 69 minutes

Learn how security works in Azure SQL Database, the key concepts, and practical examples to help developers effectively utilize Azure SQL Database in their cloud-based applications.

Units in this learning path:

• Introduction
• Explore Authentication Methods
• Configure Managed Identity
• Understand Firewall Rules
• Explore Advanced Data Security
• Exercise Managed Identity
• Knowledge Check
• Summary

Products: Azure SQL Database, Azure

Roles: Developer, Solution Architect

Level: Intermediate

Subjects: Databases, Cloud Computing

Duration: 71 minutes

Discover how to export and edit Microsoft Dataverse table data using Excel files, while understanding security concepts.

Units in this learning path:

• Introduction
• Export Data
• Exercise Create
• Edit Update
• Exercise Edit
• Check
• Summary

Products: Power Apps

Roles: Maker, Functional Consultant

Level: Beginner

Subjects: Data Management

Duration: 28 minutes

Do you want to know how to modify existing tables and pages for Microsoft Dynamics 365 Business Central? In this module, you'll learn ways to create and customize table and page objects.

Units in this learning path:

• 1 Introduction
• 2 Customer Table
• 3 Customer Card
• 4 Customer List
• 5 Exercise
• 6 Exercise
• 7 Exercise
• 8 Check
• 9 Summary

Products: Dynamics 365, Dynamics Business Central

Roles: Developer

Level: Beginner

Subjects: Data Modeling

Duration: 42 minutes

Learn how to extract event log data for process mining.

Units in this learning path:

• Introduction
• Extract Event Log Data
• Identify Data Source
• Validate Data
• Exercise Inspect
• Consolidate Clean Up
• Exercise Consolidate
• Check
• Summary

Products: Power Automate

Roles: Functional Consultant, Developer

Level: Beginner

Subjects: Data Management

Duration: 59 minutes

Learn how to filter data in PostgreSQL using the WHERE clause, logical operators, pattern matching, and subqueries for advanced query control.

Units in this learning path:

• Introduction
• Sample Database Overview
• Where Clause
• Subqueries
• Summary

Products: Azure Database Postgresql

Roles: Database Administrator, Developer

Level: Beginner

Subjects: Databases

Duration: 23 minutes

A Learning Plan pulls together training content for a particular role or solution, and organizes those assets from foundational to advanced. Use Learning Plans as a starting point to discover training that matters to you. The following courses…

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 is the first of two offerings designed to introduce learners to the current market trends in analytics. In Part 1, you will learn fundamental concepts such as types of analytics, the 5 V's of big data, and the challenges associated…