YoVDO

Work with MySQL Databases on Azure

Offered By: Microsoft via Microsoft Learn

Tags

MySQL Courses Encryption Courses Database Management Courses

Course Description

Overview

Save Big on Coursera Plus. 7,000+ courses at $160 off. Limited Time Only!
  • 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

Related Courses

Managing Big Data with MySQL
Duke University via Coursera Database Management Essentials
University of Colorado System via Coursera Business Metrics for Data-Driven Companies
Duke University via Coursera Bases de données relationnelles : Comprendre pour maîtriser
Inria (French Institute for Research in Computer Science and Automation) via France Université Numerique Базы данных (Databases)
Saint Petersburg State University via Coursera