{"id":1121,"date":"2022-10-20T11:19:19","date_gmt":"2022-10-20T15:19:19","guid":{"rendered":"https:\/\/folvera.commons.gc.cuny.edu\/?p=1121"},"modified":"2022-10-20T11:19:19","modified_gmt":"2022-10-20T15:19:19","slug":"introduction-to-structured-query-language-for-data-analytics-sf22sql1001-day-6","status":"publish","type":"post","link":"https:\/\/folvera.commons.gc.cuny.edu\/?p=1121","title":{"rendered":"Introduction to Structured Query Language for Data Analytics (SF22SQL1001) \u2014 Day 6"},"content":{"rendered":"<p>We have finally started making (<tt>CREATE<\/tt>), deleting (<tt>DROP<\/tt>) and changing (<tt>ALTER<\/tt>) data objects. We can now use all the material we have covered when getting data (<tt>SELECT<\/tt>) from tables and views in a database.<\/p>\n<p>Download the\u00a0<a href=\"https:\/\/folvera.commons.gc.cuny.edu\/wp-content\/blogs.dir\/2501\/files\/2022\/10\/SF22SQL1001_20221019.pdf\">class notes<\/a>\u00a0for day 6.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>We have finally started making (CREATE), deleting (DROP) and changing (ALTER) data objects. We can now use all the material we have covered when getting data (SELECT) from tables and views in a database. Download the\u00a0class notes\u00a0for day 6.<\/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-1121","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\/1121","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=1121"}],"version-history":[{"count":1,"href":"https:\/\/folvera.commons.gc.cuny.edu\/index.php?rest_route=\/wp\/v2\/posts\/1121\/revisions"}],"predecessor-version":[{"id":1123,"href":"https:\/\/folvera.commons.gc.cuny.edu\/index.php?rest_route=\/wp\/v2\/posts\/1121\/revisions\/1123"}],"wp:attachment":[{"href":"https:\/\/folvera.commons.gc.cuny.edu\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1121"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/folvera.commons.gc.cuny.edu\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1121"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/folvera.commons.gc.cuny.edu\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1121"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}