5.1. SQL About¶
- SQL¶
- Structured Query Language¶
Domain-specific language used in programming and designed for managing data held in a relational database management system (RDBMS), or for stream processing in a relational data stream management system (RDSMS). It is particularly useful in handling structured data, i.e. data incorporating relations among entities and variables. [#WikipediaSQL]_ [#RFC6922]_
- SELECT¶
SQL language operation to retrieve data from the database
- INSERT¶
SQL language operation to put data to the database
- UPDATE¶
SQL language operation to modify data in the database
- JOIN¶
SQL language operation to retrieve data from the database from multiple tables and merge them