MySQL Database Development: Query & Performance Optimization

MySQL 8.0    |    Intermediate
  • 14 Videos | 1h 27m 18s
  • Includes Assessment
  • Earns a Badge
Likes 16 Likes 16
Indexing and understanding the configuration of MySQL can be key to performance. Explore index types and configuration options that can be set to fine-tune the performance of your MySQL databases to optimal levels

WHAT YOU WILL LEARN

  • identify the types of indexes and how they function in queries
    recognize potential problems affecting query run time and how to eliminate these problems
    describe the purpose of the EXPLAIN statement and the results it returns
    work with clustered and secondary indexes on a table
    recognize general methods for maintaining tables and indexes
    use the Visual Explain feature to generate a visual representation of a MySQL query
    use the EXPLAIN statement to analyze query execution in the MySQL client
  • use the query optimizer to control query plan evaluation
    identify strategies available for optimizing InnoDB storage usage
    recognize options for optimizing the configuration for the server running MySQL
    configure MySQL values to fine-tune the instance for optimal performance
    download and install the MONyog performance monitoring tool for MySQL
    use MONyog to monitor and configure OS settings to optimize MySQL performance
    recognize various methods available for optimizing the overall performance of MySQL, including optimizing queries

IN THIS COURSE

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

Skillsoft is providing you the opportunity to earn a digital badge upon successful completion of this course, which can be shared on any social network or business platform

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

BOOK MySQL Concurrency: Locking and Transactions for MySQL Developers and DBAs
BOOK Querying MySQL: Make your MySQL Database Analytics Accessible with SQL Operations, Data extraction, and Custom Queries
BOOK MongoDB Performance Tuning: Optimizing MongoDB Databases and their Applications

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

COURSE MySQL Database Development: DDL Statements
Likes 48 Likes 48  
COURSE Advanced SQL Queries
Likes 209 Likes 209  
COURSE MySQL Database Development: Introduction
Likes 109 Likes 109