Welcome to the Er Piyush Gupta Blog! Here, You will learn MySQL fast, easy and fun. This website provides you with a complete MySQL tutorial presented in an easy-to-follow manner. Each topics has examples with SQL script and screenshots available.
First, we will start with MySQL Basic tutorial. once it will complete then you can go through Advance MySQL tutorial(Coming Soon).
MySQL BASIC
MySQL is the most popular Open Source Relational SQL database management system. MySQL is one of the best RDBMS being used for developing web-based software applications.
MySQL BASIC tutorial will give you quick start, make you comfortable with MySQL programming and brief description of MySQL Data Definition & Manipulation Languages.
MySQL Quick Start
This section helps you get familiar with MySQL basic details along with How to Download and Install MySQL in local system. In this tutorial you will get one sample database also which we will use for further reference and next tutorials.
MySQL Data Manipulation Language
This section helps you get familiar with basic MySQL including managing MySQL database and manipulating data using various MySQL statements such as INSERT, DELETE, UPDATE and SELECT. You will also learn about advanced data selection techniques including INNER JOIN, LEFT JOIN, Subquery, UNION, etc.
MySQL Data Definition Language
This section helps you get familiar that how to manage database like create, alter, delete, etc. and In this tutorial you will learn table type, data type, date time type and about keys as well such as primary key, foreign key, etc.
