MySQL 5.7 Training

General Course Description

This instructor led hands on training course focuses on the new and improved features of MySQL 5.7 and is an EXCELLENT overview of the improvements and bugs in the current release of MySQL. Students will get over 12+ hours of hands-on-labs! The labs account for over 80% of the class and allows the student to learn FIRST hand from real world scenarios. Your instructor is a former Sun Microsystems employee & a MySQL Certified DBA & have a minimum of 10 years of MySQL deployment experience.

Course Details: MySQL 5.7 Training

Class Details

Who Should Attend
  • Sales Engineers
  • Systems Engineers
  • Database Administrators
  • IT Managers
  • Developers
  • Prerequisites
  • Basic understanding of databases - helpful but NOT necessary.
  • Understanding of installing and uninstalling programs.
  • Basic knowledge of the Internet, networks and ports.
  • Have read and know a little about MySQL.
  • Basic grasp of command line execution syntax and editors.
  • Course Outline

    Module 1 - Introduction to MySQL 5.7

  • What new in MySQL 5.7
  • Why is MySQL so popular
  • History of MySQL
  • Different MySQL Versions
  • MySQL Architecture Overview

  • Module 2 - MySQL 5.7 Installation

  • Supported Operating systems
  • Installation Options
  • Windows installation
  • Linux installation
  • Solaris installation

  • Module 3 - Top 10 Improvements in MySQL 5.7

  • Replication Improvements
  • Performance Improvements
  • Scalability Improvements
  • Security Improvements
  • Next Generation Application Support

  • Module 4 - MySQL Multi-Source Replication

  • MySQL Rplication AGE OLD problem
  • MySQL 5.7 Multi Souce Replication
  • How Does Group Replication Work
  • Group Replication Requirements
  • Group Replication Limitations

  • Module 5 - Optimizer and Performance Improvements

  • Bulk Data Loading Has Gotten Faster
  • Parallel Flushing of the Buffer Pools
  • Explain is your BEST FRIEND
  • Optimizer Performance and Disk I/O Reduction
  • Virtual Columns

  • Module 6 - InnoDB and Security Enhancements to MySQL Monitor

  • Password Expiration Password Policy
  • Lock and UnLock User Accounts
  • Resize InnoDB buffer pool online
  • Improvements on InnoDB I/O
  • Next Steps / Where To Go...