Welcome to the SQL Beginners Guide series’ latest article. We are about to discuss SQL Languages also known as categories of SQL Statements . We will discuss what is DDL , DML and other types and what they do . However , before we move forward. In case you need to check other articles.
Reason for referring you to the previous articles is very simple. This is a series and they are being composed in order . Therefore , this order will help you in developing a better understanding for SQL query development .
SQL commands have following categories
Types of SQL Statements/SQL Commands
DML Data Manipulation Language
DDL Data Definition Language
DCL Data Control Language
TCL Transaction Control Language
Let’s do it people , time to discuss them .
DML ( Data Manipulation Language )
Remember , CRUD Operations ? The basic SQL queries we use to work with the data in table . It can be as simple as retrieving information from table , inserting , deleting or update.
Professional Data Analyst and Business Intelligence Developer with experience of delivering industrial projects for Supply Chain and Insurance Industry . Sharing all my experience and insights in databases and data warehousing and open to learn from fellows !
Happy Reading and Learning!