Learn about SQL: Basics of SQL

SQL first appeared in 1974 and the initial release in 1986.
It is designed by Donald D.Chamberlin and Raymond F.Boyce.
The filename extension in sql is .sql.
Sql is developed by ISO/IEC and the standard is ISO/IEC 9075.
SQL Versions: SQL-86,89,92,1999,2003,2006,2008,2011.
SQL initially called SEQUEL(Structured English QUEry Language).
It is became a standard of the ANSI in 1986 and the ISO in 1987.
Transact-SQL (T-SQL) is an extension of SQL that is used in SQL Server.
The origins of the SQL take us back to the 1970s, when in the IBM laboratories, new database software was created - System R.
various open-source SQL database solutions such as MySQL, PostgreSQL, SQLite, Firebird, etc are there.

Definition of SQL:

SQL is responsible for querying and editing information stored in a certain database management system.
Structured Query Language (SQL) is a language used to view or change data in databases.
SQL, which stands for Structured Query Language, is a programming language that is used to communicate with and manipulate databases.

Advantages of SQL:

SQL runs on Windows,Linux, and Unix as well as Mac OS X.
It is easy to use.To hide data complexity.
It is a free and Open source.
Interactive language.
No coding required.
It is used to protect the data.
Portable.
High Speed.
Easy to learn and understand.
Restrict the access of a table so that nobody can insert the rows into the table.
Client/Server language.
Dynamic.
Join two or more tables and show it as one object to user.

Disadvantages of SQL:

Learn about SQL