{"id":9,"date":"2021-03-19T11:34:38","date_gmt":"2021-03-19T11:34:38","guid":{"rendered":"https:\/\/blogs.glowscotland.org.uk\/sh\/ahscomputingsql\/?page_id=9"},"modified":"2021-03-25T14:04:27","modified_gmt":"2021-03-25T14:04:27","slug":"sql","status":"publish","type":"page","link":"https:\/\/blogs.glowscotland.org.uk\/sh\/ahscomputingsql\/","title":{"rendered":"SQL"},"content":{"rendered":"<h1>Structured Query Language<\/h1>\n<p>Pronounced as either &#8220;<em>ess queue ell<\/em>&#8221; or &#8220;<em>sequel<\/em>&#8220;.<\/p>\n<p>SQL is a language that can be used to create databases, search databases, and modify records.<\/p>\n<p>There are several different versions of SQL &#8211; these notes use <strong>SQLite<\/strong>, which is suitable for small, portable databases.<\/p>\n<h1>SQLite 3<\/h1>\n<h1 style=\"margin-top: 1.71429rem;margin-bottom: 1.71429rem\"><img decoding=\"async\" class=\"alignright wp-image-15 size-medium\" style=\"margin-top: 0.857143rem;margin-bottom: 0.857143rem;margin-left: 1.71429rem\" src=\"https:\/\/glow-prod-sh.s3.eu-west-1.amazonaws.com\/sh\/public\/ahscomputingsql\/uploads\/sites\/3269\/2021\/03\/19114703\/SQLite370.svg_-300x142.png?X-Amz-Content-Sha256=UNSIGNED-PAYLOAD&#038;X-Amz-Security-Token=IQoJb3JpZ2luX2VjEHQaCWV1LXdlc3QtMSJHMEUCIF2JN0Db08cVdgnv6kmcp6pp5SA3JzHUgsj%2B6LOD8S8UAiEAyFNIXmN4DwZvT7XtO%2FuTdaPLLZfXAKM6pgm3SD3MZt0quQUIPRAFGgwyNzM1NzAxOTU0MzMiDNFYe7hcq5Iy6E%2BX8iqWBYoIH1jIWQPPoclxGhNGGO3rmzCoLpkUbMYPXrKDZ4Yh%2BCoMdOdu2zxRoRau317aoIcElNUuxJCfBwqjaHsneugoMMr8OcFYZPPDDLtD7NvFps9QQngORRZH4pQL%2Fg0zJpxDpl96ZD9Eps5NB%2FolsMfWE5iURVwV1W4LtGmkX56H9RBxc37mIzHWkXAUqUdzq1cuJF1pbo0Yhca24JaarnnXA8FnEfdISeYQ3c1bKF0NWjQwFwKH5rht3r%2F%2FzDoI7dWzREQEogIGTV%2FlgHC%2BHUKUp40S6kU0oanw4EV5F6YF1x7a3sAk9run60sic88TykvaXi3gcJixmA2i%2F2pCemZobvxeY9CEsTAJVj87QeM67mvyWOls84TuexnfIa35rDK6VTXgwmU%2BF2gi%2Bsbi1jIpF7EOuPk8a1hfG6Wt21PVleuyZRQvCEg3H0PizmQRM0EfcyOoUp2AYe59eFo%2FHyExoa2%2FbwVxKIBuhk5U7pyR0itpSWno6Pq4ZULpkYTsOnIfxvON8yzZSjaGFHyoMgfj%2B%2B87hamZRGLW7hGdj%2FpT1jtlHMbErI6ZvRegSC%2FAusCMa%2BG42BtljbwKZBUKcqI9sXNW86yBZftuu2qYL4No1Ivayoazmmsqvf%2FnZvpSIfUc58TqBwIm3cJRc4bOahFaAeJ2I35Ct3JCxdFfLNm2E%2FF2oTIq%2BCR34p53nzyN1Ni1plMuOwouFVgR3qz%2Bzb7fSJkRbrSNiOyo8PzVlBHBXFNf7HKavL6rVnt8374%2BNRn6B5hGJuu4bnrkHViH3RsDdG1mUs4rg2CltPEzsgmEJ2fIEbHWJB9BKHTeEeir3j7S8Chs%2BvgF5K2PxV5Psr3tQXI2Mu28iBQYUi7PJyO5rVruouFcMODPmdMGOrEBiSVaqbHHjzvh7dZWCOSYmtAcSe9Nh6%2FGFug8E%2FckRw17%2FXLMoU84XZau%2Fa10QY63Vnz2tLx8S7xzpeoXVhw5%2BDNlkxRhqiUJ8PiX6hnicDry0RxD87KYOiZnWDTRIK7hGyHuMoF2WnQRxBxVVQ4ogXSMw0RfMn1IrxdcVoALKOaP8EixkY2NFzDK2KpYYJKVCIqnkmX1GvmHCgW%2Fxto9lTCTv79LeThEr89e%2BsnlQ6X4&#038;X-Amz-Algorithm=AWS4-HMAC-SHA256&#038;X-Amz-Credential=ASIAT7MQN47UWIRQIWVQ%2F20260726%2Feu-west-1%2Fs3%2Faws4_request&#038;X-Amz-Date=20260726T202618Z&#038;X-Amz-SignedHeaders=host&#038;X-Amz-Expires=900&#038;X-Amz-Signature=690cc167ec73db66cab88039aab015bed0992dfc4de9bdaeb899d4140649a1ec\" alt=\"\" width=\"300\" height=\"142\" srcset=\"https:\/\/glow-prod-sh.s3.eu-west-1.amazonaws.com\/sh\/public\/ahscomputingsql\/uploads\/sites\/3269\/2021\/03\/19114703\/SQLite370.svg_-300x142.png?X-Amz-Content-Sha256=UNSIGNED-PAYLOAD&amp;X-Amz-Security-Token=IQoJb3JpZ2luX2VjEHQaCWV1LXdlc3QtMSJHMEUCIF2JN0Db08cVdgnv6kmcp6pp5SA3JzHUgsj%2B6LOD8S8UAiEAyFNIXmN4DwZvT7XtO%2FuTdaPLLZfXAKM6pgm3SD3MZt0quQUIPRAFGgwyNzM1NzAxOTU0MzMiDNFYe7hcq5Iy6E%2BX8iqWBYoIH1jIWQPPoclxGhNGGO3rmzCoLpkUbMYPXrKDZ4Yh%2BCoMdOdu2zxRoRau317aoIcElNUuxJCfBwqjaHsneugoMMr8OcFYZPPDDLtD7NvFps9QQngORRZH4pQL%2Fg0zJpxDpl96ZD9Eps5NB%2FolsMfWE5iURVwV1W4LtGmkX56H9RBxc37mIzHWkXAUqUdzq1cuJF1pbo0Yhca24JaarnnXA8FnEfdISeYQ3c1bKF0NWjQwFwKH5rht3r%2F%2FzDoI7dWzREQEogIGTV%2FlgHC%2BHUKUp40S6kU0oanw4EV5F6YF1x7a3sAk9run60sic88TykvaXi3gcJixmA2i%2F2pCemZobvxeY9CEsTAJVj87QeM67mvyWOls84TuexnfIa35rDK6VTXgwmU%2BF2gi%2Bsbi1jIpF7EOuPk8a1hfG6Wt21PVleuyZRQvCEg3H0PizmQRM0EfcyOoUp2AYe59eFo%2FHyExoa2%2FbwVxKIBuhk5U7pyR0itpSWno6Pq4ZULpkYTsOnIfxvON8yzZSjaGFHyoMgfj%2B%2B87hamZRGLW7hGdj%2FpT1jtlHMbErI6ZvRegSC%2FAusCMa%2BG42BtljbwKZBUKcqI9sXNW86yBZftuu2qYL4No1Ivayoazmmsqvf%2FnZvpSIfUc58TqBwIm3cJRc4bOahFaAeJ2I35Ct3JCxdFfLNm2E%2FF2oTIq%2BCR34p53nzyN1Ni1plMuOwouFVgR3qz%2Bzb7fSJkRbrSNiOyo8PzVlBHBXFNf7HKavL6rVnt8374%2BNRn6B5hGJuu4bnrkHViH3RsDdG1mUs4rg2CltPEzsgmEJ2fIEbHWJB9BKHTeEeir3j7S8Chs%2BvgF5K2PxV5Psr3tQXI2Mu28iBQYUi7PJyO5rVruouFcMODPmdMGOrEBiSVaqbHHjzvh7dZWCOSYmtAcSe9Nh6%2FGFug8E%2FckRw17%2FXLMoU84XZau%2Fa10QY63Vnz2tLx8S7xzpeoXVhw5%2BDNlkxRhqiUJ8PiX6hnicDry0RxD87KYOiZnWDTRIK7hGyHuMoF2WnQRxBxVVQ4ogXSMw0RfMn1IrxdcVoALKOaP8EixkY2NFzDK2KpYYJKVCIqnkmX1GvmHCgW%2Fxto9lTCTv79LeThEr89e%2BsnlQ6X4&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47UWIRQIWVQ%2F20260726%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20260726T202618Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=690cc167ec73db66cab88039aab015bed0992dfc4de9bdaeb899d4140649a1ec 300w, https:\/\/glow-prod-sh.s3.eu-west-1.amazonaws.com\/sh\/public\/ahscomputingsql\/uploads\/sites\/3269\/2021\/03\/19114703\/SQLite370.svg_-768x364.png?X-Amz-Content-Sha256=UNSIGNED-PAYLOAD&amp;X-Amz-Security-Token=IQoJb3JpZ2luX2VjEHQaCWV1LXdlc3QtMSJHMEUCIF2JN0Db08cVdgnv6kmcp6pp5SA3JzHUgsj%2B6LOD8S8UAiEAyFNIXmN4DwZvT7XtO%2FuTdaPLLZfXAKM6pgm3SD3MZt0quQUIPRAFGgwyNzM1NzAxOTU0MzMiDNFYe7hcq5Iy6E%2BX8iqWBYoIH1jIWQPPoclxGhNGGO3rmzCoLpkUbMYPXrKDZ4Yh%2BCoMdOdu2zxRoRau317aoIcElNUuxJCfBwqjaHsneugoMMr8OcFYZPPDDLtD7NvFps9QQngORRZH4pQL%2Fg0zJpxDpl96ZD9Eps5NB%2FolsMfWE5iURVwV1W4LtGmkX56H9RBxc37mIzHWkXAUqUdzq1cuJF1pbo0Yhca24JaarnnXA8FnEfdISeYQ3c1bKF0NWjQwFwKH5rht3r%2F%2FzDoI7dWzREQEogIGTV%2FlgHC%2BHUKUp40S6kU0oanw4EV5F6YF1x7a3sAk9run60sic88TykvaXi3gcJixmA2i%2F2pCemZobvxeY9CEsTAJVj87QeM67mvyWOls84TuexnfIa35rDK6VTXgwmU%2BF2gi%2Bsbi1jIpF7EOuPk8a1hfG6Wt21PVleuyZRQvCEg3H0PizmQRM0EfcyOoUp2AYe59eFo%2FHyExoa2%2FbwVxKIBuhk5U7pyR0itpSWno6Pq4ZULpkYTsOnIfxvON8yzZSjaGFHyoMgfj%2B%2B87hamZRGLW7hGdj%2FpT1jtlHMbErI6ZvRegSC%2FAusCMa%2BG42BtljbwKZBUKcqI9sXNW86yBZftuu2qYL4No1Ivayoazmmsqvf%2FnZvpSIfUc58TqBwIm3cJRc4bOahFaAeJ2I35Ct3JCxdFfLNm2E%2FF2oTIq%2BCR34p53nzyN1Ni1plMuOwouFVgR3qz%2Bzb7fSJkRbrSNiOyo8PzVlBHBXFNf7HKavL6rVnt8374%2BNRn6B5hGJuu4bnrkHViH3RsDdG1mUs4rg2CltPEzsgmEJ2fIEbHWJB9BKHTeEeir3j7S8Chs%2BvgF5K2PxV5Psr3tQXI2Mu28iBQYUi7PJyO5rVruouFcMODPmdMGOrEBiSVaqbHHjzvh7dZWCOSYmtAcSe9Nh6%2FGFug8E%2FckRw17%2FXLMoU84XZau%2Fa10QY63Vnz2tLx8S7xzpeoXVhw5%2BDNlkxRhqiUJ8PiX6hnicDry0RxD87KYOiZnWDTRIK7hGyHuMoF2WnQRxBxVVQ4ogXSMw0RfMn1IrxdcVoALKOaP8EixkY2NFzDK2KpYYJKVCIqnkmX1GvmHCgW%2Fxto9lTCTv79LeThEr89e%2BsnlQ6X4&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47UWIRQIWVQ%2F20260726%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20260726T202618Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=cc92890e4f4fcea795cac6bc4eb8226b5989f12a3f502d4f930cf318362568c1 768w, https:\/\/glow-prod-sh.s3.eu-west-1.amazonaws.com\/sh\/public\/ahscomputingsql\/uploads\/sites\/3269\/2021\/03\/19114703\/SQLite370.svg_-800x379.png?X-Amz-Content-Sha256=UNSIGNED-PAYLOAD&amp;X-Amz-Security-Token=IQoJb3JpZ2luX2VjEHQaCWV1LXdlc3QtMSJHMEUCIF2JN0Db08cVdgnv6kmcp6pp5SA3JzHUgsj%2B6LOD8S8UAiEAyFNIXmN4DwZvT7XtO%2FuTdaPLLZfXAKM6pgm3SD3MZt0quQUIPRAFGgwyNzM1NzAxOTU0MzMiDNFYe7hcq5Iy6E%2BX8iqWBYoIH1jIWQPPoclxGhNGGO3rmzCoLpkUbMYPXrKDZ4Yh%2BCoMdOdu2zxRoRau317aoIcElNUuxJCfBwqjaHsneugoMMr8OcFYZPPDDLtD7NvFps9QQngORRZH4pQL%2Fg0zJpxDpl96ZD9Eps5NB%2FolsMfWE5iURVwV1W4LtGmkX56H9RBxc37mIzHWkXAUqUdzq1cuJF1pbo0Yhca24JaarnnXA8FnEfdISeYQ3c1bKF0NWjQwFwKH5rht3r%2F%2FzDoI7dWzREQEogIGTV%2FlgHC%2BHUKUp40S6kU0oanw4EV5F6YF1x7a3sAk9run60sic88TykvaXi3gcJixmA2i%2F2pCemZobvxeY9CEsTAJVj87QeM67mvyWOls84TuexnfIa35rDK6VTXgwmU%2BF2gi%2Bsbi1jIpF7EOuPk8a1hfG6Wt21PVleuyZRQvCEg3H0PizmQRM0EfcyOoUp2AYe59eFo%2FHyExoa2%2FbwVxKIBuhk5U7pyR0itpSWno6Pq4ZULpkYTsOnIfxvON8yzZSjaGFHyoMgfj%2B%2B87hamZRGLW7hGdj%2FpT1jtlHMbErI6ZvRegSC%2FAusCMa%2BG42BtljbwKZBUKcqI9sXNW86yBZftuu2qYL4No1Ivayoazmmsqvf%2FnZvpSIfUc58TqBwIm3cJRc4bOahFaAeJ2I35Ct3JCxdFfLNm2E%2FF2oTIq%2BCR34p53nzyN1Ni1plMuOwouFVgR3qz%2Bzb7fSJkRbrSNiOyo8PzVlBHBXFNf7HKavL6rVnt8374%2BNRn6B5hGJuu4bnrkHViH3RsDdG1mUs4rg2CltPEzsgmEJ2fIEbHWJB9BKHTeEeir3j7S8Chs%2BvgF5K2PxV5Psr3tQXI2Mu28iBQYUi7PJyO5rVruouFcMODPmdMGOrEBiSVaqbHHjzvh7dZWCOSYmtAcSe9Nh6%2FGFug8E%2FckRw17%2FXLMoU84XZau%2Fa10QY63Vnz2tLx8S7xzpeoXVhw5%2BDNlkxRhqiUJ8PiX6hnicDry0RxD87KYOiZnWDTRIK7hGyHuMoF2WnQRxBxVVQ4ogXSMw0RfMn1IrxdcVoALKOaP8EixkY2NFzDK2KpYYJKVCIqnkmX1GvmHCgW%2Fxto9lTCTv79LeThEr89e%2BsnlQ6X4&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47UWIRQIWVQ%2F20260726%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20260726T202618Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=8aa28cffcc1d6e0288d47976cb4f152617171bf04ca6e4d7faffab2d8bcde0dd 800w, https:\/\/blogs.glowscotland.org.uk\/sh\/public\/ahscomputingsql\/uploads\/sites\/3269\/2021\/03\/19114703\/SQLite370.svg_.png 1024w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/h1>\n<p>SQLite is a free version of SQL.<\/p>\n<p>SQLite is the most widely deployed database in the world.<\/p>\n<p>SQLite is found in:<\/p>\n<ul>\n<li>every Android and iOS device,<\/li>\n<li>every Mac and Windows10 machine,<\/li>\n<li>every Firefox, Chrome, and Safari web browser<\/li>\n<li>every instance of Skype, iTunes, Dropbox client, QuickBooks, PHP and Python<\/li>\n<li>most television sets and set-top cable boxes, automotive multimedia systems,<\/li>\n<li>and countless millions of other applications.<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Structured Query Language Pronounced as either &#8220;ess queue ell&#8221; or &#8220;sequel&#8220;. SQL is a language that can be used to create databases, search databases, and modify records. There are several different versions of SQL &#8211; these notes use SQLite, which is suitable for small, portable databases. SQLite 3 SQLite is a free version of SQL. SQLite is the most widely deployed database in the world. SQLite is found in: every<\/p>\n<p><a class=\"more-link\" href=\"https:\/\/blogs.glowscotland.org.uk\/sh\/ahscomputingsql\/\">Read More<\/a><\/p>\n","protected":false},"author":7,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-9","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/blogs.glowscotland.org.uk\/sh\/ahscomputingsql\/wp-json\/wp\/v2\/pages\/9","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blogs.glowscotland.org.uk\/sh\/ahscomputingsql\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/blogs.glowscotland.org.uk\/sh\/ahscomputingsql\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/blogs.glowscotland.org.uk\/sh\/ahscomputingsql\/wp-json\/wp\/v2\/users\/7"}],"replies":[{"embeddable":true,"href":"https:\/\/blogs.glowscotland.org.uk\/sh\/ahscomputingsql\/wp-json\/wp\/v2\/comments?post=9"}],"version-history":[{"count":6,"href":"https:\/\/blogs.glowscotland.org.uk\/sh\/ahscomputingsql\/wp-json\/wp\/v2\/pages\/9\/revisions"}],"predecessor-version":[{"id":390,"href":"https:\/\/blogs.glowscotland.org.uk\/sh\/ahscomputingsql\/wp-json\/wp\/v2\/pages\/9\/revisions\/390"}],"wp:attachment":[{"href":"https:\/\/blogs.glowscotland.org.uk\/sh\/ahscomputingsql\/wp-json\/wp\/v2\/media?parent=9"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}