- 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
- 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
- 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
- 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
- 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
Overview
Coursera Flash Sale
40% Off Coursera Plus for 3 Months!
Grab it
Syllabus
- 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
- Module assessment
- Summary
- Understand client-server communication in MySQL
- Introduction
- Understand connection handling
- Describe client interfaces
- Understand the MySQL query interface options
- Exercise: Explore MySQL Workbench
- Module assessment
- Summary
- 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
- Module assessment
- Summary
- 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
- Module assessment
- Summary
- Understand concurrency in MySQL
- Introduction
- Describe thread concurrency
- Understand when to use thread pools
- Describe isolation levels
- Understand locking
- Exercise: Understand locking
- Module assessment
- Summary