MySQL

HomeMySQL

MySQL

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

Concepts

Client/Server Concepts

Database and Database Objects

Data Definition using SQL

Databases

Data Types

Tables

Constraints and Indexes

Views

Basic Data Manipulation using SQL

Recurring SQL Constructs

Adding data

Modifying data

Removing data

Searching data

Advanced Data Manipulation using SQL

Expressions

Grouping and Aggregate Functions

Joining Tables

Transactions

Transaction Concepts

SQL for working with Transaction

Import/Export

Tools for Import/Export

SQL for Import/Export