MySQL is an open source relational database management system. Its name is a combination of "My", the name of co-founder Michael Widenius's daughter, and "SQL", the abbreviation for Structured Query Language.MySQL is an Oracle-backed open source relational database management system (RDBMS) based on Structured Query Language (SQL).Although it can be used in a wide range of applications, MySQL is most often associated with web applications and online publishing.

MySQL is a fast, easy-to-use RDBMS used being used for many small and big businesses. MySQL is developed, marketed, and supported by MySQL AB, which is a Swedish company. MySQL is becoming so popular because of many good reasons.MySQL supports large databases, up to 50 million rows or more in a table. The default file size limit for a table is 4GB, but you can increase this (if your operating system can handle it) to a theoretical limit of 8 million terabytes (TB).

MySQL Training Syllabus

MySQL Basic

MySQL introduction

Creating a database

Creating a database table


Client/Server Concepts

Database and Database Objects

Data Definition using SQL


Data Types


Constraints and Indexes


Basic Data Manipulation using SQL

Recurring SQL Constructs

Adding data

Modifying data

Removing data

Searching data

Advanced Data Manipulation using SQL


Grouping and Aggregate Functions

Joining Tables


Transaction Concepts

SQL for working with Transaction


Tools for Import/Export

SQL for Import/Export