Explore digital courses

Get started with Transact-SQL programming

Units in this learning path:

• Introduction
• Describe T SQL for Programming
• Describe Batches
• Declare Assign Variables Synonyms
• Use If While Blocks to Control Program Flow
• Exercise Program T SQL
• 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

Subjects: Data Analytics, Databases

Duration: 58 minutes

This content is a part of Get started with data analytics.

Units in this learning path:

• Introduction
• Aggregate Data
• Group Data
• Visualize Data
• Exercise Analyze Data
• Knowledge Check
• Summary

Products: Office Excel, SQL Server

Roles: Business Owner, Business User, K 12 Educator, Student

Level: Beginner

Subjects: Databases

Duration: 36 minutes

Businesses rely on data. Understanding data is key to many business operations. This module covers what data is, when to sort and filter data and when to calculate derived values from data.

Units in this learning path:

• Introduction
• Get Started Data
• Sort Filter Data
• Derive Data
• Highlight Data
• Exercise Use Excel to Explore Data
• Knowledge Check
• Summary

Products: Office Excel, SQL Server

Roles: Business Owner, Business User, K 12 Educator, Student

Level: Beginner

Subjects: Databases

Duration: 37 minutes

Learn how to perform core data engineering workloads on Microsoft Azure.

Modules in this learning path:

• Introduction Data Engineering Azure
• Introduction to Azure Data Lake Storage

Products: Azure Data Lake Storage, Azure Synapse Analytics

Roles: Data Engineer

Level: Intermediate

Subjects: Data Engineering

Duration: 56 minutes

Get started with data science in Microsoft Fabric by learning how to train a model in a notebook, and track your metrics with MLflow and experiments.

Units in this learning path:

• Introduction
• Data Science
• Fabric Concepts
• Mlflow
• Exercise Use Notebook
• Knowledge Check
• Summary

Products: Fabric

Roles: Data Analyst, Data Engineer, Data Scientist

Level: Beginner

Subjects: Data Management, Machine Learning

Duration: 46 minutes

Understand the key components and design considerations for implementation of data warehouses in Microsoft Fabric.

Units in this learning path:

• Introduction
• Understand Data Warehouse
• Understand Data Warehouse Fabric
• Query Transform Data
• Model Data
• Security Monitor
• Exercise
• Knowledge Check
• Summary

Products: Fabric

Roles: Data Analyst, Data Engineer

Level: Beginner

Subjects: Data Analytics, Data Engineering, Data Storage

Duration: 76 minutes

An enterprise-scale data-management and analytics scenario provides a prescriptive data platform design coupled with Azure best practices to define best course for the data journey.

Units in this learning path:

• Introduction
• Define a Strategy
• Describe Data Management Landing Zones
• Exercise Provision Data Management Landing Zone
• Knowledge Check Data Management Landing Zone
• Describe Data Landing Zones
• Exercise Provision Data Landing Zone
• Knowledge Check Data Landing Zone
• Describe Data Integration Landing Zones
• Describe Data Product Landing Zones
• Exercise Provision Data Product Landing Zone
• Knowledge Check Data Product Landing Zone
• Summary

Products: Azure

Roles: Developer

Level: Beginner

Subjects: Data Management, Data Analytics

Duration: 71 minutes

Lakehouses in Microsoft Fabric combine data lake flexibility with data warehouse analytics. Learn how to create, load, and query a lakehouse on a single platform.

Units in this learning path:

• Introduction
• Fabric Lakehouse
• Work Lakehouse
• Explore Data Lakehouse
• Exercise Lakehouse
• Knowledge Check
• Summary

Products: Fabric

Roles: Data Analyst, Data Engineer, Data Scientist

Level: Beginner

Subjects: Data Analytics, Data Engineering, Data Integration, Data Storage

Duration: 58 minutes

Learn Azure Cosmos DB for MongoDB basics.

Units in this learning path:

• Introduction Mongodb API Azure Cosmos Db
• API for Mongodb API Versions
• Create Account Database Collection Use API for Mongodb
• Connect Query API for Mongodb
• Capacity Estimation Use Calculator
• Exercise Create Mongodb Db App Use API for Mongodb
• Knowledge Check
• Summary

Products: Azure Cosmos Db

Roles: Developer

Level: Intermediate

Subjects: Databases

Duration: 63 minutes

Learn tips and tricks about preparing for your first teaching session, which labs to use, when and how to introduce technical topics, as well as other resources and materials.

Units in this learning path:

• Introduction
• Objective Domains
• Learn Module Best Practices
• Explore Best Practices for Module 1
• Explore Best Practices for Module 2
• Explore Best Practices for Module 3
• Explore Best Practices for Module 4
• Explore Best Practices for Module 5
• Explore Best Practices for Module 6
• Explore Best Practices for Module 7
• Explore Best Practices for Module 8
• Explore Best Practices for Module 9
• Explore Best Practices for Module 10
• Explore Best Practices for Module 11
• Bring All Together
• Knowledge Check
• Summary

Products: Azure

Roles: Higher Ed Educator

Level: Advanced

Subjects: Data Management

Duration: 140 minutes

Learn tips and tricks about preparing for your first teaching session, which labs to use, when and how to introduce technical topics, as well as other resources and materials.

Units in this learning path:

• Introduction
• Objective Domains
• Learn Module Best Practices
• Explore Best Practices for Module 1
• Explore Best Practices for Module 2
• Explore Best Practices for Module 3
• Explore Best Practices for Module 4
• Explore Best Practices for Module 5
• Explore Best Practices for Module 6
• Explore Best Practices for Module 7
• Explore Best Practices for Module 8
• Explore Best Practices for Module 9
• Explore Best Practices for Module 10
• Explore Best Practices for Module 11
• Explore Best Practices for Module 12
• Bring All Together
• Knowledge Check
• Summary

Products: Azure

Roles: Higher Ed Educator

Level: Advanced

Subjects: Data Management

Duration: 77 minutes

With AWS Internet of Things (IoT), you can manage billions of devices and connect them to each other and the cloud. You are able to collect, store, process, and analyze device data for a variety of use cases. This course introduces you to AWS IoT,…