About SQL(Structured Query Language):

SQL(Structured Query Language) is a standardized programming language that allows users to interact with relational databases to extract, organize, manage, and manipulate data.

It is easy to learn because it uses common English words in its statements.

It was invented in 1970s and is known as Structured English QUEry Language(SEQUEL), and later on shorted to SQL.

SQL commands

1.DDL(Data Definition Language):-It refers to SQL commands that design the database structure. DDL is used to create and modify database objects based on the business requirements. Some DDL commands are DROP,CREATE,TRUNCATE,ALTER.

2.DML(Data Manipulation Language):-It deals with the manipulation of data present in the database. DML commands are INSERT,UPDATE, DELETE.

3.DCL(Data Control Language):- Data control language (DCL) is used to manage or authorize database access for other users. Major DCL commands are GRANT and REVOKE.

4.DQL(Data Query Language):-DQL statements are used for performing queries on the data within schema objects. The purpose of the DQL Command is to get some schema relation based on the query passed to it. Major DQL commands include SELECT.

1. TCL(Transaction Control Language):-Transactions group a set of tasks into a single execution unit. Each transaction begins with a specific task and ends when all the tasks in the group are successfully completed. If any of the tasks fail, the transaction fails. Some of the TCL commands include ROLLBACK,SAVEPOINT,COMMIT.

What is MySQL?

MySQL is an open-source relational database management system offered by Oracle. Developers can download and use MySQL without paying a licensing fee.