MySQL Essentials 1 Training

General Course Description

This instructor led hands on training course focuses on the essentials of MySQL and is an EXCELLENT hands on training course to the world most powerful, friendly and most popular open source database. Students will get over 15+ 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 Essentials 1

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 - Field Data Types

  • Numeric Data Type
  • Character & String Types
  • Text & Binary Types
  • Date & Time Types
  • Others

  • Module 2 - Selecting The Correct Storage Engine

  • MyISAM Storage Engine
  • InnoDB Storage Engine
  • Archive Storage Engine
  • Federated Storage Engine
  • Memory Storage Engine

  • Module 3 - Transactions, Stored Procedures and Triggers

  • ACID & Savepoints
  • Transaction Behavior
  • Stored Functions & Procedures Overview
  • Triggers Overview
  • Scheduling Events in MySQL

  • Module 4 - Basic MySQL Server Administration

  • MySQL Uptime, ACL & Basic Tuning
  • Starting, Stopping & Scripting MySQL
  • MySQL Health Check
  • Privilege Overview
  • Basic Troubleshooting Techniques

  • Module 5 - Basic Maintenance, Backup and Recovery

  • Log Files Overview
  • Table Health Check and Overview
  • Optimizing Tables
  • Backing Up MySQL
  • Restoring MySQL

  • Module 6 - MySQL Replication

  • MySQL Replication Overview
  • Threads vs. Methods
  • Master - Slave Overview
  • Master - Master Overview
  • Group Replication

  • Module 7 - MySQL Schema Essentials

  • Determining the best Data Types
  • Indexing 101
  • Indexing for High Availability
  • Normalization & De-normalization
  • Alter Table Performance Guidelines

  • Module 8 - Essential Query Performance Optimization

  • Slow Query Data Optimization Overview
  • MySQL Query Optimizer Overview
  • How to optimize MySQL Queries
  • Benefits and Disadvantages of Variables
  • What log Files can tell you about your Queries

  • Module 9 - MySQL Server Optimization Essentials

  • Tuning 101
  • Tools, files and symptoms
  • I/O Tuning Basics
  • Session based tuning
  • Tuning MySQL Concurrency