{"id":1164,"date":"2023-02-16T15:26:57","date_gmt":"2023-02-16T20:26:57","guid":{"rendered":"https:\/\/folvera.commons.gc.cuny.edu\/?p=1164"},"modified":"2023-02-16T15:26:57","modified_gmt":"2023-02-16T20:26:57","slug":"intermediate-structured-query-language-for-data-analytics-ws231-day-3","status":"publish","type":"post","link":"https:\/\/folvera.commons.gc.cuny.edu\/?p=1164","title":{"rendered":"Intermediate Structured Query Language for Data Analytics (WS231) \u2014 Day 3"},"content":{"rendered":"<p>We continue working with constraints \u2014 primary and foreign keys including composites. We have covered the need to normalize and clean our data as well as having fun with it \u2014 just make sure that you have backups.<\/p>\n<p>Download the\u00a0<a href=\"https:\/\/folvera.commons.gc.cuny.edu\/wp-content\/blogs.dir\/2501\/files\/2023\/02\/WS231.20230215.pdf\">class notes<\/a>\u00a0for day 3.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>We continue working with constraints \u2014 primary and foreign keys including composites. We have covered the need to normalize and clean our data as well as having fun with it \u2014 just make sure that you have backups. Download the\u00a0class notes\u00a0for day 3.<\/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":[32,3,1,2],"tags":[],"class_list":["post-1164","post","type-post","status-publish","format-standard","hentry","category-ws231","category-computer-programming","category-cuny","category-sql"],"_links":{"self":[{"href":"https:\/\/folvera.commons.gc.cuny.edu\/index.php?rest_route=\/wp\/v2\/posts\/1164","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=1164"}],"version-history":[{"count":1,"href":"https:\/\/folvera.commons.gc.cuny.edu\/index.php?rest_route=\/wp\/v2\/posts\/1164\/revisions"}],"predecessor-version":[{"id":1167,"href":"https:\/\/folvera.commons.gc.cuny.edu\/index.php?rest_route=\/wp\/v2\/posts\/1164\/revisions\/1167"}],"wp:attachment":[{"href":"https:\/\/folvera.commons.gc.cuny.edu\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1164"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/folvera.commons.gc.cuny.edu\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1164"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/folvera.commons.gc.cuny.edu\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1164"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}