İstanbul escort bayan sivas escort samsun escort bayan sakarya escort Muğla escort Mersin escort Escort malatya Escort konya Kocaeli Escort Kayseri Escort izmir escort bayan hatay bayan escort antep Escort bayan eskişehir escort bayan erzurum escort bayan elazığ escort diyarbakır escort escort bayan Çanakkale Bursa Escort bayan Balıkesir escort aydın Escort Antalya Escort ankara bayan escort Adana Escort bayan

Saturday, May 18, 2024
HomeAcademicStructured Query Language: DDL, DML, TCL, DCL, DQL

Structured Query Language: DDL, DML, TCL, DCL, DQL

SQL (Structured Query Language) is a programming language used to manage and manipulate data stored in relational databases. It is a standard language for interacting with relational databases and is used to create, read, update, and delete records in the database. It was the first commercial language introduced for E.F Codd’s Relational model. Today almost all RDBMS(MySql, Oracle, Informix, Sybase, MS Access) use SQL as the standard database language. SQL is used to perform all types of data operations in RDBMS.

SQL is a declarative language, which means that it specifies what the result should be, rather than how to get there. This makes it easy for users to understand and write SQL statements, even if they do not have a lot of programming experience. It is used in a wide range of applications, including web development, data analysis, and business management. It is a powerful and flexible language that is essential for working with relational databases.

SQL Types

There’re various types of SQL. Each type of SQL serves a specific purpose and is used in different situations. For example, DDL is used to define the structure of the database, while DQL is used to retrieve data from the database. There are several types of SQL, including:

1. DDL: Data Definition Language

DDL (Data Definition Language) is a type of SQL (Structured Query Language) that is used to define the database structure or schema. It is used to create, modify, and delete database objects such as tables, indices, and users. All DDL commands are auto committed which means DDL Commands save all the changes permanently in the database and rollback is difficult. Some examples of DDL statements include:

SQL CommandDescription
CREATE TABLEUsed to create a new table in the database or database itself
ALTER TABLEUsed to modify an existing table in the database
TRUNCATE TABLEUsed to clear all the values from the table
DROP TABLEUsed to delete a table from the database or the database itself
RENAMEUsed to rename a table
Fig: DDL Commands

2. DML: Data Manipulation Language

DML (Data Manipulation Language) is a type of SQL that is used to manage data within the database. It is used to insert, update, delete, and select data from the database. Unlike DDL, DML commands are not auto-committed. It means changes as a result of executing DML queries are not permanent to the database, they can be rolled back instantly. Following are some DML commands with their meanings:

INSERT INTOUsed to insert new data into the database
UPDATEused to modify existing data in the database
DELETE FROMUsed to delete data from the database
MERGEUsed to merge two rows or two relations
Fig: DML Commands

3. TCL: Transaction Control Language

TCL (Transaction Control Language) is a type of SQL that is used to manage the transactions in the database. It is used to manage the changes made by DML statements. These commands are to keep a check on other DML commands and their effect on the database and to roll back to the original state. It can also make changes permanent in the database system.

COMMITUsed to save the changes made by a transaction to the database i.e. to permanently save
ROLLBACKUsed to undo the changes made by a transaction
SAVEPOINTUsed to identify a point in a transaction to which you can later roll back i.e. to save temporarily

4. DCL: Data Control Language

DCL (Data Control Language) is a type of SQL that is used to control access to the database. It is used to grant and revoke permissions on the database objects to users. Data control language provides commands to grant and take the authority(access control rights) back. Some examples of DCL statements include:

GRANTUsed to give a user permission to perform a specific task i.e. to grant permission for rights
REVOKEused to take back permission that was previously granted to a user

5. DQL: Data Query Language

DQL (Data Query Language) is a type of SQL that is used to retrieve data from the database. It is used to select, retrieve, and view data from the database. The SELECT statement is the most commonly used DQL statement.

SELECTretrieve records from one or more table

The author of this blog post is a technology fellow, an IT entrepreneur, and Educator in Kathmandu Nepal. With his keen interest in Data Science and Business Intelligence, he writes on random topics occasionally in the DataSagar blog.
- Advertisment -

Most Popular