Loading your learn pack…
Read the summary, then start training!
SQL was standardized by ANSI in 1986 and ISO in 1987.
SQL is a standardized language for accessing and manipulating relational databases. It became an ANSI standard in 1986 and an ISO standard in 1987. The standard defines core operations such as SELECT, INSERT, UPDATE, DELETE, and filtering with WHERE, allowing users to work with databases in a generally consistent way. Despite this standardization, SQL has different versions and implementations across database systems such as MySQL, Microsoft SQL Server, Oracle, IBM DB2, and Microsoft Access. These systems usually support the major SQL commands similarly but may include proprietary extensions, functions, and syntax. Therefore, SQL code may require adjustments when moved between database platforms.
SQL was standardized by ANSI in 1986 and ISO in 1987.
Different database systems implement their own versions of SQL.
Most SQL implementations support core commands such as SELECT, INSERT, UPDATE, DELETE, and WHERE in similar ways.
Database vendors may add proprietary extensions and features beyond the SQL standard.
SQL knowledge is generally transferable, but platform-specific syntax may affect portability.
A set of commonly agreed rules and commands for accessing and manipulating relational databases.
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 system's specific version of SQL, including standard features and possible vendor-specific additions.
A database vendor-specific feature or syntax that extends beyond the core SQL standard.
A Relational Database Management System that stores data in related tables and provides SQL support.
“Can you explain what "SQL was standardized by ANSI in 1986 and ISO in 1987." means in simple terms?”