Work with MySQL Databases on Azure

Overview

Module 1: Explore the component parts of MySQL, and learn how to find your way around Azure Database for MySQL.
After completing this module, you will be able to:
- Describe Azure Database for MySQL
- Explore the MySQL architecture
- Understand the parser and query optimizer
Module 2: Learn about connection handling in MySQL, back up and restore, and the client interrace options available for MySQL.
After completing this module, you'll be able to:
- Understand connection handling in MySQL
- Understand back up and restore
- Describe the client interface options
Module 3: Learn about MySQL’s pluggable storage engine model, and learn about common storage engines, and those supported by Azure Database for MySQL.
After completing this module, you'll be able to:
- Describe the common storage engines for MySQL
- Specify a storage engine
- Understand the storage engines supported by Azure Database for MySQL
- Explain tablespaces
- Optimize write ahead logging
Module 4: Learn about Azure Database for MySQL security, encryption in Azure Database for MySQL, and how to configure Microsoft Entra authentication.
After completing this module, you will be able to:
- Describe authentication
- Configure super user access securely
- Describe built-in Azure MySQL database roles
- Understand encryption in MySQL
Module 5: Learn about concurrency in MySQL, including how to limit the number of connections, and when to use thread pools.
After completing this module, you will be able to:
- Describe thread concurrency
- Understand when to use thread pools
- Describe isolation levels
- Understand locking

Syllabus

Module 1: Module 1: Explore MySQL Architecture
- Introduction
- Explore MySQL Architecture
- Describe Azure Database for MySQL
- Understand the parser and query optimizer
- Exercise: Explore Azure Database for MySQL Flexible server
- Knowledge check
- Summary
Module 2: Module 2: Understand client-server communication in MySQL
- Introduction
- Understand connection handling
- Describe client interfaces
- Understand the MySQL query interface options
- Exercise: Explore MySQL Workbench
- Knowledge check
- Summary
Module 3: Module 3: Understand the MySQL storage engine
- Introduction
- Describe the common storage engines
- Specify a storage engine
- Understand the supported storage engines
- Explain tablespaces
- Optimize write ahead logging
- Exercise: Compare storage engine options
- Knowledge check
- Summary
Module 4: Module 4: Secure MySQL
- Introduction
- Describe authentication
- Understand super user access
- Describe built-in Azure MySQL database roles
- Understand encryption in MySQL
- Exercise: Configure permissions in MySQL
- Knowledge check
- Summary
Module 5: Module 5: Understand concurrency in MySQL
- Introduction
- Describe thread concurrency
- Understand when to use thread pools
- Describe isolation levels
- Understand locking
- Exercise: Understand locking
- Knowledge check
- Summary