{"id":644,"date":"2021-02-03T15:00:10","date_gmt":"2021-02-03T20:00:10","guid":{"rendered":"https:\/\/www.alpharithms.com\/?p=644"},"modified":"2021-07-27T11:24:31","modified_gmt":"2021-07-27T15:24:31","slug":"structured-query-language-sql","status":"publish","type":"post","link":"https:\/\/www.alpharithms.com\/structured-query-language-sql-100015\/","title":{"rendered":"Structured Query Language (SQL)"},"content":{"rendered":"

Structured Query Language (SQL) is a domain-centric language commonly used in database applications. Database management systems (DBMS), particularly relational<\/em> database management systems (RDBMS), use SQL to manage structured, related data.<\/p>\n

SQL’s primary advantages include the ability to access many records at once and the ability to do so without specifying\u00a0how<\/em> to access data. This second aspect makes SQL the single most popular query language for relational database systems<\/a>.<\/p>\n

SQL consists of many different types of statements which allows the sub-categorization of different sublanguages. Examples include data definition languages (DDL)<\/strong>, data manipulation\u00a0language (DML)<\/strong>, and data control languages (DCL)<\/strong>.<\/p>\n

SQL is one of the first query languages based on the 1966\u00a0A relational model of Data for Large Shared Data Banks<\/em> by Codd [1]. While not conforming\u00a0entirely\u00a0<\/em>to Codd’s specifications, SQL has become the ANSI-recognized official query language [2] for relational database applications in 1986 and is currently in the 5th edition of the specification [3].<\/p>\n

References<\/h2>\n
    \n
  1. Codd, E. F. \u201cA Relational Model of Data for Large Shared Data Banks.\u201d\u00a0Communications of the ACM<\/i>, vol. 13, no. 6, June 1970, pp. 377\u201387.\u00a0June 1970<\/i>, doi:10.1145\/362384.362685.<\/li>\n
  2. International Standards Organization (ISO). “Information Processing Systems – Database Language – SQL”. ISO 9075:1987<\/em>. June, 1987. ICS 35.060<\/li>\n
  3. International Standards Organization (ISO). “Information technology \u2014 Database languages \u2014 SQL \u2014 Part 1: Framework (SQL\/Framework)”. ISO 9075-1:2016<\/em>. December, 2016. ICS 35.060<\/li>\n<\/ol>\n","protected":false},"excerpt":{"rendered":"

    Structured Query Language (SQL) is a domain-centric language commonly used in database applications. Database management systems (DBMS), particularly relational database management systems (RDBMS), use SQL to manage structured, related data. SQL’s primary advantages include the ability to access many records at once and the ability to do so without specifying\u00a0how to access data. This second […]<\/p>\n","protected":false},"author":2,"featured_media":643,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"inline_featured_image":false,"footnotes":""},"categories":[1,260],"tags":[266,265,156,270,268,269,267],"acf":[],"_links":{"self":[{"href":"https:\/\/www.alpharithms.com\/wp-json\/wp\/v2\/posts\/644"}],"collection":[{"href":"https:\/\/www.alpharithms.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.alpharithms.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.alpharithms.com\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.alpharithms.com\/wp-json\/wp\/v2\/comments?post=644"}],"version-history":[{"count":1,"href":"https:\/\/www.alpharithms.com\/wp-json\/wp\/v2\/posts\/644\/revisions"}],"predecessor-version":[{"id":645,"href":"https:\/\/www.alpharithms.com\/wp-json\/wp\/v2\/posts\/644\/revisions\/645"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.alpharithms.com\/wp-json\/wp\/v2\/media\/643"}],"wp:attachment":[{"href":"https:\/\/www.alpharithms.com\/wp-json\/wp\/v2\/media?parent=644"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.alpharithms.com\/wp-json\/wp\/v2\/categories?post=644"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.alpharithms.com\/wp-json\/wp\/v2\/tags?post=644"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}