MySQL - Tutorial

MySQL is an open-source relational database management system (RDBMS). A relational database organizes data into data tables in which data types may be related to each other. These relations help structure the data. SQL is a language programmers use to create, modify and extract data from the relational database, as well as control user access to the database. In addition to relational databases and SQL, MySQL works with an operating system to implement a relational database in a computer's storage system, manages users, allows for network access and facilitates testing database integrity and creation of backups.

MySQL is free and open-source software under the terms of the GNU General Public License, and is also available under a variety of proprietary licenses. MySQL has stand-alone clients that allow users to interact directly with a MySQL database using SQL, but more often, MySQL is used with other programs to implement applications that need relational database capability.

About Tutorial

This tutorial provides basic and advanced concepts of MySQL. It is designed for beginners and professionals as well. Every topic is explained with examples which make you learn MySQL in a very easy way. In this tutorial, you will learn how to create new database, perform various operations on database like insert new records, update records, delete records and view records etc. Additionally, you will also learn how to create database/table, drop database/table, set permission on tables, procedures, and views and create stored procedure, function in a database.

We believe in learning by examples therefore each and every topic is explained with lots of examples that makes you learn MySQL in a very easy way.

Prerequisite

There is no prerequisite for this tutorial however a basic understanding of database would be an added advantage.