09-09-2017, 09:12 AM
Structured Query Language (SQL) is a standard computer language for relational database management and data manipulation. SQL is used to query, insert, update, and modify data. Most relational databases support SQL, which is an added benefit for database administrators (DBAs), as they are often required to support databases on several different platforms.
Developed for the first time in the early 1970s at IBM by Raymond Boyce and Donald Chamberlin, SQL was released commercially by Relational Software Inc. (now known as Oracle Corporation) in 1979. The current standard version of SQL is voluntary, National Institute of Standards (ANSI). Most major vendors also have proprietary versions built and built into ANSI SQL, for example, SQL * Plus (Oracle) and Transact-SQL (T-SQL) (Microsoft).
SQL applications include modification of the database table and index structures; add, update and delete rows of data; and retrieve subsets of information from within a database for transaction processing and analysis applications. Queries and other SQL operations take the form of commands written as statements - commonly used SQL statements include selecting, adding, inserting, updating, deleting, creating, altering, and truncating.
SQL became the de facto standard programming language for relational databases when they emerged in the late 1970s and early 1980s. Also known as SQL databases, relational systems comprise a set of tables that contain data in rows and columns. Each column in a table corresponds to a category of data, for example, customer name or address, while each row contains a data value for the intersection column.
Developed for the first time in the early 1970s at IBM by Raymond Boyce and Donald Chamberlin, SQL was released commercially by Relational Software Inc. (now known as Oracle Corporation) in 1979. The current standard version of SQL is voluntary, National Institute of Standards (ANSI). Most major vendors also have proprietary versions built and built into ANSI SQL, for example, SQL * Plus (Oracle) and Transact-SQL (T-SQL) (Microsoft).
SQL applications include modification of the database table and index structures; add, update and delete rows of data; and retrieve subsets of information from within a database for transaction processing and analysis applications. Queries and other SQL operations take the form of commands written as statements - commonly used SQL statements include selecting, adding, inserting, updating, deleting, creating, altering, and truncating.
SQL became the de facto standard programming language for relational databases when they emerged in the late 1970s and early 1980s. Also known as SQL databases, relational systems comprise a set of tables that contain data in rows and columns. Each column in a table corresponds to a category of data, for example, customer name or address, while each row contains a data value for the intersection column.