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

  • 7m 40s
    In this video, you will identify the types of indexes and how they work in queries. FREE ACCESS
  • 5m 44s
    Upon completion of this video, you will be able to recognize potential problems that could affect query run time and how to eliminate these problems. FREE ACCESS
  • Locked
    3.  EXPLAIN Statement Fundamentals
    2m 17s
    Upon completion of this video, you will be able to describe the purpose of the EXPLAIN statement and the results it returns. FREE ACCESS
  • Locked
    4.  Creating Indexes
    5m 36s
    In this video, you will work with clustered and secondary indexes on tables. FREE ACCESS
  • Locked
    5.  Maintaining Indexes
    5m 39s
    After completing this video, you will be able to recognize general methods for maintaining tables and indexes. FREE ACCESS
  • Locked
    6.  Visual Explain Plan
    7m 17s
    In this video, you will learn how to use the Visual Explain feature to generate a visual representation of a MySQL query. FREE ACCESS
  • Locked
    7.  Using the EXPLAIN Statement
    5m 43s
    In this video, you will learn how to use the EXPLAIN statement to analyze query execution in the MySQL client. FREE ACCESS
  • Locked
    8.  The Query Optimizer
    7m 15s
    During this video, you will learn how to use the query optimizer to control query plan evaluation. FREE ACCESS
  • Locked
    9.  Optimizing InnoDB Storage
    9m 48s
    During this video, you will learn how to identify strategies for optimizing InnoDB storage usage. FREE ACCESS
  • Locked
    10.  Optimizing the Server Hardware
    5m 41s
    Upon completion of this video, you will be able to recognize options for optimizing the configuration of the server running MySQL. FREE ACCESS
  • Locked
    11.  Optimizing MySQL
    4m 51s
    In this video, you will configure MySQL values to optimize the instance for better performance. FREE ACCESS
  • Locked
    12.  The MONyog Monitoring Tool
    4m 58s
    To find out how to download and install the MONyog performance monitoring tool for MySQL, consult the tool's documentation. FREE ACCESS
  • Locked
    13.  Using MONyog
    10m 4s
    In this video, you will use MONyog to monitor and configure OS settings to optimize MySQL performance. FREE ACCESS
  • Locked
    14.  Exercise: Performance Optimization in MySQL
    4m 45s
    Upon completion of this video, you will be able to recognize various methods available for optimizing the overall performance of MySQL, including optimizing queries. FREE ACCESS

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

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

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

Course Database Fundamentals: Database Administration Basics
Book High Performance SQL Server: Consistent Response for Mission-Critical Applications, Second Edition
Course MySQL Database Development: Working with Functions
Likes 32 Likes 32  

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course MySQL: Triggers & Stored Procedures
Likes 50 Likes 50  
Course MySQL Database Development: Stored Routines, Triggers, & the InnoDB memcached Plugin
Likes 18 Likes 18  
Course MySQL Database Development: SELECT Statement & Operators
Likes 37 Likes 37