Prerequisite – DDL, DQL, DML, DCL and TCL Commands
DDL is Data Definition Language which is used to define data structures. For example: create table, alter table are instructions in SQL.
DML is Data Manipulation Language which is used to manipulate data itself. For example: insert, update, delete are instructions in SQL.
Difference between DDL and DML:
|It stands for Data Definition Language.||It stands for Data Manipulation Language.|
|It is used to create database schema and can be used to define some constraints as well.||It is used to add, retrieve or update the data.|
|It basically defines the column (Attributes) of the table.||It add or update the row of the table. These rows are called as tuple.|
|It doesn’t have any further classification.||It is further classified into Procedural and Non-Procedural DML.|
|Basic command present in DDL are CREATE, DROP, RENAME, ALTER etc.||BASIC command present in DML are SELECT, UPDATE, INSERT, MERGE etc.|
- Difference between RDBMS and DBMS
- Difference between OLAP and OLTP in DBMS
- Difference between Row oriented and Column oriented data stores in DBMS
- Need for DBMS
- DBMS | SQL | Question 1
- DBMS | SQL | Question 2
- Starvation in DBMS
- Disadvantages of DBMS
- Recoverability in DBMS
- Cascadeless in DBMS
- Interfaces in DBMS
- Deadlock in DBMS
- Types of Schedules in DBMS
- Number of possible Superkeys in DBMS
- File Organization in DBMS | Set 1
If you like GeeksforGeeks and would like to contribute, you can also write an article using contribute.geeksforgeeks.org or mail your article to firstname.lastname@example.org. See your article appearing on the GeeksforGeeks main page and help other Geeks.
Please Improve this article if you find anything incorrect by clicking on the "Improve Article" button below.