Introduction to SQL
A database is a systematic collection of data. Database systems are used to store, access, delete data. furthermore, it also systematically organize data in a database.This article briefly discuss about the SQL Revisions throughout this many years. Consider a cafeteria, which provides snacks and other eatable item to its customers. Traditionally, the snacks, juice, and other items are maintained manually using workers. As the number of customers increases, managing and handling becomes difficult .Now, maintaining part is difficult and store manager wants to switch from the manual gear to automatic gear i.e. As a result , Information on sales were noted down manually, and as the sales increases this information can be stored in an electronic database and a DBMS can be used to manage such a records.
Technology like Database and SQL has grown exponentially in recent years. MySQL uses the standardized Structured Query Language (SQL) to manage the database. SQL uses Domain Specific Languages .Generally used database management systems include Oracle, Access, SQLserver, Paradox, MySQL , are all claimed to use SQL. As a result , SQl is the most commonly used and a famous language.SQL could be used on minicomputers, mainframes, and personal computers. Unlike other programming language it is also divided into components.
SQL was adopted as a standard by the American National Standards Institute (ANSI) in 1986 as SQL-86 and the International Organization for Standardization (ISO) in 1987. It is maintained by ISO/IEC JTC 1, Information technology, Subcommittee SC 32, Data management and interchange. The standard is commonly denoted by the pattern: ISO/IEC 9075-n:yyyy Part n: title, or, as a shortcut, ISO/IEC 9075.
SQL has undergone through this many revisions [SQL Revisions]:
Source: Wikipedia/Microsoft SQL Server
|1986||SQL-86||SQL-87||First formalized by ANSI.|
|1989||SQL-89||FIPS 127-1||Minor revision that added integrity constraints and adopted as FIPS 127-1.|
|1992||SQL-92||SQL2 FIPS 127-2||Major revision (ISO 9075) Entry Level SQL-92 adopted as FIPS 127-2.|
|1999||SQL:1999||SQL3||Added regular expression matching and recursive queries (e.g. transitive closure) and triggers ; support for procedural and control-of-flow statements and non-scalar types (arrays) and some object-oriented features (e.g. structured types). Support for embedding SQL in Java (SQL/OLB) and vice versa (SQL/JRT).|
|2003||SQL:2003||Introduced XML-related features (SQL/XML) and window functions and standardized sequences and columns with auto-generated values (including identity-columns).|
|2006||SQL:2006||ISO/IEC 9075-14:2006 defines ways that SQL can be used with XML. It defines ways of importing and storing XML data in an SQL database and manipulating it within the database and publishing both XML and conventional SQL-data in XML form. In addition it lets applications integrate queries into their SQL code with XQuery .The XML Query Language published by the World Wide Web Consortium (W3C) to concurrently access ordinary SQL-data and XML documents.|
|2008||SQL:2008||Legalizes ORDER BY outside cursor definitions. Adds INSTEAD OF triggers TRUNCATE statement FETCH clause.|
|2011||SQL:2011||Adds temporal data (PERIOD FOR) (more information at: Temporal database#History). Enhancements for window functions and FETCH clause.|
|2016||SQL:2016||Adds row pattern matching and polymorphic table functions and JSON.|
Hope that you like this article, Drop your questions in the comment section down below.