Types of Statements in Relational Databases like DDL, DQL, DML, DCL and TCL Commands

 A Relational Database is a type of database where records or data are stored and organized into tables with rows and columns. Such databases uses SQL(Structured Query Language) to process and relate data between tables especially by using Foreign keys(primary key of another table). The structured queries are grouped into different types as depicted below:

• DDL(Data Definition Language)
• Create
• Alter
• Drop
• Truncate
• DQL(Data Query Language)
• Select
• Group by
• Having
• Where
• Order by
• DML(Data Manipulation Language)
• Insert
• Update
• Delete
• DCL(Data Control Language)
• Grant
• Revoke
• DTL(Data Transaction Language)
• Commit
• Rollback
• Savepoint