Explore digital courses

Optimize query performance in Azure SQL

Modules in this learning path:

• Explore Query Performance Optimization
• Explore Performance Based Design
• Evaluate Performance Improvements

Products: Azure SQL Database, SQL Server

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

Level: Intermediate

Subjects: Databases

Duration: 236 minutes

Azure Database for PostgreSQL uses vacuum and autovacuum to remove rows that have been marked as soft-deleted after an update or deletion.

Units in this learning path:

• Introduction
• Explain Purpose Vacuum Autovacuum
• Configure Autovacuum Server Parameters
• Exercise Configure Autovacuum Server Parameters
• Knowledge Check
• Summary

Products: Azure Database Postgresql

Roles: Database Administrator

Level: Intermediate

Subjects: Databases

Duration: 24 minutes

Orchestrate data movement and transformation in Azure Data Factory or Azure Synapse Pipeline

Units in this learning path:

• Introduction
• Understand Control Flow
• Working Pipelines
• Debug Pipelines
• Adding Parameters Components
• Exercise Integrate Notebook Azure Synapse Pipelines
• Executing Packages
• Knowledge Check
• Summary

Products: Azure Data Factory, Azure Synapse Analytics

Roles: Data Engineer, Data Scientist

Level: Intermediate

Subjects: Data Analytics

Duration: 56 minutes

This training takes a look at choosing between the use of a pipeline or notebook and different orchestration patterns in Microsoft Fabric.

Units in this learning path:

• Introduction
• Choose Between Pipeline Notebook
• Design Schedules and Event Based Triggers
• Exercise Implement Dynamic Patterns to Notebooks
• Knowledge Check
• Summary

Products: Fabric

Roles: Data Engineer, Data Analyst

Level: Intermediate

Subjects: Data Engineering

Duration: 47 minutes

Learn to control the size and order of query results in PostgreSQL with the LIMIT, OFFSET, and ORDER BY clauses. Master pagination, sorting, and optimizing performance with these essential SQL tools.

Units in this learning path:

• Introduction
• Sample Database Overview
• Order by
• Limit Offset
• Summary

Products: Azure Database Postgresql

Roles: Database Administrator, Developer

Level: Beginner

Subjects: Databases

Duration: 12 minutes

Perform Zero ETL analytics with HDInsight Interactive Query.

Units in this learning path:

• 1 Introduction
• 2 When Should You Use Hdinsight Interactive Query
• 3 Hdinsight Adhoc Analytics Architecture Patterns
• 4 Exercise Provisioning Hdinsight Perform Adhoc Analytics
• 5 Exercise Upload Query Data Hdinsight
• 6 Integrate Apache Spark Hive Llap Queries
• 7 Create Large Scale Interactive Query Dashboard Evaluating Real Estate Trends
• 8 Summary
• 9 Knowledge Check

Products: Azure Hdinsight

Roles: Data Engineer, Data Scientist

Level: Beginner

Subjects: Data Analytics

Duration: 56 minutes

Perform advanced streaming data transformations with Apache Spark and Kafka in Azure HDInsight

Units in this learning path:

• Introduction
• Use Hdinsight Spark Kafka
• Stream Data with Apache Kafka
• Describe Spark Structured Streaming
• Create Kafka Spark Architecture
• Exercise Provision Hdinsight Perform Data Transformations
• Exercise Create Kafka Producer
• Exercise Stream Kafka Data to Jupyter Notebook Window Data
• Replicate Data to Secondary Cluster
• Knowledge Check
• Summary

Products: Azure Hdinsight

Roles: Data Engineer, Data Scientist

Level: Intermediate

Subjects: Data Analytics

Duration: 46 minutes

Advanced analytics helps you gain deeper insights into your data, identify trends, and make data-driven decisions. Power BI provides a variety of tools and features to help you analyze your data effectively.

Units in this learning path:

• 1 Introduction
• 2 Statistical Summary
• 3 Visuals
• 4 Group Data
• 5 Clustering Techniques
• 6 Time Series Analysis
• 7 Analyze Feature
• What If Parameters
• Use Specialized Visuals
• Lab
• 11 Check
• 12 Summary

Products: Power Bi

Roles: Data Analyst

Level: Intermediate

Subjects: Data Analytics, Data Visualization

Duration: 67 minutes

Perform code-free transformation at scale with Azure Data Factory or Azure Synapse Pipeline

Units in this learning path:

• Introduction
• Explain Transformation Methods
• Describe Transformation Types
• Use Mapping Data Flow
• Debug Mapping Data Flow
• Use Wrangling Data
• Use Compute Transformations
• Integrate Ssis Packages Within
• Knowledge Check
• Summary

Products: Azure Data Factory, Azure Synapse Analytics

Roles: Data Engineer, Data Scientist

Level: Beginner

Subjects: Data Analytics

Duration: 58 minutes

Perform operations on multiple items in single logical units of work.

Units in this learning path:

• Introduction
• Create Transactional Batch Sdk
• Reviewing Batch Operation Results Sdk
• Exercise Batch Multiple Point Operations Together Sdk
• Implement Optimistic Concurrency Control
• Knowledge Check
• Summary

Products: Azure Cosmos Db

Roles: Developer

Level: Intermediate

Subjects: Databases

Duration: 37 minutes

With some Power Apps canvas apps, a form isn't the solution. This module focuses on how to perform custom updates when your data isn't in a form.

Units in this learning path:

• 1 More Than Forms
• 2 Patch Function
• 3 Deleting Records
• 4a Exercise Patch
• 4 Knowledge Check
• 5 Summary

Products: Power Platform, Power Apps

Roles: Functional Consultant, Maker

Level: Intermediate

Subjects: Data Management

Duration: 38 minutes

Learn how to use Apache Spark pools in Azure Synapse Analytics for scalable distributed data processing.

Modules in this learning path:

• Understand Big Data Engineering with Apache Spark Azure Synapse Analytics
• Transform Data Spark Azure Synapse Analytics
• Use Delta Lake Azure Synapse Analytics

Products: Azure Synapse Analytics

Roles: Data Engineer

Level: Intermediate

Subjects: Data Engineering

Duration: 190 minutes