Explore digital courses

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

This module teaches you about data protection options in Azure NetApp Files to help you improve the resiliency of your data.

Units in this learning path:

• Introduction
• Snapshots
• Backups
• Cross Region
• Cross Zone
• Knowledge Check
• Summary

Products: Azure Netapp Files, Azure Virtual Machines

Roles: Administrator, Solution Architect

Level: Intermediate

Subjects: Cloud Computing, Storage, Cloud Security

Duration: 40 minutes

Data is so widespread that many services and roles are needed to manage the data of an organization. This module covers types of data products, Azure data services, and the roles of data professionals.

Units in this learning path:

• Introduction
• Describe Data Product Categories
• Azure Data Services
• Data Professionals
• Knowledge Check
• Summary

Products: Office Excel, SQL Server

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

Level: Beginner

Subjects: Databases

Duration: 21 minutes

Understand data warehouse developer features of Azure Synapse Analytics

Units in this learning path:

• Introduction
• Explore Development Tools for
• Understand Transact SQL Language Capabilities for
• Work with Windowing Functions
• Exercise Work with Windowing Functions
• Work with Approximate Execution
• Exercise Work with Approximate Execution
• Work with Json Data SQL Pools
• Encapsulate Transact SQL Logic with Stored Procedures
• Knowledge Check
• Summary

Products: Azure Synapse Analytics

Roles: Data Engineer

Level: Intermediate

Subjects: Data Analytics, Data Storage

Duration: 57 minutes

In this module, you learn about how your organization's devices can be provisioned and managed. Additionally, you learn about the different types of enrollment methods available using Microsoft Intune.

Units in this learning path:

• 1 Introduction
• 2 Understand Provisioning
• 3 Enroll Devices
• 4 Configure Devices
• 5 Protect Devices
• 6 Retire Devices
• 7 Device Enrollment Methods
• 8 Knowledge Check
• 9 Summary

Products: Mem, M365

Roles: Administrator

Level: Beginner

Subjects: Device Management

Duration: 50 minutes

Understand network attached storage (NAS) concepts and various NAS protocols supported in Azure NetApp Files.

Units in this learning path:

• Introduction
• Protocols
• Share Permissions
• File Permissions
• Knowledge Check
• Summary

Products: Azure Netapp Files

Roles: Administrator, Database Administrator, Data Engineer, Data Scientist, Solution Architect

Level: Beginner

Subjects: Cloud Computing, Storage

Duration: 22 minutes

Understand how Microsoft Defender for Cloud strengthens AI security in Azure through posture management and integration with key governance and identity services.

Units in this learning path:

• Introduction
• Understand AI Services Azure
• Understand AI Security Risks
• Guardrails Protections Azure
• Azure Security Governance AI Workloads
• Knowledge Check
• Summary

Products: Azure, Azure AI Foundry, Defender For Cloud, Entra Id

Roles: Security Engineer

Level: Intermediate

Subjects: Cloud Security

Duration: 26 minutes