MYSQL & PHP training classes     
USACanada UK Ireland International
1 877 849 1850   0808 234 2132   1 800 550 311   +1 678 648 3113
  Home   Contact Us
XML training * MySQL & PHP Training * Tomcat Training * Perl Training
Ajax Training *Dojo Training *Ruby on Rails Training * Groovy Training * Grails Training
HTML, XHTML, & JavaScript Training * Authorware Training * Articulate Training * Live Online Training


* MySQL Training: Introduction to MySQL Databases
* MySQL Training: MySQL Development
* MySQL Training: MySQL Administration
* MySQL Training: Introduction to MySQL Development and Administration
* MySQL Training: MySQL Database Design
* MySQL Training: MySQL Optimization
* MySQL Training: Introduction to SQL Using MySQL

* PHP Training: Introduction to PHP and MySQL
* PHP Training: Advanced PHP
* Building Data-Driven PHP/MySQL Web Sites with Dreamweaver



Please contact us
for GSA pricing.

GSA

Contract #
GS-35F-0307T



Complimentary MySQL or PHP Training Seminar

Organizations in the Atlanta, Georgia area are encouraged to contact Accelebrate® about having a complimentary, one-hour MySQL or PHP training seminar delivered for their developers. Contact us today for more information.



Recent Training Venues

Accelebrate has recently trained for clients in the following cities:

  • Huntsville, Alabama
  • Montgomery / Birmingham, Alabama
  • Anchorage, Alaska
  • Calgary, Alberta
  • Phoenix, Arizona
  • Fayetteville / Little Rock, Arkansas
  • Oakland / San Jose / San Francisco, California
  • Sacramento, California
  • Oceanside / San Diego, California
  • Pasadena / Orange County / Los Angeles, California
  • San Bernardino / Riverside, California
  • Boulder / Colorado Springs / Denver, Colorado
  • Washington, DC
  • Wilmington, Delaware
  • Manchester / London, England
  • DeLand / Orlando, Florida
  • Fort Lauderdale / Miami, Florida
  • Gainesville / Jacksonville, Florida
  • Saint Petersburg / Tampa, Florida
  • Titusville & Melbourne, Florida
  • Alpharetta & Atlanta, Georgia
  • Augusta & Savannah, Georgia
  • Macon & Columbus, Georgia
  • Boise, Idaho
  • Bloomington, Illinois
  • Chicago, Illinois
  • Indianapolis, Indiana
  • Cedar Rapids / Des Moines, Iowa
  • Dublin, Ireland
  • Kingston, Jamaica
  • Wichita, Kansas
  • Paducah / Lexington / Louisville, Kentucky
  • Baton Rouge, Louisiana
  • Valletta, Malta
  • Hagerstown & Frederick, Maryland
  • Greenbelt / Silver Spring / Baltimore, Maryland
  • Boston / Cambridge, Massachusetts
  • Hartford, Connecticut / Springfield, Massachusetts
  • Taunton, Massachusetts / Providence, Rhode Island
  • Ann Arbor / Farmington Hills / Detroit, Michigan
  • Grand Rapids, Michigan
  • Lansing, Michigan
  • Saginaw / Flint / Bay City / Midland, Michigan
  • Saint Paul / Minneapolis, Minnesota
  • Jackson, Mississippi
  • Gulfport / Biloxi, Mississippi
  • St. Louis, Missouri
  • Whiteman Air Force Base / Kansas City, Missouri
  • Lincoln / Omaha, Nebraska
  • Reno and Las Vegas, Nevada
  • Santa Fe / Albuquerque, New Mexico
  • Newark, New Jersey
  • Princeton, New Jersey & Philadelphia, Pennsylvania
  • White Plains / New York City, New York
  • Charlotte, North Carolina
  • Durham / Raleigh, North Carolina
  • Bowling Green / Toledo, Ohio
  • Canton / Akron, Ohio
  • Cincinnati, Ohio
  • Cleveland & Columbus, Ohio
  • Dayton, Ohio
  • Tulsa / Oklahoma City, Oklahoma
  • Toronto, Ontario
  • Portland, Oregon
  • Pittsburgh, Pennsylvania
  • Providence, Rhode Island
  • Edinburgh / Glasgow, Scotland
  • Columbia & Charleston, South Carolina
  • Chattanooga / Knoxville, Tennessee
  • Memphis / Jackson / Nashville, Tennessee
  • College Station and Houston, Texas
  • El Paso, Texas / Ciudad Juarez, Mexico
  • San Antonio / Austin, Texas
  • Wichita Falls & Dallas, Texas
  • Ogden / Salt Lake City, Utah
  • Burlington, Vermont
  • Fairfax / Dulles / McLean / Herndon / Reston, Virginia
  • Richmond / Alexandria / Arlington, Virginia
  • Virginia Beach / Norfolk, Virginia
  • Tacoma / Seattle, Washington
  • Madison / Milwaukee, Wisconsin

 

