Work with MySQL Databases on Azure
- Offered byMicrosoft
Work with MySQL Databases on Azure at Microsoft Overview
Duration | 3 hours |
Total fee | Free |
Mode of learning | Online |
Schedule type | Self paced |
Difficulty level | Intermediate |
Official Website | Explore Free Course  |
Credential | Certificate |
Work with MySQL Databases on Azure at Microsoft Course details
- Explore MySQL Architecture
- Understand client-server communication in MySQL
- Understand the MySQL storage engine
- Secure MySQL
- Understand concurrency in MySQL
- In this learning path you'll find out how to manage and optimize Azure Database for MySQL
- After completing this learning path, you'll be able to: Understand Azure Database for MySQL options, Describe the MySQL client query interfaces, Work with MySQL storage engines, Secure your Azure Database for MySQL server, Understand concurrency in MySQL
- Explore the component parts of MySQL, and learn how to find your way around Azure Database for MySQL
- Learn about connection handling in MySQL, back up and restore, and the client interface options available for MySQL
Work with MySQL Databases on Azure at Microsoft Curriculum
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
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
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
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
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
Work with MySQL Databases on Azure at Microsoft Entry Requirements
- Demonstrate an understanding of relational databases.Demonstrate an understanding of basic SQL.
- Not mentioned
Other courses offered by Microsoft
Student Forum
Anything you would want to ask experts?