MySQL Fundamentals 1 Training

General Course Description

This instructor led hands on training course focuses on the fundamentals of MySQL and is an EXCELLENT introduction 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 Fundamentals 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 - Introduction to MySQL

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

  • Module 2 - MySQL Installation

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

  • Module 3 - Post MySQL Installation Considerations

  • Basic MySQL installation probing
  • Operating system considertions
  • Cleanup scripts
  • Basic user management
  • Securing your MySQL installation

  • Module 4 - MySQL Engines and MetaData Overview

  • MetaData Overview
  • Table Types / Engine Types
  • MyISAM Overview
  • InnoDB Overview
  • Considerations for Performance

  • Module 5 - Access MySQL & Data Types

  • Establishing a Connection
  • Navigating the mysql prompt
  • Data Types
  • Correct & Incorrect uses of data types
  • MySQL Client Types and Connections

  • Module 6 - Introduction to MySQL Monitor

  • Introduction to the MySQL Monitor
  • MySQL Monitor Overview
  • MySQL Monitor Architecture
  • Running the MySQL Monitor
  • Common MySQL Monitor Tasks

  • Module 7 - MySQL Database Structure

  • Overview of MySQL database structures
  • Creating and using databases
  • Creating and using tables
  • Modifying databases and tables
  • Naming conventions to consider

  • Module 8 - Basic SQL Introduction

  • Introduction to SQL
  • SELECT & INSERT Statement and Basic Querying Techniques
  • WHERE & SORT Statement and Basic Querying Techniques
  • UPDATE & DELETE Statement and Basic Querying Techniques
  • Basic MySQL Expression Debugging


    Module 9 - Fundamental Backup & Recovery

  • Backup and Recovery Overview
  • mySQLDump Features and Overview
  • System Files to Backup
  • Backing Up Databases
  • Restoring Databases