| Published | 2022-01-31 |
| Platform | Udemy |
| Price | $39.99 |
| Subjects |
Learn to convert business questions into SQL queries, with this course you can learn MySQL from scratch
SQL (Structured Query Language) is a domain-specific language designed to manage and retrieve information from relational database management systems.
One of its main features is the handling of algebra and relational calculus to carry out queries in order to easily retrieve information from databases, as well as make changes to them.
Originally based on relational algebra and relational calculus, SQL consists of a data definition language, a data manipulation language, and a data control language. The scope of SQL includes data inserts, queries, updates and deletes, schema creation and modification, and data access control. Also SQL is sometimes described as a declarative language, it also includes procedural elements.
SQL was one of the first commercial languages for Edgar Frank Codd's relational model as described in his 1970 research paper The Relational Data Model for Large Shared Data Banks. Despite not fully adhering to the relational model described by Codd, it became the most widely used database language.
SQL became the standard of the American National Standards Institute (ANSI) in 1986 and the International Organization for Standardization (ISO) in 1987. Since then, the standard has been revised to include more features. Despite the existence of both standards, most SQL code is not completely portable between different database systems without other adjustments.