Introducing SQL
Structured Query Language (SQL) is the most widely used language in relational database platforms for recording, editing, re-editing, and querying operations. SQL was created by Donald D. Chamberlin and Raymond F. Boyce in 1974 in an innovation lab at IBM and has since evolved with DBMSs that use it with Microsoft SQL Server, Oracle Database, MySQL, PostgreSQL, and MariaDB.
SQL has been standardized by ANSI and the International Organization for Standardization (ISO), but each of the RDBMS has some exclusive extended SQL standard instructions, primarily for administration, monitoring, and other operations unique to that RDM.
These unique patterns have names such as the following:
- T-SQL or Transact-SQL is the version used by Microsoft SQL Server and Azure SQL versions
- pgSQL is the default of PostgreSQL databases
We will now list some of the additional advantages that made the SQL language the standard used in relational databases.
