Meanings of SQL

What is SQL ?

- SQL is the abbreviation of structured query language

- SQL is used to access and control/manage databases

- SQL is a standard called ANSI (American National Standards Institute)

What actions SQL may perform in a database?

- SQL may create new tables

- SQL may create stored procedures

- SQL may create views

- SQL may execute query

- SQL may fetch data

- SQL may insert records

- SQL may update records

- SQL may delete records

- SQL may create new databases

- SQL may set permissions on tables, procedures, and views

The base of SQL is RDBMS, which is the abbreviation of "Relational Database Management System" and this is also a base for all modern database systems like MS SQL, MySQL, IBM DB2, Oracle and Microsoft Access.

In RDBMS the storage of data is in database objects that are called tables.

A table in this case is a collections that has related data entries and its structure is made of rows and columns.