MySQL Training: MySQL Optimization Training
Print This Outline
E-mail This Outline
Get A Quote
Course Number: 647
Duration: 1 day
view class outline

MySQL Optimization Training Overview

Accelebrate’s MySQL Optimization Training teaches attendees how to monitor, analyze, and optimize MySQL performance.

Location and Pricing

Most Accelebrate courses are taught on-site at our clients' locations worldwide for groups of 3 or more attendees and are customized to their specific needs. Please visit our client list to see organizations for whom we have recently delivered training. To receive a customized proposal and price quote, please contact us.

In addition, some courses are available as live, online classes for individuals.  To see a schedule of online courses, please visit http://www.accelebrate.com/online_training/xml_html_js.htm.

MySQL Optimization Training Prerequisites

All attendees must have prior knowledge of MySQL administration, either from their own knowledge or from Accelebrate’s MySQL Administration training or MySQL Development and Administration training.

Hands-on/Lecture Ratio

This MySQL training class is 65% hands-on, 35% lecture, with the longest lecture segments lasting for 20 minutes. Students "learn by doing," with immediate opportunities to apply the material they learn to real-world problems.

MySQL Optimization Training Materials

All MySQL training students receive

Software Needed on Each Student PC

  • MySQL 5.0 or later (class can be adapted for earlier versions upon request)
  • If you have purchased this course, please contact us for additional setup instructions

MySQL Optimization Training Objectives

  • Develop a MySQL tuning strategy.
  • Master MySQL diagnostic and tuning tools.
  • Write queries against the INFORMATION_SCHEMA database and be able to decipher the metadata obtained.
  • 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/5.1 performance enhancements dealing with queries and indexing.
  • Decide which of the storage engines should be used for your application’s specific needs.
  • Evaluate the application architecture for efficient design, structure, caching, number of connections, and other factors affecting performance.

Note: MySQL training students interested in learning how to use MySQL to build database-driven Web sites are also encouraged to consider our PHP Training: Introduction to PHP and MySQL.

