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 UPDATE, INSERT, MERGE etc.|
|DDL does not use WHERE clause in its statement.||While DML uses WHERE clause in its statement.|
Don’t stop now and take your learning to the next level. Learn all the important concepts of Data Structures and Algorithms with the help of the most trusted course: DSA Self Paced. Become industry ready at a student-friendly price.
- Difference between 1NF and 2NF in DBMS
- Difference between 2NF and 3NF in DBMS
- Difference between 3NF and BCNF in DBMS
- Difference between Database and DBMS
- Difference between RDBMS and DBMS
- Difference between Classification and Clustering in DBMS
- Difference between Selection and Projection in DBMS
- Difference between Cursor and Trigger in DBMS
- Difference between Trigger and Procedure in DBMS
- Difference between File System and DBMS
- Difference between Schema and Instance in DBMS
- Difference between OLAP and OLTP in DBMS
- Difference between Generalization and Specialization in DBMS
- Difference between Client /Server and Distributed DBMS
- Main difference between Timestamp protocol and Thomos write rule in DBMS
- Difference between Row oriented and Column oriented data stores in DBMS
- Difference between E-R Model and Relational Model in DBMS
- Need for DBMS
- History of DBMS
- Disadvantages of DBMS
If you like GeeksforGeeks and would like to contribute, you can also write an article using contribute.geeksforgeeks.org or mail your article to email@example.com. 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.