{"id":850,"date":"2022-12-04T01:01:23","date_gmt":"2022-12-04T01:01:23","guid":{"rendered":"https:\/\/s-oneill.com\/sov02\/?p=850"},"modified":"2023-01-12T14:36:25","modified_gmt":"2023-01-12T14:36:25","slug":"sql","status":"publish","type":"post","link":"https:\/\/s-oneill.com\/sov02\/sql\/","title":{"rendered":"SQL"},"content":{"rendered":"<p>SQL is a relational database management system (RDBMS) that organizes data into tables (columns and rows). Tables can be linked together to form relationships to manage data efficiently.<\/p>\n<p>Several popular versions of SQL include:<\/p>\n<ul>\n<li>Microsoft SQL Server<\/li>\n<li>MySQL<\/li>\n<li>PostgreSQL<\/li>\n<li>Google BigQuery<\/li>\n<li>SQLight<\/li>\n<\/ul>\n<p><a href=\"https:\/\/towardsdatascience.com\/how-to-find-your-way-through-the-different-types-of-sql-26e3d3c20aab\" rel=\"noopener\" target=\"_blank\">This article<\/a> mentions some of the minor but important differences between the different SQL based languages.<\/p>\n<p><strong>SQL on the Web<\/strong><br \/>\nWeb applications that use RDBMS databases often make CRUD requests (Create, Read, Update and Delete) using SQL. These requests are typically handled using a separate web API (Application Programming Interface) which allows web developers to use a simple URL in their Web application to make potentially complex data requests.<\/p>\n<p><strong>SQL In Analytics<\/strong><br \/>\nThe Google Data Analytics Certification Course demonstrates several ways SQL can be used for cleaning and wrangling data for analysis by combining and filtering datasets. <\/p>\n<p>Links to SQL examples will be provided here in the future.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>SQL is a relational database management system (RDBMS) that organizes data into tables (columns and rows). Tables can be linked together to form relationships to manage data efficiently. Several popular versions of SQL include: Microsoft SQL Server MySQL PostgreSQL Google BigQuery SQLight This article mentions some of the minor but important differences between the different [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[57],"tags":[],"class_list":["post-850","post","type-post","status-publish","format-standard","hentry","category-data-analytics"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>SQL - s-oneill.com<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/s-oneill.com\/sov02\/sql\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SQL - s-oneill.com\" \/>\n<meta property=\"og:description\" content=\"SQL is a relational database management system (RDBMS) that organizes data into tables (columns and rows). Tables can be linked together to form relationships to manage data efficiently. Several popular versions of SQL include: Microsoft SQL Server MySQL PostgreSQL Google BigQuery SQLight This article mentions some of the minor but important differences between the different [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/s-oneill.com\/sov02\/sql\/\" \/>\n<meta property=\"og:site_name\" content=\"s-oneill.com\" \/>\n<meta property=\"article:published_time\" content=\"2022-12-04T01:01:23+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-01-12T14:36:25+00:00\" \/>\n<meta name=\"author\" content=\"Me(sean)\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Me(sean)\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/s-oneill.com\/sov02\/sql\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/s-oneill.com\/sov02\/sql\/\"},\"author\":{\"name\":\"Me(sean)\",\"@id\":\"https:\/\/s-oneill.com\/sov02\/#\/schema\/person\/ab11148c6ea273be80dddd8baec1a545\"},\"headline\":\"SQL\",\"datePublished\":\"2022-12-04T01:01:23+00:00\",\"dateModified\":\"2023-01-12T14:36:25+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/s-oneill.com\/sov02\/sql\/\"},\"wordCount\":151,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/s-oneill.com\/sov02\/#\/schema\/person\/a9217b5797251a243dfd504d7ad7d00a\"},\"articleSection\":[\"Data Analytics\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/s-oneill.com\/sov02\/sql\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/s-oneill.com\/sov02\/sql\/\",\"url\":\"https:\/\/s-oneill.com\/sov02\/sql\/\",\"name\":\"SQL - s-oneill.com\",\"isPartOf\":{\"@id\":\"https:\/\/s-oneill.com\/sov02\/#website\"},\"datePublished\":\"2022-12-04T01:01:23+00:00\",\"dateModified\":\"2023-01-12T14:36:25+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/s-oneill.com\/sov02\/sql\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/s-oneill.com\/sov02\/sql\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/s-oneill.com\/sov02\/sql\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/s-oneill.com\/sov02\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SQL\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/s-oneill.com\/sov02\/#website\",\"url\":\"https:\/\/s-oneill.com\/sov02\/\",\"name\":\"s-oneill.com\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/s-oneill.com\/sov02\/#\/schema\/person\/a9217b5797251a243dfd504d7ad7d00a\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/s-oneill.com\/sov02\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\/\/s-oneill.com\/sov02\/#\/schema\/person\/a9217b5797251a243dfd504d7ad7d00a\",\"name\":\"sean o\",\"logo\":{\"@id\":\"https:\/\/s-oneill.com\/sov02\/#\/schema\/person\/image\/\"},\"description\":\"Web dev over 15 years.\",\"sameAs\":[\"http:\/\/s-oneill.com\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/s-oneill.com\/sov02\/#\/schema\/person\/ab11148c6ea273be80dddd8baec1a545\",\"name\":\"Me(sean)\",\"url\":\"https:\/\/s-oneill.com\/sov02\/author\/user01\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"SQL - s-oneill.com","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/s-oneill.com\/sov02\/sql\/","og_locale":"en_US","og_type":"article","og_title":"SQL - s-oneill.com","og_description":"SQL is a relational database management system (RDBMS) that organizes data into tables (columns and rows). Tables can be linked together to form relationships to manage data efficiently. Several popular versions of SQL include: Microsoft SQL Server MySQL PostgreSQL Google BigQuery SQLight This article mentions some of the minor but important differences between the different [&hellip;]","og_url":"https:\/\/s-oneill.com\/sov02\/sql\/","og_site_name":"s-oneill.com","article_published_time":"2022-12-04T01:01:23+00:00","article_modified_time":"2023-01-12T14:36:25+00:00","author":"Me(sean)","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Me(sean)","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/s-oneill.com\/sov02\/sql\/#article","isPartOf":{"@id":"https:\/\/s-oneill.com\/sov02\/sql\/"},"author":{"name":"Me(sean)","@id":"https:\/\/s-oneill.com\/sov02\/#\/schema\/person\/ab11148c6ea273be80dddd8baec1a545"},"headline":"SQL","datePublished":"2022-12-04T01:01:23+00:00","dateModified":"2023-01-12T14:36:25+00:00","mainEntityOfPage":{"@id":"https:\/\/s-oneill.com\/sov02\/sql\/"},"wordCount":151,"commentCount":0,"publisher":{"@id":"https:\/\/s-oneill.com\/sov02\/#\/schema\/person\/a9217b5797251a243dfd504d7ad7d00a"},"articleSection":["Data Analytics"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/s-oneill.com\/sov02\/sql\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/s-oneill.com\/sov02\/sql\/","url":"https:\/\/s-oneill.com\/sov02\/sql\/","name":"SQL - s-oneill.com","isPartOf":{"@id":"https:\/\/s-oneill.com\/sov02\/#website"},"datePublished":"2022-12-04T01:01:23+00:00","dateModified":"2023-01-12T14:36:25+00:00","breadcrumb":{"@id":"https:\/\/s-oneill.com\/sov02\/sql\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/s-oneill.com\/sov02\/sql\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/s-oneill.com\/sov02\/sql\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/s-oneill.com\/sov02\/"},{"@type":"ListItem","position":2,"name":"SQL"}]},{"@type":"WebSite","@id":"https:\/\/s-oneill.com\/sov02\/#website","url":"https:\/\/s-oneill.com\/sov02\/","name":"s-oneill.com","description":"","publisher":{"@id":"https:\/\/s-oneill.com\/sov02\/#\/schema\/person\/a9217b5797251a243dfd504d7ad7d00a"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/s-oneill.com\/sov02\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":["Person","Organization"],"@id":"https:\/\/s-oneill.com\/sov02\/#\/schema\/person\/a9217b5797251a243dfd504d7ad7d00a","name":"sean o","logo":{"@id":"https:\/\/s-oneill.com\/sov02\/#\/schema\/person\/image\/"},"description":"Web dev over 15 years.","sameAs":["http:\/\/s-oneill.com"]},{"@type":"Person","@id":"https:\/\/s-oneill.com\/sov02\/#\/schema\/person\/ab11148c6ea273be80dddd8baec1a545","name":"Me(sean)","url":"https:\/\/s-oneill.com\/sov02\/author\/user01\/"}]}},"_links":{"self":[{"href":"https:\/\/s-oneill.com\/sov02\/wp-json\/wp\/v2\/posts\/850","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/s-oneill.com\/sov02\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/s-oneill.com\/sov02\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/s-oneill.com\/sov02\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/s-oneill.com\/sov02\/wp-json\/wp\/v2\/comments?post=850"}],"version-history":[{"count":4,"href":"https:\/\/s-oneill.com\/sov02\/wp-json\/wp\/v2\/posts\/850\/revisions"}],"predecessor-version":[{"id":892,"href":"https:\/\/s-oneill.com\/sov02\/wp-json\/wp\/v2\/posts\/850\/revisions\/892"}],"wp:attachment":[{"href":"https:\/\/s-oneill.com\/sov02\/wp-json\/wp\/v2\/media?parent=850"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/s-oneill.com\/sov02\/wp-json\/wp\/v2\/categories?post=850"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/s-oneill.com\/sov02\/wp-json\/wp\/v2\/tags?post=850"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}