MySQL Optimization Training Outline

  • Optimizing Databases and Their Objects
    • Optimizing Databases
    • Improving Application Design
    • Precomputing Queries
    • Materialized Views
    • Transactions
    • Indexing
      • Types Of Indexes
      • Indexes are not used when ...
      • Client-Server Interactions
    • MyISAM Index Collecting Statistics
  • Optimizing and Tuning Queries
    • Query Execution Plan
    • Analyzing the output from EXPLAIN Statement
      • Explain Table
    • Join Optimization
      • Cartesian Product
      • Match Elimination: Filtering Joins
      • Using Joins in Aggregation
      • Optimizing Joins
      • Driving Tables
    • When to Index
      • Index Types
    • SQL Queries: Other Optimizations
      • Optimizing Data Retrieval
      • Cardinality of a Table
      • Using the OPTIMIZE TABLE Statement
    • The Slow Query Log
  • Tuning MySQL for Performance
    • System Characteristics
      • Disk I/O Speed
      • Memory
      • How MySQL Uses Memory
      • Processor Speed
      • Network Bandwidth
    • Tuning Server Parameters
    • MySQL Query Cache
    • The MyISAM Key Cache
    • Examining Thread Information
  • MySQL Table Types
    • MySQL Table Types (Storage Engines)
    • Setting/Changing Engine
    • MyISAM Tables
      • Full-Text Search on MyISAM Tables
      • Creating a Full-Text Index
      • Using Full-Text Search
    • InnoDB Tables
      • InnoDB - Limitations and Drawbacks
      • InnoDB Disk Management
      • Preventing Problems
      • Moving Files
    • FOREIGN KEY Constraints in InnoDB
      • Checking Foreign Keys
    • Choosing - MyISAM or InnoDB?
    • HEAP or MEMORY Tables
    • Temporary Tables
    • MERGE Tables
    • Other Table Types
      • ARCHIVE or Compressed Tables (since MySQL 4.1)
      • CSV Type Tables(since MySQL 4.1)
      • NDB or Cluster Tables (since MySQL 4.1)
      • FEDERATED or External Tables (since MySQL 5.0)
      • BDB Tables
    • Table Files Storage
  • Conclusion
 
Print This OutlineE-mail This OutlineGet A Quote

Java® and all Java-based marks are trademarks or registered trademarks of Sun Microsystems, Inc. in the U.S. and other countries.

MySQL™ and all MySQL-based marks are trademarks or registered trademarks of Sun Microsystems, Inc. or its subsidiaries in the U.S. and other countries.
Accelebrate®
Comes to You!


Accelebrate's courses are taught exclusively on-site at your location for groups of 3 or more attendees, anywhere worldwide.

Don't settle for a "one size fits all" public class! Have Accelebrate come to your site and deliver exactly the training you want, for less than the cost of a public class.

For pricing and to learn more, please call us at +1 877 849 1850, fill out our information request form, or email us at info@accelebrate.com today.
 
Accelebrate E-Newsletter


Get the latest Web development news delivered to your email box once a month!

VB.NET, C#, ASP, & ASP.NET Training * Java Training * SQL Server Training
Adobe Training * PHP Training * XML Training * Perl Training

“Accelebrate,” “Accelerated Learning Celebrated Results,” and the Accelebrate logo are registered trademarks of Accelebrate, Inc. All other product names and trademarks are property of their respective owners. Course outline content may mirror or be derived from the book that each student receives with the course. Otherwise, all content is copyright © 2003- by Accelebrate, Inc. of Atlanta, Georgia, USA. To contact us, please use the contact form, email info@accelebrate.com us, or call 1 877 849 1850 in the US and Canada, 0808 234 2132 in the UK, 1 800 550 311 in Ireland, or +1 678 648 3113 from all other locations.

Recent client sites: Birmingham, AL | Phoenix, AZ | Los Angeles, CA | Sacramento, CA | San Diego, CA | San Francisco, CA | San Jose, CA | Denver, CO | Washington, DC | Jacksonville, FL | Miami, FL | Orlando, FL | Tampa, FL | Atlanta, GA | Chicago, IL | Indianapolis, IN | Boston, MA | Baltimore, MD | Detroit, MI | Minneapolis, MN | Kansas City, MO | Saint Louis, MO | Charlotte, NC | Raleigh, NC | Albuquerque, NM | Las Vegas, NV | New York City, NY | Cincinnati, OH | Cleveland, OH | Columbus, OH | Dayton, OH | Oklahoma City, OK | Toronto, ON | Portland, OR | Philadelphia, PA | Pittsburgh, PA | Memphis, TN | Nashville, TN | Austin, TX | Dallas, TX | Houston, TX | San Antonio, TX | Salt Lake City, UT | Seattle, WA | Dublin, Ireland | London, UK
About Accelebrate IT Training VB.NET, C#, and ASP.NET Training Java, Struts, and JSP Training Adobe Training Microsoft SQL Server Training XML Training, PHP Training, Perl Training, and Other Courses Database and Reporting Training