{"id":1136,"date":"2022-10-27T07:51:56","date_gmt":"2022-10-27T11:51:56","guid":{"rendered":"https:\/\/folvera.commons.gc.cuny.edu\/?p=1136"},"modified":"2022-10-27T07:58:53","modified_gmt":"2022-10-27T11:58:53","slug":"introduction-to-structured-query-language-for-data-analytics-sf22sql1001-day-8","status":"publish","type":"post","link":"https:\/\/folvera.commons.gc.cuny.edu\/?p=1136","title":{"rendered":"Introduction to Structured Query Language for Data Analytics (SF22SQL1001) \u2014 Day 8"},"content":{"rendered":"

We are two (2) more sessions away from the SF22SQL1001 final.<\/p>\n

We have covered lots of material \u2014<\/p>\n

    \n
  1. getting data from tables\/views (SELECT... FROM...<\/tt>),<\/li>\n
  2. joining tables\/views (INNER|LEFT|RIGHT JOIN<\/tt>) to make larger datasets,<\/li>\n
  3. filtering the output of queries (WHERE<\/tt>),<\/li>\n
  4. ordering the output of queries (ORDER BY<\/tt>),<\/li>\n
  5. grouping the output of queries when using aggregate functions (GROUP BY<\/tt>),<\/li>\n
  6. adding logic to queries (CASE... WHEN... THEN... END<\/tt>),<\/li>\n
  7. pushing new values into tables (INSERT INTO<\/tt>),<\/li>\n
  8. deleting selected rows (DELETE FROM<\/tt>) from a table,<\/li>\n
  9. deleting all rows (TRUNCATE<\/tt>) from a table,<\/li>\n
  10. making data objects (CREATE<\/tt>),<\/li>\n
  11. deleting objects (DROP<\/tt>)<\/li>\n
  12. modifying objects (ALTER<\/tt>)<\/li>\n
  13. and much more.<\/li>\n<\/ol>\n

    I hope you have been having lots of fun.<\/p>\n

    Download the\u00a0class notes<\/a> for day 8 \u2014 22 pages\u2019 worth of material.<\/p>\n","protected":false},"excerpt":{"rendered":"

    We are two (2) more sessions away from the SF22SQL1001 final. We have covered lots of material \u2014 getting data from tables\/views (SELECT… FROM…), joining tables\/views (INNER|LEFT|RIGHT JOIN) to make larger datasets, filtering the output of queries (WHERE), ordering the output of queries (ORDER BY), grouping the output of queries when using aggregate functions (GROUP […]<\/p>\n","protected":false},"author":7213,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"send_to_group_blog":0,"footnotes":""},"categories":[31,3,1,2],"tags":[],"class_list":["post-1136","post","type-post","status-publish","format-standard","hentry","category-sf22sql1001","category-computer-programming","category-cuny","category-sql"],"_links":{"self":[{"href":"https:\/\/folvera.commons.gc.cuny.edu\/index.php?rest_route=\/wp\/v2\/posts\/1136","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/folvera.commons.gc.cuny.edu\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/folvera.commons.gc.cuny.edu\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/folvera.commons.gc.cuny.edu\/index.php?rest_route=\/wp\/v2\/users\/7213"}],"replies":[{"embeddable":true,"href":"https:\/\/folvera.commons.gc.cuny.edu\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1136"}],"version-history":[{"count":2,"href":"https:\/\/folvera.commons.gc.cuny.edu\/index.php?rest_route=\/wp\/v2\/posts\/1136\/revisions"}],"predecessor-version":[{"id":1139,"href":"https:\/\/folvera.commons.gc.cuny.edu\/index.php?rest_route=\/wp\/v2\/posts\/1136\/revisions\/1139"}],"wp:attachment":[{"href":"https:\/\/folvera.commons.gc.cuny.edu\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1136"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/folvera.commons.gc.cuny.edu\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1136"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/folvera.commons.gc.cuny.edu\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1136"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}