Sunday, March 17, 2019

SQL Server | What Is SQL | SQL Meaning

What is SQL(Structured Query Language)?

  • SQL stands for Structured Query Language.
  • SQL is a domain-specific language,it is used in designed for managing data and programming  held in a RDBMS(Relational Database Management System) , or for stream processing in a RDSMS(Relational Data Stream Management System).
  • It is mainly useful to handling structured data - there are relations between different entities/variables of the data.
  • SQL became a standard of the ANSI(American National Standards Institute) in 1986, and of the ISO(International Organization for Standardization) in 1987.

What Can SQL do Or Work Of SQL ?

  • Execute queries against a database or table
  • Retrieve data from a database or table
  • Insert records in a database or table
  • Update records in a database or table
  • Delete records from a database or table
  • Create new databases or table
  • Create new tables in a database or table
  • Create stored procedures in a database or table
  • Create views in a database or table
  • Set permissions on tables, procedures, and views
* * * * * * * * * * * * * * * *

In Easy Language (Simplify)

In simple words we can say that SQL is used to communicate with a database
SQL is the standard language for RDMS (Relational Database Management Systems).
SQL statements / commands are used to perform tasks such as update data on a database, or retrieve(get) data from a database or table.

Useful Full Forms

ANSI - American National Standards Institute
RDBMS - Relational Database Management System
RDSMS - Relational Data Stream Management System
ISO - International Organization for Standardization

Previous Post

post written by: