In this article we talk about SQL its types and syntax, and we learn in simple wording
Thank you for reading this post, don't forget to subscribe!What is a SQL?
SQL stands for Structured Query Language. It is the standard language used to interact with relational databases, which store data in tables. SQL allows us to easily add, update, delete, and retrieve data.
What is a Relational Database?
A relational database organises data into tables with rows and columns. Each table shows a specific topic, and the rows contain individual records. The structure makes connecting and working with data across different tables easy.
What is a types of SQL?
There are four main types of SQL commands, each used for different purposes:
- DDL (Data Definition Language):
- Used to define or modify database structure.
- Example:
CREATE,ALTER,DROP. - What it does: Create or modify tables and databases.
- DML (Data Manipulation Language):
- Used to work with the data inside the database.
- Example:
INSERT,UPDATE,DELETE. - What it does: Add, change, or remove data.
- DCL (Data Control Language):
- Used to control access to the database.
- Example:
GRANT,REVOKE. - What it does: Manage user permissions.
- TCL (Transaction Control Language):
- Used to manage database transactions.
- Example:
COMMIT,ROLLBACK. - What it does: Save or undo changes in a transaction.
Article Categories:
SQL
