Advantages and disadvantages of SQL?

In this tutorial, you will learn about, What is SQL? What are the advantages and disadvantages of SQL?

SQL: It stands for Structured Query Language used to develop, maintain a database. It is a type of procedural language divided into various parts.

  1. DDL: It stands for Data Definition Language.
  2. DML: It stands for Data Manipulation Language.
  3. DCL: It stands for Data Control Language
  4. TCL: It stands for Transaction control language.

SQL allows to create .edit, update maintain database records, and it’s also allowed to develop any application. SQL provides various components like queries, Plsql, trigger, cursor, etc. SQL designed by the Oracle organization in 1993. It offers various tools to run SQL commands or queries.

Advantages of SQL:

  1. View database recorded without storing.
  2. It retrieves some table records by hiding some information.
  3. We can join two tables.
  4. We can establish a relationship between two or more tables.
  5. Provide a relational algebra function.
  6. Support oops concept.
  7. SQL support event and event handling procedure.
  8. SQL support exception handling concept.
  9. SQL support conditional looping, array, function and programming features, and components.
  10. SQL provides a recovery facility.

Disadvantages of SQL:

  1. For SQL need training to an excess database.
  2. SQL can be handled by an expert user or programmer.
  3. It occupies some space i.e extra memory location for each record.
  4. It is platform dependent language.
  5. It is a command-based language.

Comment below if you have queries related to the above topic, What is SQL? What are the advantages and disadvantages of SQL?