SQL (Structured query Language) is a standardized programming language that"s provided to regulate relational databases and perform miscellaneous operations top top the data in them. Initially created in the 1970s, SQL is regularly provided not only by database administrators, but also by developers writing data integration scripts and also data analysts looking to collection up and also run analysis queries.

You are watching: What does the acronym sql mean?

The uses of SQL include editing and enhancing database table and index structures; adding, updating and deleting rows that data; and retrieving subsets of info from within a database because that transaction processing and also analytics applications. Queries and also other SQL operations take it the type of commands written together statements -- frequently used SQL statements encompass select, add, insert, update, delete, create, alter and also truncate.

SQL became the de facto conventional programming language for relational databases after ~ they arised in the so late 1970s and also early 1980s. Additionally known as SQL databases, relational systems comprise a collection of tables include data in rows and columns. Each tower in a table coincides to a group of data -- because that example, customer surname or deal with -- while each row includes a data value for the intersecting column.

SQL standard and also proprietary extensions

An official SQL conventional was embraced by the American nationwide Standards academy (ANSI) in 1986 and then through the international Organization because that Standardization, recognized as ISO, in 1987. More than a half-dozen share updates come the standard have been released by the two standards breakthrough bodies because then; together of this writing, the many recent version is SQL:2011, approved the year.

Both proprietary and open resource relational database administration systems built about SQL are easily accessible for use by organizations. Lock include:

SAP Adaptive Server

However, countless of these database products support SQL with proprietary expansions to the traditional language because that procedural programming and also other functions. For example, Microsoft provides a collection of extensions dubbed Transact-SQL (T-SQL), when Oracle"s prolonged version the the standard is PL/SQL. As a result, the different variants that SQL offered by sellers aren"t fully compatible v one another.

SQL commands and syntax

SQL commands are divided into several different types, amongst them data manipulation language (DML) and data definition language (DDL) statements, transaction controls and security measures. The DML vocabulary is used to retrieve and also manipulate data, when DDL statements space for defining and modifying database structures. The transaction controls aid manage transaction processing, ensuring the transactions room either perfect or rolled back if errors or troubles occur. The security statements are offered to control database accessibility as well regarding create user roles and also permissions.

SQL syntax is the coding layout used in creating statements. Number 1 shows an example of a DDL statement created in Microsoft"s T-SQL to modify a database table in SQL Server 2016:

figure 1. An example of T-SQL password in SQL Server 2016. This is the password for the transform TABLE through (ONLINE = top top | OFF) option.

SQL-on-Hadoop tools

SQL-on-Hadoop ask engines room a newer offshoot that SQL that allow organizations with big data architectures built approximately Hadoop solution to take benefit of it rather of having to use more facility and less acquainted languages -- in particular, the MapReduce programming atmosphere for developing batch handling applications.

More 보다 a dozen SQL-on-Hadoop tools have become obtainable through Hadoop circulation providers and also other vendors; countless of them space open resource software or commercial version of such technologies. In addition, the Apache Spark handling engine, i m sorry is often used in conjunction v Hadoop, includes a Spark SQL module that an in similar way supports SQL-based programming.

See more: How To Make Ephedrine From Sugar, Biosynth: Homebrewing Ephedrine

In general, SQL-on-Hadoop is tho an arising technology, and most that the available tools don"t support every one of the functionality readily available in relational implementations of SQL. Yet they"re ending up being a continuous component that Hadoop deployments as providers look to obtain developers and also data experts with SQL skills involved in programming large data applications.

Next Steps

Everything you have to know around SAP HANA in-memory DBMS

Continue Reading about SQL (Structured ask Language)
Related Termsdatabase management system (DBMS)A database management system (DBMS) is mechanism software for creating and also managing databases. A DBMS provides it possible for finish ... SeecompletedefinitionDb2Db2 is a household of database monitoring system (DBMS) assets from IBM that offer a number of different operating device (OS) ... SeecompletedefinitiondenormalizationDenormalization is the process of adding precomputed redundant data come an otherwise normalized relational database to improve ... Seecompletedefinition