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 Expert Performance Indexing in SQL Server 2019: Toward Faster Results and Lower Maintenance, Third Edition
BOOK PostgreSQL Query Optimization: The Ultimate Guide to Building Efficient Queries
BOOK PHP 8 Solutions

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

COURSE JIRA Administration: Platform Fundamentals
Likes 269 Likes 269  
COURSE MySQL Database Development: DDL Statements
Likes 48 Likes 48  
COURSE SQL Developer
Likes 285 Likes 285