Explore digital courses

Try Azure Cosmos DB for NoSQL

Units in this learning path:

• Introduction
• Explore Resources
• Review Basic Operations
• Exercise Create Account
• Knowledge Check
• Summary

Products: Azure Cosmos Db

Roles: Developer

Level: Intermediate

Subjects: Databases

Duration: 32 minutes

Learn how to use the Optuna library in Azure Databricks to tune machine learning hyperparameters.

Units in this learning path:

• Introduction
• Hyperopt
• Review Hyperopt Trials
• Scale Hyperopt
• Exercise Use Mlflow
• Knowledge Check
• Summary

Products: Azure Databricks

Roles: Data Scientist

Level: Intermediate

Subjects: Data Management, Machine Learning

Duration: 68 minutes

Relational databases store many different types of data for many different types of applications. Some databases have thousands of users and some have just one user. Some tables have tens of rows while others have millions of rows. Some data is unique while other data is duplicated. All of these variables mean that database management systems (DBMSs) need systems to understand the data and the queries that are running against this data to ensure optimum performance. When you perform tune a database, it's important to understand how performance tuning works and how you can assess performance metrics.

Units in this learning path:

• Introduction
• Understand Statistics
• Assess Query Performance Query Store
• Exercise Assess Query Performance Query Store
• Knowledge Check
• Summary

Products: Azure Database Postgresql

Roles: Database Administrator

Level: Intermediate

Subjects: Databases

Duration: 31 minutes

Learn how Azure Databricks integrates with Microsoft tools and services including Fabric, Power BI, VS Code, Power Platform, Copilot Studio, Purview, and Foundry to enable comprehensive data and AI solutions.

Units in this learning path:

• Introduction
• Integration Databricks Microsoft Fabric
• Integration Databricks Power Bi
• Integration Databricks Vscode
• Integration Databricks Power Platform
• Integration Databricks Copilot Studio
• Integration Databricks Microsoft Purview
• Integration Databricks Microsoft Foundry
• Knowledge Check
• Summary

Products: Azure Databricks

Roles: Data Engineer

Level: Intermediate

Subjects: Data Engineering

Duration: 69 minutes

Learn about Azure Databricks architecture, including the account hierarchy, control and compute planes, and different storage options for managing data with Unity Catalog.

Units in this learning path:

• Introduction
• Understand Azure Databricks Architecture
• Understand Unity Catalog Managed Storage
• Understand External Storage
• Understand Default Storage
• Knowledge Check
• Summary

Products: Azure Databricks

Roles: Data Engineer

Level: Intermediate

Subjects: Data Engineering

Duration: 38 minutes

The Azure Database for PostgreSQL server receives SQL queries and returns the relevant results. Each SQL query goes through several stages in order to return the correct results as quickly as possible. In this module, you learn about the different stages of processing a query, and the EXPLAIN statement.

Units in this learning path:

• Introduction
• Identify Components
• Understand Explain
• Exercise Execute Explain
• Knowledge Check
• Summary

Products: Azure Database Postgresql

Roles: Database Administrator

Level: Intermediate

Subjects: Databases

Duration: 20 minutes

Learn about connection handling in MySQL, back up and restore, and the client interrace options available for MySQL.

Units in this learning path:

• Introduction
• Understand Connection Handle
• Describe Client Interfaces
• Understand Mysql Query Interface Options
• Exercise Explore Mysql Workbench
• Knowledge Check
• Summary

Products: Azure Database Mysql

Roles: Database Administrator

Level: Intermediate

Subjects: Databases

Duration: 31 minutes

PostgreSQL is a client-server system, which allows many clients to connect to a central server. In this module you learn how PostgreSQL manages connections from clients, and looking at some common PostgreSQL client tools.

Units in this learning path:

• Introduction
• Understand Connection Handling
• Understand Postgresql Client Tools
• Exercise Explore Client Tools
• Knowledge Check
• Summary

Products: Azure Database Postgresql

Roles: Database Administrator

Level: Intermediate

Subjects: Databases

Duration: 28 minutes

Explore key concepts of data analytics, including types of analytics, data, and storage. Explore the analytics process and tools used to discover insights.

Units in this learning path:

• Introduction
• Understand Data Analytics Types
• Explore Data Analytics Process
• Understand Types of Data Data Storage
• Knowledge Check
• Summary

Products: Azure, Azure SQL Database, Azure Synapse Analytics, Power Bi

Roles: Data Analyst

Level: Intermediate

Subjects: Data Analytics

Duration: 28 minutes

Learn about concurrency in MySQL, including how to limit the number of connections, and when to use thread pools.

Units in this learning path:

• Introduction
• Describe Thread Concurrency
• Understand When to Use Thread Pools
• Describe Isolation Levels
• Understand Lock
• Exercise Understand Lock
• Knowledge Check
• Summary

Products: Azure Database Mysql

Roles: Database Administrator

Level: Intermediate

Subjects: Databases

Duration: 38 minutes

Azure Database for PostgreSQL is a multi-user relational database solution. The ability to support many concurrent users enables PostgreSQL databases to scale out and enable applications that support many users and locations at the same time. The increase in users brings a risk of conflicts. For this reason, it's important to understand the concurrency systems that are in place in Azure Database for PostgreSQL to manage concurrency and conflicts. In this module, we look at both isolation levels and locking in Azure Database for PostgreSQL.

Units in this learning path:

• Introduction
• Understand Multi Version Concurrency Control Snapshots
• Understand Isolation Levels
• Understand Lock
• Exercise Understand Locking
• Knowledge Check
• Summary

Products: Azure Database Postgresql

Roles: Database Administrator

Level: Intermediate

Subjects: Databases

Duration: 33 minutes

Data is key to most business operations and services and an understanding of data is essential in many roles. This learning path covers data concepts, data analytics, and data roles, services, and products.

Modules in this learning path:

• Get Started Data Concepts
• Get Started Data Analytics
• Understand Data Roles Services Products

Products: Office Excel, SQL Server

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

Level: Beginner

Subjects: Databases

Duration: 94 minutes