Introduction

MySQL is the database which is used to store data associated with any particular Website. For example in case of an e-commerce store the user will Signup first on the website , thus to store all his credentials like Name, Username, E-mail, Date-of-Birth etc MySQL is used. Other than that the products page of the online store has data related to products like price, description, quantity in stock etc. Thus all the information is required to be stored in a database which in our case is MySQL.

In MySQL we can define a 'database' and then we can have different tables associated with it e.g 'users' table which stores all the information related to registered user, 'products' table which account for the information related to the products displayed on the website etc. 

Tables as we know have rows and columns, thus columns account for various fields e.g. 'userID',  'first_name', 'last_name' and the rows have the corresponding data of a particular user in terms of those fields.

In this course we will teach you 'PHPMyAdmin ', which is a graphical tool in which you can define your database and tables graphically without righting any code.