Live Online (VILT) & Classroom Corporate Training Course

MySQL is a popular, open-source relational database management system owned by Oracle. While MySQL is often thought of as a component of the LAMP (Linux-Apache-MySQL-PHP) stack, MySQL runs on a wide array of other operating systems, including Windows, Solaris, and macOS.
MySQL Logo

How can we help you?

  • CloudLabs
  • Projects
  • Assignments
  • 24x7 Support
    24x7 Support
  • Lifetime Access
    Lifetime Access


MySQL training course teaches attendees how to develop SQL statements, views, stored procedures, and triggers for their MySQL databases. Participants also learn how to design and implement a database and how to work with foreign keys, transactions, and stored programs.



At the end of MySQL training course, participants will

  • Work with any database
  • Use MySQL Workbench to work with a database and run SQL statements
  • Retrieve, add, update, and delete data from a database
  • Work with summary queries, subqueries, data types, and functions
  • Use MySQL Workbench to create an EER (enhanced entity-relationship) model for their database
  • Design and implement their own databases
  • Use MySQL to create stored procedures, functions, triggers, and events
  • Manage transactions and locking


Experience in basic computer literacy with previous experience with command-line programs and some knowledge of database concepts is required. Some knowledge of data retrieval and reporting would be beneficial.


Course Outline

  • An Introduction to Client/Server Systems
  • An Introduction to the Relational Database Model
  • An Introduction to SQL and SQL-Based Systems
  • The SQL Statements
  • How to Use SQL From An Application Program

  • An Introduction to MySQL Workbench
  • Using Workbench to Run SQL Statements
  • Using the Reference Manual
  • Command Line Client

  • An Introduction to the SELECT Statement
  • The SELECT Clause
  • The WHERE Clause
  • The ORDER BY Clause
  • The LIMIT Clause

  • Inner Joins
  • Outer Joins
  • Other Skills For Working With Joins
  • How to Work With Unions

  • Creating Test Tables
  • Inserting New Rows
  • Updating Existing Rows
  • Deleting Existing Rows

  • Aggregate Functions
  • How to Group and Summarize Data

  • An Introduction to Subqueries
  • How to Code Subqueries In the WHERE Clause
  • How to Code Subqueries In Other Clauses
  • Working With Complex Queries

  • Converting Data
  • Working With Data Types

  • String Data
  • Numeric Data
  • Date/Time Data
  • Other Functions You Should Know About

  • Design A Data Structure
  • Normalize A Data Structure
  • Using MySQL Workbench For Database Design

  • Databases
  • Tables
  • Indexes
  • A Script That Creates A Database
  • How to Use MySQL Workbench
  • Character Sets and Collations
  • Storage Engines

  • An Introduction to Views
  • How to Work With Views

  • An Introduction to Stored Programs
  • How to Write Procedural Code

  • How to Work With Transactions
  • How to Work With Concurrency and Locking

  • Coding Stored Procedures
  • Coding Stored Functions
  • How to Use Workbench With Procedures and Functions