100 Most Popular Courses For September

Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Microsoft

Work with MySQL Databases on Azure

Microsoft via Microsoft Learn

Go to class Write review

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

Tags

Reviews

Start your review of Work with MySQL Databases on Azure

Go to class

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Sign up for free
Someone learning on their laptop while sitting on the floor.