MySQL Database Training 

• How to use SQL to get output reports with MySQL.
• How to modify MySQL data with SQL.
• How to create a simple MySQL database Table.

MySQL Training Course Outline

• Relational Database Basics   

• What is Relational Database?
• What is Data, Table, Field, Records?
• Popular Databases
• SQL Statements

• Simple SELECT Statement

• SELECTing All Columns in All Rows
• Exploring the Tables
• SELECTing Specific Columns 
• Sorting Records 
• The WHERE Clause and Operator Symbols 
• The WHERE Clause and Operator Words 
• Checking Multiple Conditions 
• Writing SELECTs with Multiple Conditions

• Advanced SELECT Statement

• Aggregate Functions and Grouping
• Built-in Data Manipulation Functions
• Interceptors 

• Subqueries, Joins, and Unions with MySQL 

• Subqueries 
• Joins 
• Outer Joins  
• Unions 

• Inserting, Updating and Deleting Records with MySQL

• INSERT
• UPDATE 
• DELETE

• Creating and Modifying Tables with MySQL

• Creating Tables
• Data types 
• Altering Tables
• Renaming Tables
• Dropping Tables

• Views and Stored Procedures

• Creating Views with MySQL
• Dropping Views 
• Creating Stored Procedures
• Benefits of Stored Procedures