eConsulting Group, Inc.eConsulting Group YouTube VideoseConsulting Group on FacebookAgile Experts Meetup GroupAgile and Project Management Training and Consulting Experts in LinkedIn
WDE5005 - MySQL Optimization Training

WDE5005 - MySQL Optimization Training

Duration: 1 day

Price: $498.75

Description

The MySQL Optimization Training course is aimed for both Database Developers and Administrators, and anyone involved in monitoring and optimizing MySQL. This course will provide students with the skills and tools for monitoring, analyzing and optimizing database performance.

Learning Objectives

• Develop a tuning strategy.
• Display knowledge of MySQL architecture.
• Display knowledge and ability to use diagnostic tools.
• Display knowledge and ability to use tuning tools.
• Write queries against the INFORMATION_SCHEMA database and be able to decipher the metadata obtained.
• Understand the relational database model and both the positive and negative implications on performance.
• Display, decipher and edit server configuration variables to improve performance of your applications.
• Display and analyze status variables to ensure that their applications are utilizing the settings in the most effective manner.
• Write queries that take advantage of the MySQL 5.0 performance enhancements dealing with queries and indexing.
• Decide which of the storage engines could be used in their specific application needs.
• Evaluate the application architecture for efficient design, structure, caching, number of connections and other factors affecting performance.
• Evaluate hardware and OS for effects on performance.
• Evaluate techniques for loading data into the database and effects on performance.
• Optimize at various levels - Installation, Databases and statements.
• Configure MySQL to optimize.

Method of Delivery

• Onsite/Live class instructions or Online web conference
• Lectures
• Open discussion
• Case studies
• Surveys

eCG Logo XS

Chicago Downtown Location:
20 N. Wacker Dr. Suite 1200
Chicago, IL 60606

Direct: +1 (312) 804-9992
Office: +1 (312) 804-0772
Fax: +1 (312) 803-2223
Toll Free: (866) 482 8275

E-mail: info@ecgmn.com

 All names and logos are registered trademarks of their respective owners.

eConsulting Group®, Agile Expert™, Business Analyst Expert™, Database Management Expert™, Hands On Project Management™, Healthcare IT Expert™, Human Resource Expert™, Link2Task™, Link2Project™, Management Expert™, Network Security Expert™, Office Management Expert™, Programming Expert™, Project Book™, Project Management Expert™, Project Management Specialist™, Project Manager Master Level™, Project2Market™, Renewable Energy Management Expert™, Six Sigma Expert™, Social Media Expert™, We Build Project Managers™, and Web Development Expert™ are registered certificates and trademarks of eConsulting Group, Inc.

PMI-ACP, PMI, CAPM, PMP, Project Management Professional, and PMBOK® Guide are registered marks of the Project Management Institute, Inc.

GI Bill® is a registered trademark of the U.S. Department of Veterans Affairs (VA). More information about education benefits offered by VA is available at the official U.S. government Web site at https://www.benefits.va.gov/gibill.

eConsulting Group, Inc. (DBA Institute of Management) is registered with the National Association of State Boards of Accountancy (NASBA) as a sponsor of continuing professional education on the National Registry of CPE Sponsors. State boards of accountancy have final authority on the acceptance of individual courses for CPE credit. Complaints regarding registered sponsors may be submitted to the National Registry of CPE Sponsors through its website: www.nasbaregistry.org.

Copyright © 2019 eConsulting Group, Inc. All Rights Reserved. Please read our Privacy Policy.

Search