Loading your learn pack…
Read the summary, then start training!
SQL was standardized by ANSI in 1986 and ISO in 1987.
SQL, or Structured Query Language, is a standard language for accessing and manipulating relational databases. It became an American National Standards Institute (ANSI) standard in 1986 and an International Organization for Standardization (ISO) standard in 1987. SQL supports common operations such as querying, inserting, updating, deleting, and managing database objects. Although SQL is standardized, different database systems—including MySQL, Microsoft SQL Server, Oracle, IBM DB2, and Microsoft Access—implement different versions and often add proprietary extensions. ANSI- and ISO-compliant systems generally support major commands such as SELECT, INSERT, UPDATE, DELETE, and WHERE in similar ways, but syntax, functions, and advanced features may vary between products.
SQL was standardized by ANSI in 1986 and ISO in 1987.
Different database systems provide their own SQL versions and proprietary extensions.
Major SQL commands are supported similarly across compliant systems, although advanced syntax and functions can differ.
A formal specification that defines common SQL language features and behavior across database systems.
The American National Standards Institute, which recognized SQL as a standard in 1986.
The International Organization for Standardization, which standardized SQL internationally in 1987.
A database-specific implementation of SQL that may include standard features and vendor-specific extensions.
A feature or syntax added by a database vendor that is not part of the core SQL standard.
A Relational Database Management System that stores related data in tables and provides tools for using SQL.
“Can you explain what "SQL was standardized by ANSI in 1986 and ISO in 1987." means in simple terms?”