Question

What is SQL ? Explain the types of SQL.​

Answer 1

The commands are CREATE, ALTER, DROP, RENAME, and TRUNCATE. Data Manipulation Language (DML) - These SQL commands are used for storing, retrieving, modifying, and deleting data. These Data Manipulation Language commands are: SELECT, INSERT, UPDATE, and DELETE

There are five types of SQL Commands which can be classified as:

DDL(Data Definition Language).

DML(Data Manipulation Language).

DQL(Data Query Language).

DCL(Data Control Language).

TCL(Transaction Control Language

Answer 2

SQL is a very powerful and diverse database language use to storing data into databases. sql is loosely typed language so you can learn easily.

 we use command line examples to know about executing speed of SQL. It's take very bit of time for executing and retrieving result.

SQL is a greater tool with web languages such as PHP, Python, Java, ASP to build dynamic web applications.

SQL Constraints are the rules which are apply to table columns to store valid data and prevents the user to storing/entering invalid data into table columns. SQL Constraints are part of a database definition..

types of SQL:

 1.   DDL(Data Definition Language).

 2. DML(Data Manipulation Language).

 3.  DQL(Data Query Language).

 4.  DCL(Data Control Language).

 5. TCL(Transaction Control Language).