DBMS Characteristics of SQL

In this article, you will learn the characteristics of SQL.

Characteristics of SQL

1. Easy to Learn: SQL is user-friendly, english like language that makes it easy to learn. Learning SQL doesn’t require prior knowledge.
2. Portable language: SQL is a portable language, which means the software that supports SQL can be moved to another machine without affecting the capability of SQL interacting with the database on new machine.
3. Supports wide variety of commands: SQL supports various useful commands such as:
   • DDL (Data Definition Language) commands like CREATE, DROP, ALTER.
   • DML (Data Manipulation Language) commands like INSERT, DELETE, UPDATE.
   • DCL (Data Control Language) commands like GRANT, REVOKE.
   • TCL (Transaction Control Language) commands like COMMIT, ROLLBACK.
   • DQL (Data Query Language) commands like SELECT.
4. Reusability: SQL promotes reusability by supporting stored procedures. These stored procedures are stored SQL statements that can be used to perform a specific task any number of times. This makes it easier to write SQL statements for a re-occurring task and reusing the saved stored procedure to perform the same task without rewriting the same SQL statements again.
5. Supports JOIN: SQL supports join which is used to combine the data of two or more tables. This can be useful when we need to perform the operation on multiple tables.
6. Supports UNION: UNION command can be used to join two or more DQL statement (SELECT statements).
7. Integration: SQL allows integration to non-SQL database applications as well.
8. Performance: Better performance even if the database size if huge.
9. SQL is scalable and flexible.
10. SQL is secure.